June 2011 Version of SQL Server 2008 Diagnostic Queries
Since it is June, I thought it was time to update my SQL Server 2008 (and 2008 R2) Diagnostic Information...
2011-06-02
683 reads
Blog Posts
Just Deserts
Here’s another photo from my phone, this one from SQLSaturday Tampa in the cafeteria area. An easy typo to make,...
2011-06-02
604 reads
NEW: Microsoft SQL Server 2008 R2 Administration Cookbook
I have had the pleasure of knowing and communicating with Mr. Satya Shyam K. Jayanty, aka Satya/aka SQLMaster|twitterfor several years...
2011-06-02
2,236 reads
PASS 2011 Pre-Conference Seminars and Spotlight Sessions Released
I have wanted to go to PASS Summit for the last several years, but have yet to get an opportunity...
2011-06-02
674 reads
Un-SQL Friday #004: Speaker Lessons Learned
I began writing a story about, shall we say, a less than positive speaking experience…and then I realized: This is...
2011-06-02
1,089 reads
Windows 8 demo
A Windows 8 demo was just released. Looks really cool. Check it out at Previewing ‘Windows 8’ as well as Microsoft’s...
2011-06-02
670 reads
Do You Ever Physically Defragment Your SQL Server MDF & LDF Files?
Every since the first file was written to a floppy disk drive using DOS, physical file fragmentation has been a...
2011-06-01
1,992 reads
DQ & MDM Book Available to Download
If you’re looking for a resource on the Data Quality and Master Data Management features in SQL Server 2008 R2,...
2011-06-01
1,224 reads
June Question: How Do You Monitor Your SQL Servers?
As DBAs, one of our biggest responsibilities is to monitor our SQL Servers to ensure they are performing as expected....
2011-06-01
1,250 reads
PASS Announces Pre-conference and Spotlight Sessions for PASS 2011 Summit
Today, PASS announced the Pre-conference and Spotlight Sessions for the PASS Summit 2011 in Seattle, which will run from October...
2011-06-01
1,105 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...
AI: 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