Notes from the January 2012 oPASS Meeting
It’s been quite a while – where did the time go? – since I had done a presentation for oPASS, so when...
2012-01-23
549 reads
SQLAndy
PASS: Time to Change the By-Laws
Yesterday Bill Graziano announced the appointment of two Directors (Kendal Van Dyke and James Rowland-Jones) to fill vacancies on the...
2012-01-14
937 reads
Presenting at OPASS on January 10, 2012
I’m stepping out of blogging-break mode for a few minutes to share that I’ll be presenting Building Your Professional Development...
2012-01-04
687 reads
PASS Election Results
The 2011 Election results were just posted, congratulations to Adam Jorgensen, Denise McInerney, and Rob Farley for taking the top...
2011-12-28
690 reads
Wrapping Up 2011 and a Blog Break
I’m writing this on December 17th, thinking back on 2011, and it has been a good year. Not always simple...
2011-12-28
641 reads
PASS Update #69 (The Wrap Up)
Next week marks the end of my third and final year serving on the PASS Board of Directors. I’ve struggled...
2011-12-27
660 reads
PASS Summit 2011 Eval Results
My presentation on Professional Development Plans ended up being ranked 47th out of 190, with an overall score of 4.63....
2011-12-22
641 reads
Explaining SQLSaturday
I wrote a while back about my coffee cup from SQLSaturday #100. I took it to work (where I usually...
2011-12-21
637 reads
SQLSaturday Goes International
Looking at 2011 and the planned events so far for 2012 it’s easy to see that SQLSaturday is starting to...
2011-12-20
655 reads
Read About SQLSatuday #100 & See the Coffee Cup Too!
Here’s a great post from Karla Landrum about her trip (with husband Rodney) to Brazil for the milestone making #100....
2011-12-19
725 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