It Still Happens – Full Transaction Log
Probably the most often asked question on SSC is about full transaction logs, and often full disks. It happened again...
2013-10-17
964 reads
Blog Posts
MailChimp Database Synchronisation Process
After giving you the Top 10 Tips when synchronising your database with MailChimp, I thought why not write up the...
2013-10-17
1,158 reads
Merge outputs of perfmon and profiler to get a great view
There is a way by which we can merge the .trc and .blg files to get a great view as...
2013-10-17 (first published: 2013-10-09)
6,329 reads
PASS Summit
It's that time of year again, the annual PASS Summit is under way in Charlotte, NC!
For those of you who...
2013-10-17
1,072 reads
PASS Summit 2013 – Day 3: Query Tuning, Memory Internals, SSIS and PowerShell
This is actually the first formal day of the PASS Summit, but it's my third day here. I have already...
2013-10-17
568 reads
PASS Summit 2013 – Day 3: Query Tuning, Memory Internals, SSIS and PowerShell
This is actually the first formal day of the PASS Summit, but it’s my third day here. I have already...
2013-10-17
390 reads
PASS Summit 2013 - Highlight Q&A from the Experts - What are your favorite features?
PASS Summit Continues….
If you have been following my blog, in the myriad of PASS Summit 2013 related blogs, you’ve been...
2013-10-17
995 reads
PASS Summit 2013 Day 2 Key Note
KILT DAY!
Today we have to eat our vegetables and then get lots and lots of sweet desert.
Or.
Today we hear about...
2013-10-17
886 reads
PASS Summit 2013 Keynote, Day 2
Today is the second day of the 2013 SQL PASS Summit, and I’m again live blogging the event.
8:15: Here...
2013-10-17
833 reads
PASS Summit 2013 Keynotes Day 2
Okay Dear Reader one more time let me say that if you are interested in Hekaton In-Memory OLTP Then you...
2013-10-17
1,037 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