3 Weeks to the PASS Summit
The PASS Summit is only three weeks away and I’m getting awfully excited. It’s not too late to register. Heck,...
2009-10-10
623 reads
The PASS Summit is only three weeks away and I’m getting awfully excited. It’s not too late to register. Heck,...
2009-10-10
623 reads
Well, part of one anyway. I wrote three chapters of Rob Walter’s new book, Beginning SQL Server 2008 Administration. I...
2009-10-10
540 reads
Brent Ozar, Andy Warren and Jeremiah Peschka have put together a blogger award called the PASS Log Reader Award. I...
2009-10-08
719 reads
We had a good night with 13 people attending. I ran unopposed for president of SNESSUG for my second, and...
2009-10-08
593 reads
Another frequently heard story is that stored procedures get and reuse execution plans, but ad hoc queries do not. A...
2009-10-07
3,203 reads
Ohio?
I’m presenting on Thursday to the Columbus SQL Server Users Group, home of the newly minted MVP, Jeremiah Peschka (congrats again)....
2009-10-06
526 reads
Another frequently heard story is that stored procedures get and reuse execution plans, but ad hoc queries do not. A...
2009-10-05
3,195 reads
Great news. We’ve managed to get one article all the way through the process. We’ll have our first publication out...
2009-10-02
710 reads
A little cheap thrill for me. I passed 50,000 views on the blog yesterday. Thanks to everyone who has stopped...
2009-09-30
1,382 reads
There’s a very common belief among DBA’s: Stored procedures are pre-compiled. I had someone tell me all about it just...
2009-09-30
1,874 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