Beyond Relational
I missed this yesterday, but I saw it on the schedule again, and I knew
I had to make this one....
2007-06-05
2,010 reads
Blog Posts
DBCC Internals
CHECKDB
- needs consistent view of the db. Needs to do this without locking. In
SQL Server 2000 log analysis is used....
2007-06-05
1,858 reads
Maintenance in SS2K5
Andrew Kelley from Solid Quality Learning did this one, which was good.
I was worried it would be about maintenance plans,...
2007-06-05
1,561 reads
Reunion
We're not partners anymore in SQLServerCentral.com, but Andy, Brian,
and myself got together last night for dinner. We haven't seen each
other...
2007-06-05
622 reads
SQL Server 2005 Tools
A good talk on the tools from the guy that's responsible for SSMS,
Configuration Manager, Maintenance plans, Surface Area Configuration
Wizard, and...
2007-06-05
620 reads
SQL Server Always On
Everyone wants 5 9's of uptime, 24x7 support, and instant fixes for
issues with their database server. Never mind that I'd...
2007-06-05
2,187 reads
Clustered Index Seek or Key Lookup
When I teach performance tuning I always remind students to be cautious about service packs because things you "know" may...
2007-06-04
1,760 reads
First Session
I dropped into Brian Knight's "Clustering in 60 Minutes" to say hi. If
you've never seen this, it's pretty cool and...
2007-06-04
560 reads
Tech Ed - Keynote
These will get pretty long as I'm kind of wordy, but these are impressions as things are occurring.
Registration is a...
2007-06-04
742 reads
Working Afternoon
I ended up driving around Orlando this afternoon to get books. We'd
printed the next version of our Two Minute SQL...
2007-06-04
573 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