Welcome to GregDodd.me, a place for me to write about things I have learnt and done mainly in SQL Server, but also in Windows Server and maybe even on occasions writing application code. Find out more about what I do here.
There are many different ways to store integers in SQL, how do you know which is the best?
At Microsoft Ignite today, the SQL 2017 release date was finally announced for a week from now, on October 2. SQL 2017 is exciting because of the new Linux and Docker capabilities. Docker in particular will be an interesting one to see, particularly for dev/test environments where the ability to spin up and throw away …
I came across this familiar error recently when writing some scripts. Normally I see this error when doing an insert, and the number of columns you’ve specified doesn’t match the number of values you’ve provided. But this time it was in an UPDATE script.