An Introduction to Templates
Templates are a powerful tool in so many trades and crafts. From decals and stickers all the way up to...
2017-12-30
694 reads
SQL RNNR
An Introduction to Templates
Templates are a powerful tool in so many trades and crafts. From decals and stickers all the way up to...
2017-12-30
347 reads
An Introduction to Templates
Templates are a powerful tool in so many trades and crafts. From decals and stickers all the way up to the largest cruise ships in the world, templates can...
2017-12-30
4 reads
Audit Domain Group and User Permissions
No matter how simple the task or how versed we are with doing a security audit, it seems like we...
2017-12-29
994 reads
Audit Domain Group and User Permissions
No matter how simple the task or how versed we are with doing a security audit, it seems like we...
2017-12-29
350 reads
Audit Domain Group and User Permissions
No matter how simple the task or how versed we are with doing a security audit, it seems like we can always stand to learn just a little bit...
2017-12-29
4 reads
Correlate Trace and XE Events
Several years back, when Extended Events was brand new, it was downright painful to try and convert the classic Profiler...
2017-12-28
543 reads
Correlate Trace and XE Events
Several years back, when Extended Events was brand new, it was downright painful to try and convert the classic Profiler...
2017-12-28
234 reads
Correlate Trace and XE Events
Several years back, when Extended Events was brand new, it was downright painful to try and convert the classic Profiler or Server Side trace to something meaningful and useful...
2017-12-28
3 reads
Message in a Bottle of XE
One of the age old features that most probably take for granted in SQL Server happens to be the error...
2017-12-27
930 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