SQLCruise Contest
For those who may not have heard, there is training for SQL Professionals called SQL Cruise. You can find more...
2011-01-05
674 reads
SQL RNNR
SQLCruise Contest
For those who may not have heard, there is training for SQL Professionals called SQL Cruise. You can find more info here. There is a bit of interesting news...
2011-01-05
4 reads
MockingJay – a review
After a long wait, I have finally read the final installment in the “Hunger Games” trilogy. I read the other...
2011-01-04
581 reads
MockingJay – a review
After a long wait, I have finally read the final installment in the “Hunger Games” trilogy. I read the other two books earlier in the year in 2010 and...
2011-01-04
5 reads
2010-12-28
675 reads
2010 Recap
As a part of a recap on the year that was 2010, I should start with a recap of my goals. For that review I had to go back...
2010-12-28
4 reads
SSIS Multiple File Export
Have you ever needed to export different data sets to different flat files? Each of these data sets could be...
2010-12-28
1,469 reads
SSIS Multiple File Export
Have you ever needed to export different data sets to different flat files? Each of these data sets could be customer information for different clients – but they all...
2010-12-28
50 reads
Powershell, Me and the MCM part II
Last week I posted the first part of this series. I thought it would be a good idea to give...
2010-12-20
827 reads
Powershell, Me and the MCM part II
Last week I posted the first part of this series. I thought it would be a good idea to give a little follow-up on how my foray into Powershell...
2010-12-20
5 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