Pushing myself to go places I haven’t before These last couple months have been unlike any I’ve experienced. I’ve watched the economy tank. I’ve watched suffering and division and pain. I’ve seen some retreat into themselves. I’ve done it myself at times. What I did differently was signed up for[…]
SQL Server development and deployment can be a difficult and slow process at times. This is especially difficult with all of the automation and quick deployment with modern development IDEs, such as Visual Studios. Having spent many years developing, reviewing and deploying code, I figured I would go over some[…]
When it comes to using SQL Server for your application databases, there are a lot of settings and configurations available that can improve environment speeds. While this might not make your super-slow query become instantaneous, it should improve the overall performance of your SQL Server in most scenarios. Without further[…]
What is a Health Check? Everyone wants their SQL Server to run faster. When SQL is running fast, it means that your applications load quicker. It means that you don’t need to spend large capital costs on a new server or an expensive SAN upgrade. To get there, you[…]
If anyone has heard me talk about SQL development, they know I like unit testing a little too much. I don’t mind, though. During my years as a DBA, I developed an appropriate fear and loathing of bad code, so I suppose this is the carryover from all those years[…]
I was attending a SQL Server 2016 launch event organized by PASS MN and the Minnesota BI User Group and I was listening to one of the Azure features with StretchDB. The claim was that it was very cost effective to have your archive data automagically shipped off to the[…]