Inappropriate PASS Sessions – nearly SOLD OUT!
If you want to get into the Inappropriate PASS Sessions event during the PASS Summit in Seattle this year, you’d better...
2010-10-15
609 reads
Jen McCown
Inappropriate PASS Sessions – SOLD OUT!
I’m sorry, but the Inappropriate PASS Sessions event (an after-hours event during the PASS Summit in Seattle) is SOLD OUT.
This all...
2010-10-15
747 reads
S-3-X Talk Week: Wrapup
Image is conjecture; accuracy of percentages not guaranteed (but likely)
We’ve discussed thinking about 53x (Women: whenever it comes up; Men:...
2010-10-15
590 reads
Ground Zero Database Design
All the SQL world should take database modeling classes, and thrive in the light of well-designed data structures. Back in...
2010-10-14
645 reads
S–3–X Talk Week: Love, HR, and Sexy Shoes
We’re conducting S–3–X Talk Week here at the MidnightDBA #Awesomesauce blog. In the tradition of the first S-3-X week blog,...
2010-10-13
858 reads
Forgotten T-SQL Cheat Sheet
You’ve seen the blog, you’ve downloaded the code…you even watched the 24HOP session recording…now own the Forgotten T-SQL Cheat Sheet!
Yessir,...
2010-10-11
1,426 reads
S–3–X Talk Week: This Totally Won’t be Awkward
We’re conducting S–E–X Talk Week here at the MidnightDBA #Awesomesauce blog, in honor of everyone’s favorite subject. In deference to the...
2010-10-11
528 reads
New Hotness: sys.objects and sys.schemas
Last month we talked about the old and busted syscomments- and the new hotness that is sys.sql_modules – for pulling code out of...
2010-10-08
691 reads
How MUCH More Do You Make?
Yesterday, my SQLServerCentral.com editorial Why are we still talking about Women in Tech? was published, and we had a fine...
2010-10-07
950 reads
Today I Blog About Certifications (Instead of Studying)
I'm not in it for the money...exclusively...
I was talking to the older kids about homework yesterday, and I mentioned that...
2010-10-07
709 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