SQL Server 2012 Express RC
The new version of the lovely SQL Server edition, Express Edition!
Take a look the new link for the download and...
2012-01-31
3,244 reads
When DBCC INPUTBUFFER disappoints
Today we have an alert from one of the client server about blocking, I have immediately start looking at it...
2012-01-30
1,735 reads
Breaking Down TempDB Contention (part 2)
Breaking Down TempDB Contention (part 2)
Tempdb Contention via Idera Diagnostic Manager
I wrote a somewhat popular script and blog post a...
2012-01-30
3,036 reads
Returning Results from an Insert – OUTPUT clause
I needed to return an identity value recently from an insert for use in another piece of code. For a...
2012-02-02 (first published: 2012-01-30)
3,598 reads
The affordable self-service BI revolution has started.
I am officially announcing that I have now become an independent consultant and business owner. Becoming independent has always been...
2012-01-30
1,895 reads
Complex reporting off a SSAS cube
While using a cube in SSAS is usually a great source for reporting, it is not always the best choice....
2012-01-30
2,359 reads
The Idera ACE Program, So Far
The Idera ACE program is something I’ve been involved with for over a year now. I’ll share a bit of...
2012-01-30
1,675 reads
RYO Maintenance Plan – Database Backups, Part 2
Last time I dealt with the creation of subdirectories, in one or more root locations, to house my database backups....
2012-01-30
1,864 reads
Execution Plans, What Do I Look At?
The question came up, what are the top 3-5 things that you look at in a query. I realized then...
2012-01-30
1,839 reads
Apply to Be A 2012 Idera ACE!
The call for applications is open today, a chance for six lucky people to do more in the SQL community...
2012-01-30
709 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
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
AI Is Improving Security
Comments posted to this topic are about the item AI Is Improving Security
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers