PASS DBA Virtual Chapter Trimming Indexes, Getting Your Database in Shape
Hello Dear Reader! Tomorrow at 12 noon eastern I’ll be presenting for the PASS DBA Virtual chapter, click here to...
2012-10-23
1,017 reads
Hello Dear Reader! Tomorrow at 12 noon eastern I’ll be presenting for the PASS DBA Virtual chapter, click here to...
2012-10-23
1,017 reads
http://www.flickr.com/photos/caledonia09/4999119065/
Hello Dear Reader, over here at Pragmatic Works we’ve been growing like weeds. For the most part we are looking...
2012-10-18
2,410 reads
Hello Dear Reader SQL Saturday 151 is just around the corner. If you haven't registerd there is still time to...
2012-09-27
1,716 reads
http://www.flickr.com/photos/cyndydoty/2087680308/Hello Dear Reader the PASS Summit is approaching and with that the program committee sent out a request for Lightening...
2012-08-20
1,049 reads
This one comes straight from the email bag. A friend recently had a problem, they were placing TDE on a...
2012-08-17 (first published: 2012-08-13)
5,441 reads
Hello Dear Reader, SQL Saturday 151 Orlando is picking up steam. The Pre-Con’s have been named and they are fantastic. ...
2012-08-16
738 reads
Hello Dear Reader, I came across an interesting discovery about a year ago and realized I’d never written about it. ...
2012-08-14
1,049 reads
I talk a lot about compression. I’ve blogged a pretty decent amount on it as well. One of the things...
2012-08-08
7,595 reads
I just finished this book. Literally. Sitting on an airplane in route from Orlando to Charlotte NC. I got up...
2012-08-07
990 reads
http://www.flickr.com/photos/brickapolis/5474835288/
I was working with a friend last week, doing SQL related teaching and tune ups. Earlier this week I had...
2012-08-06
4,223 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers