Note: Since I wrote this dbatools had come out with an easier approach that you should check out here. Our Problem In a shared in environment you may have hundreds of databases with the same schema but depending on the data loaded into them not all of them will benefit
A recent project involved setting up encrypted connections on all our SQL Servers. To this we would have to install a certificate in on the server and restart the SQL Server service. Direction on how to do this on an individual instance are provided by Microsoft. We have test environments
This month’s T-SQL Tuesday is brought to us by Kendra Little (blog | @Kendra_Little). Kendra asked to write about interviewing patterns and anti-patterns and to be careful to protect our past/current employers and candidates. I’m going to talk about things I should have done better for interview that are really technical things