My upcoming speaking schedule
The summer goes by and in a few weeks the conference season starts over again. The last weeks were a...
2012-08-21
343 reads
Blog Posts
PASS Summit Code of Conduct – my thoughts
The big furor today is over PASS‘s new written Code of Conduct. I’m going to crib unashamedly from Nic Cain’s blog post...
2012-08-21
1,172 reads
Restore Database In SQL 2012
In the post below I mentioned a store procedure which can generate the database restore script based on the msdb...
2012-08-21
8,313 reads
Webcast: The Art and Science of Handling Recruiters
Post-webcast update: The webcast went well! We talked, we QnA’ed, we gave out a free Roadmap, and all attendees got...
2012-08-21
823 reads
8 Habits/Skills/Traits of Highly Effective DBAs
The whole “7 Habits” title is so cliché so I decided to make it eight! Plus that will probably relieve...
2012-08-20
448 reads
keyword DEFAULT
In 12 years of working with SQL it was only last year that I came across the keyword DEFAULT and...
2012-08-20
1,341 reads
Please VOTE for Me: PASS Summit 2012 Lightening Talks
http://www.flickr.com/photos/cyndydoty/2087680308/Hello Dear Reader the PASS Summit is approaching and with that the program committee sent out a request for Lightening...
2012-08-20
1,053 reads
SQL Agent Alerts - Severity Condition is NOT "greater than or equal to"
I ran into some bad training that had convinced a client sys admin that the SQL Agent Alerts had the...
2012-08-20
2,267 reads
SQL Audit 301 – Using Powershell to Manage Audits
Today we’re going to go over some very basic scripts to create, drop, and copy SQL Audit objects using Powershell...
2012-08-20 (first published: 2012-08-13)
3,210 reads
SQL Server: Understanding the Data Page Structure
We all know very well that SQL server stores data in 8 KB pages and it is the basic unit...
2012-08-20 (first published: 2012-08-12)
8,760 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