July OPASS Meeting Wrap up
Last Tuesday, July 13th, we had our monthly OPASS meeting. The meeting was sponsored by RedGate who were kind enough...
2010-07-20
448 reads
Blog Posts
My Application to the PASS Board
The application form mentions that the quite a bit of what you include will be made public. While I won’t...
2010-07-20
710 reads
PASSMN July Meeting Today
Don’t forget the July PASSMN meeting is today. We have Itzik Ben-Gan (blog) coming in to talk about some query...
2010-07-20
540 reads
Raining Tuesday – Cricket Cancelled – Replication Stinks - SQL BITS VOTE NOW!
Well this was going to be replication post, but I have read it, re-written it, read it, re-written and it...
2010-07-20
667 reads
SQLBits 7
For those that may of missed it, voting for SQLBits sessions is now open. Make your voice heard and get...
2010-07-20
399 reads
SSIS - Event Handler Performance
Event handlers are a great tool for managing errors and other events that occur during the execution of a package...
2010-07-20
1,140 reads
Creating UDL Files On The Fly
Many years ago, in the dark ages of DTS I created a little app that would take two parameters and...
2010-07-19
659 reads
Finding Your Next Job
We’ve had a few people in the SQL community find jobs lately and many of them attributable to their network....
2010-07-19
518 reads
How to Deal with Quebec’s Extremists: Expose Their Malfeasance Publicly?
NB - to my regular blog readers, excuse the tangent here, but the local provincial extremists attempted something in my 'hood...
2010-07-19
6,754 reads
I Did It - PASS Nomination Application
I send my board of directors nomination application to PASS and asked for a confirmation. I always worry that something...
2010-07-19
675 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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...
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