We love xp_fixeddrives here, it’s a quick and simple way to see how much space you’ve got available on your drives. But there are just a couple of things...
2019-07-17 (first published: 2019-07-03)
838 reads
I’ll be coming to SQL Saturday #890 – Austin in just over a week. Austin is a great technology town, and this should be one of the larger SQL...
2019-07-03
47 reads
I am so excited and honored to have been awarded my second Data Platform MVP from Microsoft on Monday. It’s been a crazy busy 18 months and the next...
2019-07-03
12 reads
This article demonstrates how to use Extended Events to determine if a database is being used by someone or something.
Related Posts:
Monitor Database Offline Events November 15, 2018
Audit Logons...
2019-07-03
19 reads
This article demonstrates how to use Extended Events to determine if a database is being used by someone or something.
Related Posts:
Finding Deprecated Uses in SQL Server November 7, 2016...
2019-07-22 (first published: 2019-07-03)
975 reads
The index is very important and powerful object...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-07-03
190 reads
A couple of weeks ago I came across an awesome GitHub repo called KubeInvaders which is brilliant work of Eugenio Marzo (b|t) KubeInvaders allows you to play Space Invaders...
2019-07-26 (first published: 2019-07-03)
472 reads
2019-07-02
10 reads
2019-07-02
7 reads
Ever since Microsoft said SQL would run on Linux, I was excited. Finally, all the Linux administrators I had worked with could be quiet and the Oracle DBAs that...
2019-07-02
14 reads
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
The STIG is detailed, which is a good thing, but I found myself wanting...
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers