24 Hours of PASS coming over the next two days
Hey folks,
The 24 hours of PASS is coming very quickly.http://www.sqlpass.org/24hours/fall2010/. There are so many great sessions that I don’t know...
2010-09-06
506 reads
Blog Posts
An impossible case
In a previous blog entry (Inconsistent NullIf behaviour), Jeff Moden and Dan Halliday(twitter) both made a very similar observation.
When executing...
2010-09-06
547 reads
Awards for SQL Heroism
Motivational time again!
Have you ever worked on a project where someone was seeking their moment in the sun for an...
2010-09-06
216 reads
Building your 1st Performance Point Dashboard in Sharepoint 2010
Hey there gang
The PASS BI Virtual Chapter is presenting some great stuff this fall. September 14th I’m doing a new session on...
2010-09-06
378 reads
Get ready for the Third Annual SW Florida .Net Code Camp!
Hey there database folks! Don’t be scared off by a little .NET. The SW Florida code camp is getting underway...
2010-09-06
359 reads
Idera SQL Tools – An evaluation (Part 2)
This is the 2nd in the series of evaluations I have carried out on Idera’s SQL Server Toolbox. The first...
2010-09-06
1,325 reads
Labor Day Bloopers
Happy Labor day to everyone. A day off for me, but I’m posting a few bloopers from the past couple...
2010-09-06
1,101 reads
Let’s get Dimensional – from Requirements to Dimensional Design
Hey folks!
You asked for it – so coming up on September 8th we’re doing a SQL Lunch that is going to...
2010-09-06
388 reads
Managing Contacts
This is one of those posts that has little to do with SQL Server and more to do with helping...
2010-09-06
561 reads
Parallelism in SSIS - Multiple Lookups
This question just came up in the forums, and it highlights how difficult it can be to try to optimize...
2010-09-06
2,149 reads
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
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