Colorado speaking tour
I’m happy to announce that I’ll be doing a tour of the 4 SQL Server user groups in central Colorado...
2013-03-11
685 reads
I’m happy to announce that I’ll be doing a tour of the 4 SQL Server user groups in central Colorado...
2013-03-11
685 reads
Since I started regularly attending SQL Saturday events some five years ago, I’ve sat in on a number of professional...
2013-03-08 (first published: 2013-02-28)
3,147 reads
Since the release of Visual Studio 2012, business intelligence developers have been limited in how much they could use this...
2013-03-06
1,560 reads
Note: This will be the first post in a short series on using Object typed variables in SQL Server Integration...
2013-03-04
1,663 reads
Earlier this week, my employer, Artis Consulting, welcomed a new addition to our team. Technical expert Erin Welker (b|t), a...
2013-02-08
845 reads
I’m going to Nottingham, England, fabled home of Robin Hood, where I’m going to eat fish and chips and talk...
2013-01-30
1,527 reads
I’m happy to announce that I’ve been selected to deliver a full day of training at the upcoming SQLBits conference...
2013-01-15
742 reads
Frequently I am asked how to properly use SQL Server Integration Services to handle ragged flat files, an example of...
2013-01-15
2,170 reads
OK, I’m not really going to break it. I’m just going to beat it up a little bit.
This Thursday evening,...
2013-01-15
885 reads
Do your civic duty, and vote today!
Voting is now open for SQLBits, to be held in Nottingham, UK this...
2013-01-07 (first published: 2013-01-03)
1,585 reads
By Vinay Thakur
it has been a year since i have not written much on the blog...
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
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