PASS Sessions Submitted
Hey guys, I’m preparing a few new article series for you but in the meantime I wanted to let you...
2010-07-09
318 reads
Blog Posts
PASS Summit 2010 Sessions Accepted
Excited to get the email yesterday that two of my sessions were accepted, Introduction to SQL Server Statistics and Building...
2010-07-09
412 reads
PASS Update #36
We had our monthly Board of Directors call on July 8th and as is fairly common, the call went smooth....
2010-07-09
1,151 reads
Speaking at 2010 PASS Summit in Seattle
I just found out yesterday that I had one of my General sessions approved for the 2010 PASS Summit in...
2010-07-09
551 reads
SQL Server Agent – Proxy error
I was setting up some SQL Server agent jobs in a test environment. I needed one of our testers to...
2010-07-09
14,313 reads
SQLSaturday #49 Pre-Con Announced
We’re pleased to announce that Louis Davidson will be our pre-con speaker this year at SQLSaturday #49 in Orlando. Louis...
2010-07-09
219 reads
The PASS Session Selection Process, My Experience Part 2
In part one I talked about the abstracts. While important, abstracts are only one part of a complicated selection dance....
2010-07-09
472 reads
This week’s SQL Lunch was great !
Hey there SQL Lunchers. Your co-host Adam Jorgensen here. I wanted to let you know, for those of you whose...
2010-07-09
349 reads
Windows 7 Run As
One of the things that got us to switch OSes from W2K to WinXP when I was an administrator at...
2010-07-09
445 reads
Wolfram Alpha 5 Minute Screencast
Hey folks. I have yet to explore the world of Wolfram Alpha and still don’t claim to be an expert...
2010-07-09
392 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