SQL Server 2005 SP3
… has arrived: http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en
It’s obviously hot off the presses because the “What’s New document” is 404.
2008-12-15
678 reads
… has arrived: http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en
It’s obviously hot off the presses because the “What’s New document” is 404.
2008-12-15
678 reads
I had another chance last week to answer an email follow up question from the session Brian and I gave...
2008-12-15
8,507 reads
Yesterday I spoke on 2008 T-SQL and Data Types at the St. Louis Day of .Net event. This was an...
2008-12-14
419 reads
I’ve been trying the social networking thing, with accounts on Twitter, Facebook, and LinkedIn. I guess I have one on...
2008-12-12
775 reads
I finally got tagged for the SQL Quiz, which I've been following. Michelle Ufford, aka SQLFool, tagged me following her...
2008-12-12
1,329 reads
Ah, if you're reading this aren't you the curious one! I ran across the link below a while back and...
2008-12-11
641 reads
How Do I Configure SSIS to Work With a Named Instance?
By default, SSIS (SQL Server Integration Services) uses the msdb...
2008-12-11
12,799 reads
Can anyone here write a SQL statement that generates a Mandelbrot Set? I’m sure a few of you can, and...
2008-12-11
866 reads
I was recently reading Joel Spolsky’s column in Inc. on management and I thought it was an interesting story. In...
2008-12-10
854 reads
I’ve read a number of responses from Chris Shaw’s first DBA networking quiz. I missed out on the first one,...
2008-12-10
1,275 reads
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
By Vinay Thakur
it has been a year since i have not written much on the blog...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
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