To DBA or Not to DBA (DBA Jumpstart)
This post is part of the SQL Community Project started by John Sansom called #DBAJumpStart.“If you could give a DBA...
2013-12-10
824 reads
Jason Brimhall
Cloud Nirvana
T-SQL Tuesday is a recurring blog party, that is started by Adam Machanic (Blog | @AdamMachanic). Each month a blog will host...
2013-11-12
774 reads
Cloud Nirvana
T-SQL Tuesday is a recurring blog party, that is started by Adam Machanic (Blog | @AdamMachanic). Each month a blog will host the party, and everyone that want’s to can write...
2013-11-12
6 reads
Murder They Wrote
I am about to set sail on a new venture with my next official whistle stop. This year has been plenty full of whistle stops and I plan on...
2013-11-05
3 reads
Murder They Wrote
I am about to set sail on a new venture with my next official whistle stop. This year has been...
2013-11-05
785 reads
Scaring a Database Near you
Something I have a hard time by-passing is a good R2 unit. I have R2 units in so many different...
2013-10-31
1,274 reads
Scaring a Database Near you
Something I have a hard time by-passing is a good R2 unit. I have R2 units in so many different forms, including a standing R2 cake one year for...
2013-10-31
3 reads
To DBA or Not to DBA…
In my day to day operations I have the opportunity to work with people in various capacities in regards to data. Sometimes it is in the capacity of a...
2013-10-31
1 reads
To DBA or Not to DBA…
In my day to day operations I have the opportunity to work with people in various capacities in regards to...
2013-10-31
1,240 reads
Exporting Execution Plans - SQL Spackle
A short SQL Spackle article to fill in your knowledge of SQL Server. In this one, Jason Brimhall shows how to export execution plans when you ask for query tuning help.
2013-10-29
5,109 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,...
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