MVP Deep Dives 2… Pre-Order
Every couple days, I’ve been checking for it and finally tonight I saw that the upcoming edition of SQL Server...
2011-09-22
491 reads
StrateSQL
SQL Saturday in Kalamazoo This Weekend
If you are going to be in Kalamazoo this weekend and don’t have anything planned. Because, yeah, that happens. Or...
2011-09-13
438 reads
PASS 2011 Countdown – 4 Weeks To Go
One week down and we are now 4-weeks from this years PASS Summit. Hopefully, you have already registered for the...
2011-09-12
621 reads
PASSMN September Meeting Announced
It’s time to start looking deeper at the next release of SQL Server. As such, the September PASSMN meeting will...
2011-09-06
1,092 reads
September Monthly SQL Server Checklist
First day of the month and first Tuesday of the month. Yup, the list is late this month because for...
2011-09-06
1,372 reads
PASS 2011 Countdown – 5 Weeks To Go
We are now 5-weeks from this years PASS Summit. It’s time to start getting ready for the event. Hopefully, you...
2011-09-05
861 reads
PASSion Award Nominations
PASSion Award
One of the things that makes PASS a successful organization is the volunteers. To show it’s appreciation for these...
2011-09-04
1,489 reads
Re-blog – August 26-September 1
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-09-02
651 reads
Book Status #1: Indexing for Performance
As some of you may know, I am writing a book on indexing. So far I’ve written and submitted four...
2011-08-31
1,406 reads
Re-blog – August 19-August 25
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-08-26
570 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