SQL Rally Schedule
In case you didn’t see the email come through for PASS this week the SQL Rally schedule is now available. ...
2012-04-13
1,022 reads
In case you didn’t see the email come through for PASS this week the SQL Rally schedule is now available. ...
2012-04-13
1,022 reads
SQL Server Data Tools (SSDT) is a Business Intelligence Development Studio (BIDS) replacement, meaning it has a suite of Visual...
2012-04-13
11,497 reads
I wanted show someone how to use table-valued parameters available in SQL Server 2008 and higher. The main use case...
2012-04-13
3,558 reads
A few weeks ago I was running errands on a Saturday, with an almost final stop at Home Depot to...
2012-04-12
687 reads
Another month goes by and it’s time again to ask… are your SQL Servers healthy? Have they been properly configured? ...
2012-04-12
892 reads
Over the last couple of years I’ve gotten myself down to two small, carry-on bags for most of my trips....
2012-04-12
1,086 reads
The new certification structure has been announced by Microsoft and the changes are rather broad and sweeping. MCITP is gone....
2012-04-12
1,954 reads
Excel 2010 (and presumably the next version of Excel) have taken some security precautions with regards to macros in Excel...
2012-04-12 (first published: 2012-04-09)
2,714 reads
This morning my son woke up to find his eBook reader frozen. It wouldn't unlock. It was fully charged (the...
2012-04-12
1,262 reads
TweetG’day,
On Saturday 14th April I’ll be speaking at SQL Saturday 136 in Wellington, New Zealand.
My presentation is titled “Extended Events...
2012-04-12
984 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