Reflections on ‘Visibility, the Art of Being Noticed’ by Phil Factor
If you have not read the Master of Phrenetic Phoughts’ article, please do so here. I enjoyed very much the...
2010-02-02
966 reads
Blog Posts
SQLSaturday Bequeathed to PASS
I guess you could look at this one of two ways. Either PASS acquired SQL Saturday, or we (Andy, Brian,...
2010-02-02
580 reads
Three Engine Improvements in SQL Server 2008 R2
The upcoming (by May 2010) of SQL Server 2008 R2 has been primarily focused on enhancements in the BI area...
2010-02-02
953 reads
Three Engine Improvements in SQL Server 2008 R2 (Updated)
The upcoming release (by May 2010) of SQL Server 2008 R2 has been primarily focused on enhancements in the BI...
2010-02-02
427 reads
Find Efficiencies or Add Horsepower?
In our world sometimes it’s worth the time and effort for in depth tuning to get the machine to run...
2010-02-01
664 reads
I don’t care
I had meant to check what was up with my Toshiba laptop since I was curious. I gave up last...
2010-02-01
336 reads
Identities and Transactions
I talked a little recently in a blog about gaps in identity values. They can occur when you delete rows,...
2010-02-01
592 reads
More Nukes
One of the reasons that I did not vote for President Obama was his stance on our energy issues, specifically...
2010-02-01
326 reads
Orlando Code Camp 2010 Announced
The fifth annual Orlando Code Camp will be held March 27, 2010, at the Lake Mary Campus of Seminole State...
2010-02-01
350 reads
Sending SSIS Errors to the Windows Event Log
In a previous post I explained how to trap for errors in your Script Task and Components and send the information to the SSIS...
2010-02-01
4,760 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