New Laptop Bag and My Event Bag
Last year I wrote about stuff I carry in my laptop bag. Nothing original, definitely a tendency to carry things...
2012-09-12
1,217 reads
Last year I wrote about stuff I carry in my laptop bag. Nothing original, definitely a tendency to carry things...
2012-09-12
1,217 reads
In our day to day life with SQL Server, We refer web for many reasons.
This includes understanding new SQL...
2012-09-12
808 reads
Wouldn’t it be nice if failure was an option? You could go along in life, screw it all up and...
2012-09-12
772 reads
This past summer I have been working on a new course for Learning Tree 2109 SQL Server Virtualization and Consolidation:...
2012-09-12
998 reads
We know that SQL server stores the data in 8 KB pages. An extent is made up of 8 physically contiguous...
2012-09-12
26,661 reads
Many of you have attended sessions by technical speakers at conferences and mini-conferences like SQL Saturday, SQL Rally, 24 Hours...
2012-09-12
1,097 reads
The SQL Server PDW (Parallel Data Warehouse) is a beast of a machine. Spreading workload across multiple nodes inside the...
2012-09-11
1,515 reads
It appears that I signed up to speak at the San Diego SQL Saturday coming up this weekend. I knew...
2012-09-11
694 reads
Page 9 in file 1 (of the primary filegroup) in a SQL Server database is the header page and contains...
2012-09-11
2,119 reads
The Denver SQL Saturday is coming in less than two weeks, SQL Saturday #169 is our second event in Denver,...
2012-09-11
937 reads
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
By Vinay Thakur
it has been a year since i have not written much on the blog...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
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