Hot Fixes
I wrote about Hot Fixes being inclusive of previous hot fixes. Someone questioned this and so I went back to...
2007-04-03
1,414 reads
Blog Posts
Post Timeouts
Well one problem was solved. Or at least identified.
We've had an issue for a few years where you'd hit the...
2007-03-31
1,414 reads
Late Projects
I was talking with Andy Warren, my partner and fellow partner here, today about the Code Camp in Orlando last...
2007-03-27
1,436 reads
Ambition
I was always someone that was ambitious as a kid. For whatever reason, I've been driven most of my life...
2007-03-22
1,442 reads
Updated Website
I've taken some time to update my website. In particular I have updated:
ArticlesReading ListChess Reading List
Nothing fancy or special, but...
2007-03-20
1,343 reads
Whitepaper on ESX Server 3.0 and SAN-attached Storage
First saw this at Blade Watch. VMWare has released a white paper on using SANs with VMWare ESX Server 3.0....
2007-03-20
1,491 reads
SQL Server 2005 Security Best Practices Whitepaper Released
Saw this first here: SQL Server 2005 Security Best Practices. It's on the blog for Microsoft UK's SQL Server Premier...
2007-03-19
1,872 reads
Windows PowerShell and Windows Server 2003 SP2
Saw this on the Windows PowerShell blog:
Since W2K3 SP2 is an update to W2K3 SP1, if you install Powershell on...
2007-03-19
2,550 reads
"Wet" Pet Food Recall
Animals are near and dear to my heart, to the point where I have a cat even though I am...
2007-03-17
1,344 reads
The Great Migration
We migrated to a new set of servers tonight. Actually am for the Red Gate folks and a late, 11pm-2am...
2007-03-17
1,460 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers