Getting Excited: SQLBits is Coming!
Other than changing planes once at Heathrow Airport, I've never been to England, so I'm getting really excited about traveling...
2011-09-19
855 reads
Other than changing planes once at Heathrow Airport, I've never been to England, so I'm getting really excited about traveling...
2011-09-19
855 reads
Last weekend, as I was waiting for the start of the performance of the Cleveland Orchestra at its summer outdoor...
2011-08-31
1,777 reads
As Adam Machanic said, Fall is the busy season for speaking, and it will be for me. Here's a brief...
2011-08-22
754 reads
For the last year and a half or so I've been presenting a session on how to gather perfmon data...
2011-08-21
2,237 reads
Last fall, and winter, and spring I was part of the PASS Election Review Committee. It was interesting, sometimes fun,...
2011-08-11
614 reads
The IT Con event this Saturday, June 18, is an event similar to SQL Saturday. It has three tracks, an...
2011-06-16
759 reads
Mark Freeman (@m60freeman) posted a question on Twitter using the #sqlhelp hashtag today, asking "Does anyone have a script to...
2011-06-03
5,796 reads
Security is an important consideration when designing a database application. Who can get access to what data? How much damage...
2011-05-31
2,095 reads
Yesterday I delivered a session for the PASS DBA Virtual Chapter on Service Broker. In preparing for the session I...
2011-05-26
1,265 reads
Over time it's easy to lose track of the things you set up to get work done. As a consultant,...
2011-05-25
1,170 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