Why VS Code Increases my Productivity
Last week I was showing a co-worker some PowerShell code and he asked what the editor was that I was using. Visual Studio Code I said. Why do you use that? W...
Last week I was showing a co-worker some PowerShell code and he asked what the editor was that I was using. Visual Studio Code I said. Why do you use that? W...
WARNING – Contains Orange and light-hearted photos 😉 I have returned home from SQLBits 2017 The Disco Edition. I am exhausted, my body is pointing out to me...
NOTE - Updated November 2022 for this site and the correct command name. There are times when DBA’s are required to export database user permissions to a fi...
A good security practice is to backup our SQL Servers to a network share but not allow users to be able to browse the share. How can we ensure that our SQL S...
SQL Server uses identity columns to auto generate values, normally keys. When you create an identity column, it has a data type and that data type has a maxi...