Test Cluster Delivered & Ready to Assemble
I finally received all the components of my SQL Server test cluster (pictured left), which includes:
–One PowerVault MD3000 DAS with...
2010-07-13
561 reads
I finally received all the components of my SQL Server test cluster (pictured left), which includes:
–One PowerVault MD3000 DAS with...
2010-07-13
561 reads
I get a lot of emails from people who read my blog, books, articles, and from people who have attended...
2010-07-12
503 reads
Originally published in the Database Weekly newsletter.
I used to work at a large organization ($8 billion in revenues) as a...
2010-07-12
411 reads
In August, I will be presenting at the following events:
DevLINK, August 5-7, 2010
How and When to Use Indexed ViewsIdentifying SQL...
2010-07-12
558 reads
Brad McGehee wonders whether DBA's should take a more active role in managing their organization's data, even if it means potentially ruffling a few feathers.
2010-07-05
276 reads
This is number four in a series of checklists that I am putting together for a new book I am...
2010-07-03
3,546 reads
Back in 2008, I wrote a blog post about version 1 of the Performance Analysis of Logs (PAL) tool. This...
2010-07-03
1,112 reads
This month’s question of the month was:
What is your best advice for boosting index performance?
As usual, selecting the winning entry...
2010-07-02
438 reads
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-07-01
456 reads
Several weeks ago I wrote a blog post called “What is the Ideal SQL Server Test Box?” At that time...
2010-07-01
1,166 reads
Quite the title, so let me set the stage first. You have an Azure...
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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