Your Lack of Documentation is Costing You More Than You Think
You’ve got a mountain of work to get done and not enough time to do it in. There’s simply just not...
2011-02-01
1,509 reads
John Sansom
The Art of the Outstanding DBA
Being average is dull. Are we consistently producing quality that we can be proud of, each and every time? So...
2011-01-25
575 reads
Why Every DBA Needs a Buddy
If you truly desire to be an effective SQL Server Database Administrator then you absolutely must have a buddy.
SQL Server...
2011-01-19
2,790 reads
Why Every DBA Needs a Buddy
If you truly desire to be an effective SQL Server Database Administrator then you absolutely must have a buddy.
SQL Server...
2011-01-18
1,905 reads
T-SQL Tuesday 14: Techie Resolutions for You not Me
Is it just me or has the community done the whole “What are my goals for this year” thing to...
2011-01-11
647 reads
The Best Database Administrators Automate Everything
Do you understand the value of your time? I mean really understand it. Time is your absolute number one most valuable asset. Once...
2011-01-04
1,425 reads
TSQL Tuesday 13: Managing Unrealistic Expectations
It’s that time of the month again, no not that one, it’s T-SQL Tuesday time and this weeks topic is...
2010-12-14
663 reads
Life Without a Net – My comment
Did you catch the brilliant and thought provoking editorial post Life Without a Net by Rodney Landrum on SQL Server...
2010-11-02
415 reads
The Perfect SQL Server DBA / Developer Role
Whilst enjoying my coffee fix this morning, along with today’s SQL Server Central Email, my attention was caught by Steve...
2010-09-09
351 reads
10 Character Traits of Outstanding DBA’s
What are the character traits of outstanding SQL Server Database Administrators (DBA) ?
You know what I’m talking about. There are...
2010-08-24
975 reads
Blogs
TempDB Internals – What’s New (Sql Server 2016 to 2025)
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