Why bother encrypting? As a SQL Server DBA I am primarily responsible for making sure my client’s data is protected and available amongst other things. In many cases I have gone to clients and projects to find that sensitive data is not protected as well as it could be. Most times development is still underway and the security is a …
SQL Cruise day 2 – First sessions
Learning the ropes SQL Cruise day 2 started earlier than I wanted, I believe the old naval term was ‘at sparrow’s fart‘.
SQL Server version table
** Updated on 10/13/2014 with latest SQL Server 2014 release information ** To ensure my clients and I are running on the proper version of SQL Server I have created a reference table that contains all the SQL Server versions since 7.0. The script to create the table is too large to include here, but I have added an option …
Gain exclusive control of a database
Last night a client tried to ruin a script to enable Read_Committed_snapshot on a SQL database. There were so many connections that kept popping up, even after restarts, that they were not able to change the setting.
Embrace your inner Hedgehog!
As I was sorting out my office and getting new furniture setup I came across some scratch notes from when I listened to the audio of Jim Collin’s Good to Great book last year. The notes were about the hedgehog concept in particular and it is a pretty interesting concept. I strongly believe it was one of the motivating factors …
A Day in the life of: Me – A DBA Team lead
After reading through Erin Stellato’s (blog | twitter) TSQL2SDAY topic & reponses I was inspired to log one of my days. I decided that July 30, 2012 would be that day. Here’s how that day evolved:
- Page 1 of 2
- 1
- 2