Intel Nehalem-EX and Database Performance
Intel is talking about the upcoming launch of the next generation Intel Xeon processor (Nehalem-EX) being bigger than the Xeon...
2010-01-18
859 reads
Glenn Berry
The Energy Detective TED 5000 Installed And Working
Back in October, I ordered one of the new TED 5000 energy monitors directly from Energy, Inc. in Charleston, SC....
2010-01-16
822 reads
Second Shot Promotion For Microsoft Certification Exams
Microsoft and Prometric have renewed their Second Shot promotion for certification exams. This allows you to retake a failed exam...
2010-01-16
908 reads
PASS 2009 Speaker Evaluation Scores
Since quite a few PASS 2009 speakers have gone public with their speaker evaluation scores, I might as well do...
2010-01-15
772 reads
Using Synthetic Benchmarks To Help Evaluate Database Server Hardware Choices
As a DBA, I think it is very important to stay current on trends in x64 based hardware. The DBA...
2010-01-15
733 reads
Installing SQL Server 2008 and 2008 R2 on Windows Server 2008 R2
There is a recent post on the Microsoft SQL Server Support Blog about how to get SQL Server 2008 and...
2010-01-12
1,470 reads
Intel Intelligent Home Energy Management
Last week at CES 2010, Intel showed off a proof of concept device for a home energy management dashboard. This...
2010-01-12
988 reads
Kevin Cox from SQLCAT Presenting at the Denver SQL Server User’s Group On January 21, 2010
Kevin Cox, who is part of the SQLCAT Team at Microsoft, will be giving the presentation at this month’s Denver...
2010-01-11
820 reads
New HTPC Build with 32nm Intel Core i3 530
Since Intel announced and released the new 32nm Core i3 processors and compatible H55 chipset, Socket 1156 motherboards this week,...
2010-01-09
2,973 reads
Time to Upgrade from SQL Server 2005 SP2 and SQL Server 2008 RTM
Microsoft’s Bob Ward posted to remind everyone that SQL Server 2005 SP2 support ends on January 12, 2010, and SQL...
2010-01-08
703 reads
Blogs
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...
Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
A Wellbeing Day at Redgate
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
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