Latest Blog Posts
Last week I blogged about how you can turn on Dark Theme in SSMS 2016 but that it’s unfinished and you can use it at your own risk.
As good quality 4K monitors in the 30+ inch range continue to get cheaper & cheaper I find myself wanting to have… Read more
I’m excited to announce that I have been named a Friend of Redgate for 2017. The program targets influential people in their respective technical communities such as SQL, .NET and ALM and enables us to participate in the conversation around product and community development.
As a multi-year awardee in the… Read more
Proactive Reporting for SQL Server
If you’re a return reader of this blog you know I write often about monitoring and performance of Availability Groups. I’m a very big proponent of using monitoring techniques to ensure you’re meeting your service level agreements in terms of recovery time objective and recovery… Read more
There are lots of tasks that are easily accomplished with bot h PowerShell and T-SQL.
This is something that has caused me some grief in my life as a DBA. I hesitate to call it a bug, but this little gottcha resurfaced in a change that was submitted by a teammate just today. So I wanted to share while it was fresh in my mind. Read more
In this module you will learn how to use the Box and Whiskers (Brad) Power BI Custom Visual. This is the second of two Box and Whiskers visuals that we have covered (You can learn more about the first one here). The Box and Whiskers chart is used to… Read more
2017 is trundling along now, this week I’ve been reading…
The GitLab incident report
We’ve all had that moment of “what did I just do??” Here’s how the guys at Gitlab responded to such a moment.
Where is that Preemptive Wait coming from? Database Ownership and Performance: a journey through SQL Server internals with XEvents, Windbg and Wireshark
0 comments, 1,053 reads
Posted in Andreas Wolter SQL Server & BI blog (English / German) on 2 February 2017
This is the seventh part in the series: SQL Server and Continuous Integration. This post demonstrates the use of GitLab to build SQL Server projects. I use ReadyRoll for my SQL Server projects but SSDT projects could also be built with GitLab. Topics covered so far in this series… Read more
When you setup TDE, you need to create a DMK (Database Master Key) in the master database if one doesn’t exist. This key forms the basis of a chain of protection for your data inside of the SQL Server instance. The hierarchy is:
- The DMK exists in the master…
People always ask me what tools I use. Mostly this question comes from the topic of monitoring. I can honestly say that I don’t love any tools and you shouldn’t either.
My time at Microsoft placed me at nearly 300 different clients. As a Microsoft employee I never liked saying,… Read more
I’m very pleased, humbled, surprised and overall gleeful to announce I’m awarded the Microsoft Data Platform MVP 2017 Award.
This is a great honor and I’m grateful for all the support I’ve received of Microsoft, my peers and the SQL Server community over the past years. I’d like to… Read more
I’m heading back across the Atlantic this February for SQL Konferenz. This is an intimate SQL Server event in Darmstadt (near Frankfurt). I was fortunate to be picked to speak in 2015, but skipped 2016 as the timing wasn’t good. This year, things lined up for me, and I’ll… Read more
When you open SSMS a connection window automatically comes up. Then once you pick your server, connection type, username and password (if needed) you get an object explorer connection.
But what if that isn’t what you want?