2011 MVP Summit – Day 1
I’m glad I went running this morning. It’s been a long day, in and out of sessions and meetings all...
2011-03-01
400 reads
How to Get a Head Start on Performance Tuning
The problem with performance tuning is that it is commonly considered as secondary to the task at hand rather than...
2011-03-01
730 reads
SSRS – Creating and Using Shared Schedules – Part 1
As you will see by the dates in my screenshots, I wrote them quite a while back while touring the...
2011-02-28
2,395 reads
Don’t Be Afraid of Windows Failover Clustering!
One of the more exciting features in SQL Server code-named “Denali” (which is the current official name for the next...
2011-02-28
1,875 reads
My Upcoming Schedule, Come Get Your Learn On!
It’s official, I’ll be speaking at SQLSaturday #63 April 2nd. It is something near and dear to my heart, solid state storage....
2011-02-28
1,356 reads
Memory Consumed By SQLServer
Have you wondered how much memory was being consumed by SQL Server? Have you wondered if there was a way to find out that information from a tSQL command?...
2011-02-28
20 reads
Memory Consumed By SQLServer
Have you wondered how much memory was being consumed by SQL Server? Have you wondered if there was a way...
2011-02-28
3,538 reads
SSAS - Preserve Measure Null Values
Generally when designing a data warehouse (at least in my experience) you don’t think about NULL values appearing often in...
2011-02-28
5,870 reads
JTDS & Grails
Recently I had the chance to do some tuning on a system that was built using Grails (formerly Groovy on...
2011-02-28
2,491 reads
SQLskills SQL Server Immersion Training: A Retrospective
Last week I attended the inaugural training event of the new four-week SQL Server Immersion Training offered by Kimberly Tripp...
2011-02-28
2,011 reads
Blogs
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...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
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