MVP Award for 2011
I just received notification from the Microsoft MVP Award Program that I’ve received the MVP award for SQL Server for...
2011-01-01
748 reads
Blog Posts
Re-Awarded MVP for 2011
I received my notice that I was renewed as a MIcrosoft MVP for SQL Server for 2011. It's a nice...
2011-01-01
782 reads
TPC-E Benchmark Analysis by CPU Type
As an experiment, I decided to import the current official TPC-E results spreadsheet into a SQL Server 2008 R2 database,...
2011-01-01
1,280 reads
2010 - A Year without Specific Goals
In previous years I had set goals and even if I didn't fully achieve them, they were helpful in giving...
2010-12-31
2,099 reads
2010 Goals Review
I started the year with 10 Goals for 2010 and now I'll end it by looking at how many of...
2010-12-31
1,593 reads
Blogging on Blogging
So I must confess that my blogging efforts to date have been on the impersonal side
– perhaps even a bit...
2010-12-31
1,448 reads
Happy New Year
Well it’s Friday again and another big day.
Hopefully you all had a great Christmas and as we move to...
2010-12-31
1,494 reads
Quick MCM Prep Help
Before I went on vacation, I mentioned I was downloading some of the MCM videos from Technet.I had grabbed 4...
2010-12-31
1,620 reads
The Year of Change: 2010 In Review
Like clockwork, another year has come and (almost) gone. It’s been a wild year on many fronts: major happenings included...
2010-12-31
1,584 reads
Windows Cluster Scripting with WMI and PowerShell
Windows 2008 R2 includes a failoverclusters PowerShell module, but you’ll probably find normal usage limiting for several reasons:
Only works on...
2010-12-31
3,642 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