Scary DBA Halloween Special
Not so much my special as SQL Saturday #59's Special. These guys in NYC are pulling out all the stops....
2010-10-29
1,380 reads
Not so much my special as SQL Saturday #59's Special. These guys in NYC are pulling out all the stops....
2010-10-29
1,380 reads
During the PASS Summit I have again been given the opportunity to keep my laptop plugged in… as long as...
2010-10-28
764 reads
I get the call, you get the call, everyone gets the call. “Hey, my app/procedure/query/report is running slow.” Now what...
2010-10-28
700 reads
Are you looking for opportunities to show off your elite writing skills and consumate SQL Server knowledge? Want a chance...
2010-10-28
620 reads
The SQLRally, a new PASS initiative taking place in the spring, is going to be a community driven event. This...
2010-10-28
1,512 reads
I’ll be presenting a practice run at one of my PASS Summit presentations, Identifying Common Performance Problems using Execution Plans,...
2010-10-27
665 reads
Benjamin Nevarez (blog) has been working really hard on a book on the Query Optimizer. It just got finished in...
2010-10-26
592 reads
The SQLRally, a new PASS initiative taking place in the spring, is going to be a community driven event. This...
2010-10-26
1,059 reads
I can’t believe I missed this one in all the posts and recommendations I’ve been making about great sessions coming...
2010-10-25
437 reads
I received word over the weekend that my precon application had made it past committee and was now subject to...
2010-10-25
603 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