TSQL Tuesday #62: Invitation to Healthy SQL – Why Page Verify?
I don’t think anyone’s ever been happy to get a support call at 11pm on a Saturday night. However this...
2015-01-15 (first published: 2015-01-13)
6,297 reads
I don’t think anyone’s ever been happy to get a support call at 11pm on a Saturday night. However this...
2015-01-15 (first published: 2015-01-13)
6,297 reads
Over the years I’ve done a number of posts on various aspects of security. In fact the first thing I...
2015-01-12
521 reads
First this type of error is because a subquery returned more than one row when it wasn’t allowed to. In...
2015-01-07
1,278 reads
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be...
2015-01-08 (first published: 2015-01-05)
6,249 reads
The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog.
Here’s an excerpt:
The Louvre Museum has 8.5 million...
2014-12-30
919 reads
I work for a large organization that over the last few years has been doing a LOT of reorgs. And...
2014-12-31 (first published: 2014-12-29)
5,859 reads
So I’ve written my second article for SQL Shack. This time instead of an overview of auditing options in sql...
2014-12-29
1,205 reads
The log file is one of those parts of SQL Server I find fascinating. For instance it is composed of...
2014-12-23 (first published: 2014-12-17)
5,828 reads
‘Twas 4:45 Friday, and all through the office
not a creature was stirring, not even the bosses.
The code was checked in,...
2014-12-25 (first published: 2014-12-16)
5,351 reads
This is just something I was curious about. I ran my tests and got an answer and now I thought...
2014-12-15
1,321 reads
Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most...
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
I have the user Managed identity <myusermanagedidentity> , granted it carte blanche alter...
First off, my apologies for what could potentially be a bad title! I am...
I've inherited a couple of rather large databases from my ex-colleague when I join...
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers