Pragmatically Thankful
This season, as we continue to grow and partner with some of the best of the best in the industry....
2010-12-15
509 reads
Blog Posts
Preventing Subscriptions from Blocking Interactive Report Executions
A consulting client recently asked how they could resolve a capacity-planning issue
on their production report server. They manage a busy...
2010-12-15
650 reads
Relational Types.
As I try to drag my team (sometimes with resistance, sometimes with pleasure) into the world of relational principles, I...
2010-12-15
608 reads
Should I have AutoGrowth enabled on my SQL Server Database
I was reading a few forum posts yesterday where a few people were complaining that the transaction log had grown...
2010-12-15
2,382 reads
Thanksgiving Bloopers
I'm slow to get this out, but I finally rendered the raw bloopers from November. Enjoy.
Part 1
Part 2
Part 3
2010-12-15
1,104 reads
The iPad, So Far
In the front yard, using the iPad & SQL Monitor
After a great deal of unseemly begging, I managed to acquire an...
2010-12-15
904 reads
Tis the Season
This month has been quite the month for change in my family. The changes that we are experiencing did not end with the birth of our baby girl two...
2010-12-15
2 reads
Tis the Season
This month has been quite the month for change in my family. The changes that we are experiencing did not...
2010-12-15
541 reads
Two Digit Year Cutoff
I couldn't sleep this morning and decided to wake up and catch up on my email when I noticed a video link...
2010-12-15
1,671 reads
Viewing RING_BUFFER_OOM Errors
Onion Ring Buffer?
A client asked a co-worker to take a look at a query for reviewing RING_BUFFER_OOM messages in sys.dm_os_ring_buffers. ...
2010-12-15
1,349 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