So then, what’s the definition of an object……..?
Not blogged for a while due to client and project commitments but something which has surprised me when speaking with...
2012-01-25
604 reads
Chris's SQL Blog
Powershell and Dynamic SSIS (or any for that matter) Config files
As I imagine that the majority of people who are reading this will have some level of SSIS knowledge, I’ll...
2011-12-05
1,232 reads
Powershell to Script out SQL Server Objects using a CMS list
I’ve recently decided I’ve got to get with the times and started dabbling with Powershell. Up until now i’ve not...
2011-09-19
2,250 reads
Being an Exceptional DBA Award 2011 Finalist
On Wednesday 13th July at 16:06 (GMT) I got what could only be described as the biggest shock of my...
2011-07-25
855 reads
NetApp Dynamic Backup Script
For those of you who’ve worked with NetApp and SnapManager for SQL Server, you will know can generate a scheduled...
2011-06-09
1,234 reads
SnapManager Epic Fail – oh dear!
An ex colleague and good friend of mine has recently been having trouble with Snapmanager for SQL, anyone had similar...
2011-04-07
693 reads
Why I don’t like NULLs and Nullable Columns
As I imagine (or hope), the majority of us adhere to some form of standards in the environment that they...
2011-03-25
769 reads
Database Mail – Collection of SQL Server Scripts
As part of my blogging I’ll be periodically providing readers with a collection of my scripts which I use on...
2011-03-21
954 reads
Poll: – Index Rebuild / Defrag, what page count filter do you set?
After reviewing a number of clients overnight index defrag / rebuild scripts over the years, I’m intrigued to know how many...
2011-03-11
759 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