SQL Server 2005 Diagnostic Information Queries (May 2012)
Even though SQL Server 2005 fell out of Mainstream Support back in April of 2011, I know many people are...
2019-04-02 (first published: 2012-05-04)
2,364 reads
Glenn Berry
Building an Intel Ivy Bridge Desktop System, Part 2
A few weeks ago, I wrote about buying some of the components that I needed to build a new 22nm...
2012-05-02
1,851 reads
Checking Your Main BIOS Version
As some of you may know, I spent four years in the U.S. Marine Corps back during the Reagan administration....
2012-05-01
1,769 reads
SQL Server 2008 Diagnostic Information Queries (May 2012)
Since tomorrow is May 1, I think it is time to publish the latest set of SQL Server 2008 Diagnostic...
2012-04-30
1,941 reads
SQL Server 2012 Diagnostic Information Queries (April 2012)
It is hard to believe, but SQL Server 2012 has been GA for nearly a month now. Because of this,...
2012-04-26
2,701 reads
Quick Roundup of Intel Ivy Bridge Reviews
The overall opinion seems to be that the 22nm Ivy Bridge represents a relatively small boost to CPU performance (typically...
2012-04-23
1,031 reads
Intel Ivy Bridge Release Coverage
Web sites, blogs and media outlets in Europe and the U.K. are starting to post some early Ivy Bridge stories,...
2012-04-23
1,051 reads
SQL Server 2012 Core Factor Table for AMD Processors
As of April 1, 2012, Microsoft has a new SQL Server 2012 Core Factor Table for AMD processors. You can...
2012-04-23
2,968 reads
Urgent BIOS Update for Dell PowerEdge R810, R910 and M910 Servers
If you have an 11th generation Dell PowerEdge R810 , PowerEdge R910 server, or a PowerEdge M910 blade server, there is...
2012-04-18
2,172 reads
Windows Server 2012
Microsoft’s Corporate Vice President Brad Anderson announced today at the Microsoft Management Summit 2012 in Las Vegas that the next...
2012-04-17
1,022 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