Optimize a query by thinking out of the box
Recently I had to create a simple query to lookup a single row in a table containing ranges that do...
2011-07-26
635 reads
Leaked Information About AMD Opteron 6200 Series Processors
CPU World has a post about some leaked info regarding the upcoming Opteron 6200 series “Bulldozer” processor line. Here are...
2011-07-26
1,047 reads
Columbus GA SQL Server Users Group Webinar Tomorrow
I found out last week from a good friend and President of the Columbus GA SQL Server Users Group, that...
2011-07-25
1,317 reads
Get count of folders using Power Shell
More on my recent PowerShell project. I recon I have taken on the challenge to handle this entire request using...
2011-07-25
577 reads
How to move Cluster Quorum Drive
I recently had the need to move the quorum for a cluster to a new SAN drive. It’s a quite simple...
2011-07-25
2,650 reads
Speaking Schedule! I’m here (and there, and there…) to help
Depending on whether you’re (A) me, or (B) you, the next few weeks are either (A) an insanely busy but enjoyable...
2011-07-25
573 reads
Setting role security in SSAS for a role-playing dimension
Here is a common got-ya. You are modifying the cube dimension security for a role-playing dimension. You make the changes and...
2011-07-25
2,048 reads
My Schedule for The Remainder of 2011
Just a few notes about things I’m doing over the next few months:
July 30 – Attending SQLSaturday Birmingham. I went to...
2011-07-25
584 reads
OMG I’m an MVP!
I can’t believe it, but I can finally say that I’m now officially a Microsoft SQL Server MVP! Last week...
2011-07-25
797 reads
IT Professionals, the Job Search and the Killer CV
It has been while since I wrote anything on my contracting blog but over the past month or so I...
2011-07-25
1,219 reads
Blogs
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
SQL Server Audit Failures
Comments posted to this topic are about the item SQL Server Audit Failures
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers