Configure Anti-Virus on your SQL Server
This week I had an application team report the error “SQL Connection Lost”. Fortunately they also reported the exact times...
2012-03-06
1,683 reads
Blog Posts
Date Dimension Script with Fiscal Year
One dimension you can be positive will always make it’s way into your data warehouse is the Date dimension. Over...
2012-03-06
4,172 reads
First SQL Server 2012 Launch Event
I asked a few questions on twitter this morning after a friend of mine said they were have problems downloading...
2012-03-06
781 reads
How to log off remote desktop users from a remote machine ?
When you try to log on to a remote server on emergency to perform some task , it may throw an...
2012-03-06
8,227 reads
Introduction to SharePoint BI Webinar Tomorrow
Tomorrow at 11AM Eastern time I will be presenting a FREE webinar for Pragmatic Works (website) on Introduction to SharePoint...
2012-03-06
626 reads
Most DBAs Don’t Seem to Know that Transaction Logs Can be Tuned
I was very surprised to see the results of my latest poll, which asked “When was the last time you...
2012-03-06 (first published: 2012-02-27)
4,832 reads
Moving MSDB to new location
In recent past we have a situation where in we required to move MSDB, Model and Master databases to new...
2012-03-06
881 reads
Notes from the February 2012 MagicPASS Meeting
I was back at MagicPASS last week to do a presentation, my first time with the group at the new...
2012-03-06
567 reads
Second Chances for Plagiarism
I had an exchange with someone that had plagiarized some work recently. That’s nothing new, and I run into plagiarism...
2012-03-06
1,209 reads
SQL Server 2005 to SQL Server 2008 R2 upgrade considerations
1) SQL Server 2008 R2 Reporting Services doesn’t support Windows 2003 (or R2) Itanium based servers
2) SQL-DMO support is stopped...
2012-03-06
1,180 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers