Database Drops in SQL 2012
In the previous article on this topic (which can be read here), I discussed the problem of having a database get...
2015-07-06 (first published: 2015-07-01)
2,073 reads
SQL RNNR
Database Drops in SQL 2012
In the previous article on this topic (which can be read here), I discussed the problem of having a database get dropped and the need to find out who dropped...
2015-07-01
22 reads
SQL Cruise Mediterranean+
This is a post that is looooong overdue. I have intended to write some of this at least since the...
2015-06-24
654 reads
SQL Cruise Mediterranean+
This is a post that is looooong overdue. I have intended to write some of this at least since the first SQL Cruise I attended back in 2013 (in...
2015-06-24
11 reads
Reading Extended Event File Session Data
Using Extended Events to trap/trace information allows the trapping of that information to various targets. One of the targets I will...
2015-06-21
1,493 reads
Reading Extended Event File Session Data
Using Extended Events to trap/trace information allows the trapping of that information to various targets. One of the targets I will frequently tell people to use is the file target....
2015-06-21
1 reads
Execution Plans in Extended Events
Extended Events is a wonderful tool. Execution Plans are also some wonderful things – or are a wonderful tool as well. Both...
2015-06-17
1,111 reads
Execution Plans in Extended Events
Extended Events is a wonderful tool. Execution Plans are also some wonderful things – or are a wonderful tool as well. Both of these tools are fantastic for troubleshooting. Combined,...
2015-06-17
5 reads
Adventures with NOLOCK
Some of the beauty of being a database professional is the opportunity to deal with our friend NOLOCK. For one reason...
2015-06-25 (first published: 2015-06-15)
3,417 reads
Adventures with NOLOCK
Some of the beauty of being a database professional is the opportunity to deal with our friend NOLOCK. For one reason or another this query directive (yes I am calling...
2015-06-15
1 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers