SQL University – Disk Capacity Planning
This week at SQL University we are talking about capacity planning. I am the guest lecturer for this topic, and...
2010-07-28
5,048 reads
Interviewed by Andy Leonard
Andy Leonard is posting interviews of all the candidates PASS Board of Directors on his blog and mine is up...
2010-07-28
392 reads
Interviewing for the PASS Board of Directors
My nomination application made it through the committee. I got an email yesterday telling me that I needed to schedule...
2010-07-28
804 reads
PASS Update #38 (SQLSaturday Wiki)
For the past couple years we’ve had a few different documents that covered how to run a SQLSaturday, but as...
2010-07-28
648 reads
Presenting at SQLSaturday #40 – South Florida
I'M ON A BOAT!
This is just a quick note to say that I’ll be in South Florida this weekend presenting...
2010-07-27
424 reads
Hit and miss
Or “Monitoring plan cache usage”
For people interested in the details of how SQL is using and reusing execution plans, there...
2010-07-27
1,152 reads
Count(*) or Count(1) ?
Every so often on the on-line forums, the question of : Which is better Count(*) or Count(1) ? will occur. So can...
2010-07-27
1,490 reads
Powershell Remoting with SQL Server
One of the best things to come out with Powershell V2 is remoting and asynchronous calls. Between the two of...
2010-07-27
1,585 reads
Slack Traveler
I realized over the weekend that I hadn’t booked a hotel for my SQL Saturday #28 trip to Baton Rouge....
2010-07-27
680 reads
Speaking at SQLSaturday #40 – South Florida
I finally get to head down to Miramar to speak at SQLSaturday #40 – South Florida. I really wanted to go...
2010-07-27
339 reads
Blogs
SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library
I built a free library of runnable SQL Server demos. Each reproduces a real...
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
Forums
MERGE in a nested TRY/CATCH won't roll back
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Perfermance result aftet purge operatio
Hello everyone, I am planning to implement a data purging solution that is expected...
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers