SQL Server 2008 Diagnostic Information Queries (April 2012)
Since it is nearly April, I will go ahead and jump the gun again and post an updated version of...
2012-03-28
1,081 reads
Since it is nearly April, I will go ahead and jump the gun again and post an updated version of...
2012-03-28
1,081 reads
One of the challenges you face with SQL Server database mirroring is making sure that all of the databases that...
2012-03-27
10,052 reads
Back in 2008, Microsoft rolled out the DreamSpark program as a means to get Microsoft software design and development tools...
2012-03-21
1,370 reads
If you ever find yourself having to setup database mirroring between different, untrusted Windows Domains, one of the most common...
2012-03-21
1,493 reads
Microsoft has also released SQL Server 2008 SP3 Cumulative Update 4. This is Build 10.00.5775.00, and it has ten fixes...
2012-03-21
4,258 reads
Right on schedule, Microsoft has released SQL Server 2008 SP2 Cumulative Update 9. This is Build 10.00.4330.00, and it has...
2012-03-20
1,801 reads
Even though SQL Server Database Mirroring is deprecated in SQL Server 2012, it is still a very useful HA/DR technique...
2019-04-02 (first published: 2012-03-12)
6,579 reads
SQL Server Database Mirroring is a high availability and disaster recovery feature that was added to the product with SQL...
2012-03-07
3,085 reads
Yesterday, Intel finally released the much anticipated Xeon E5-2600 family of processors, also known as Sandy Bridge-EP. This is a...
2012-03-07
1,229 reads
Pretty much right on schedule, Frank Delattre has released CPU-Z 1.60, which has support for some new and upcoming processors...
2012-03-04
832 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