Changing of the Guard
A few weeks ago Andy Leonard (Blog | Twitter) announced that he was stepping down from his position as PASS Regional...
2010-08-25
375 reads
A few weeks ago Andy Leonard (Blog | Twitter) announced that he was stepping down from his position as PASS Regional...
2010-08-25
375 reads
As we continue with the puzzles, I will continue to introduce new MDX functions. In this puzzle the requirements are...
2010-08-25
621 reads
Not a sound from the pavement
Have you ever come across a SQL query that used to run faster? Has that...
2010-08-25
3,295 reads
Did you ever set a goal and then sort of … demolish it without realizing it?
That has happened this year....
2010-08-25
353 reads
I think the shirt says it all
If you’ve been under a rock the last few weeks you may not know...
2010-08-25
520 reads
Hey Folks,
We have some great speakers coming up at the SFSSUG in South Florida. Check out Devin Knight here talking...
2010-08-25
665 reads
So far I have seen lots of blogs about SQLPASS regarding the Slate for this years BoD. I do not...
2010-08-25
693 reads
You don’t need log backups. You don’t. They aren’t required for SQL Server to function.
The place when you don’t need...
2010-08-25
738 reads
What are the character traits of outstanding SQL Server Database Administrators (DBA) ?
You know what I’m talking about. There are...
2010-08-24
966 reads
Funny how if take time for longer conversations, ones that ramble, you often learn interesting things that you just wouldn’t...
2010-08-24
1,040 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