I’m on the new SQLPlayer Podcast
Me, Damian Widera, and Kamil Nowinski in Wroclaw On my Poland trip, I sat down with Kamil Nowinski and Damian Widera to talk about how I got started with presenting, why I don’t use PowerShell (but you should), how sp_Blitz ended up on Github, my …
What You Need To Know About DR Testing
Practice makes perfect. That’s true of everything, including disaster recovery. If you aren’t already testing your DR plan, you should be – here’s what you need to know to get started.
Introduction to Azure SQL Datab Sync
The majority of Azure SQL Database related features reach their General Availability (GA) stage relatively quickly. There are however, some exceptions. The most prominent example in this category is likely Azure SQL Data Sync, which has remained in Pre …
Azure DWH part 10: WPF and Azure SQL Data Warehouse
In this article, we will show how to create a WPF application ans show how to insert data to ASDW. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix …
SQL SERVER – Running CHECKDB with Minimum Repair Level
“How do I run CHECKDB with Minimum Repair Level?” When you run a blog with a million views a month, one must expect every kind of audience on the blog and author should be not judge every single email. It is almost impossible to correct the …
What’s in a name? How should SQL Server 2017 Graph Edge tables be named?
Dennes Torres recently wrote a really excellent article introducing Graph Objects in SQL Server 2017. You’ll find it here: https://www.simple-talk.com/sql/t-sql-programming/sql-graph-objects-sql-server-2017-good-bad/ I’ve also recently publ …
What does BACKUP WITH NAME Command do? – Interview Question of the Week #130
Questions: What does BACKUP WITH NAME Command do? Answer: Nothing more than naming your database backup. Honestly, I was recently asked this question by a user and I was a bit lost when I heard this one. To find the answer, I had to search the internet …
SQL SERVER – An Error Occurred While Obtaining the Dedicated Administrator Connection (DAC) Port
Microsoft SQL Server has given an option to connect to SQL Server when normal connections can’t be made because of any reasons. This feature is called as Dedicate Administrator Connection (DAC). You can read more about DAC over here. Diagnostic C …
sp_AllNightLog: ¿Por que los queues?
Building stuff I sometimes really hate coming up with ideas, and much prefer someone to just say “I want this” so I can go out into the world and figure out how to do that. Occasionally though, I realize that I’m not going to get all …
Troubleshooting CPU Performance on VMware
Jonathan Kehayias discusses SQL Server on VMware, and how to monitor CPU performance – with or without access to vCenter.
PowerShell Tool Time: The Tool Framework
Start learning Powershell (PoSh) for SQL Server and improve your ability to write utilities that will make your job easier.
SQL SERVER – The Patch Installer has Failed to Update the Shared Features
Applying a patch in SQL Server is a planned process which is followed across various companies. Most of the companies take time to apply the patch to make sure the stability of the patch can be validated. Let us see an error related to patch installer. …
Calling all user group leaders! We want to present for you again in 2017!
So far this year, we at SQLskills have presented remotely (and a few in-person) to 61 user groups and PASS virtual chapters around the world, and we have 13 more scheduled! Now we’re into the second half of 2017, we’d like to schedule …
SQL Server Diagnostic Information Queries for July 2017
This month, there are more minor updates to the all of the versions of the queries. I usually make additional minor updates to the queries during the month, so if you are in doubt, downloading the latest version is always a good idea. Rather than havin …
New Stack Overflow Public Database Available (2017-06)
Nick Craver and the kind folks at Stack Overflow publish their data export periodically with your questions, answers, comments, user info, and more. It’s available as an XML data dump, which I then take and import into SQL Server for teaching per …