Reblog: March 8 to March 14
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-15
716 reads
StrateSQL
Pragmatic Works Webcasts This Week #passwit
Every week, Pragmatic Works offers up its “Training on the Ts” webcast series and this month, in honor of Women’s History Month,...
2013-03-11
570 reads
Last Weeks Top 20 “Reading” Links #23
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-03-11
562 reads
Reblog: March 1 to March 7
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-08
634 reads
Index Analysis March Update
In yesterdays duplicate index blog post, I mentioned that there would be an update to the index analysis stored procedure...
2013-03-07
720 reads
That’s Actually A Duplicate Index
As I’ve worked with clients on performance tuning through index improvements, one of the common areas that I discuss with...
2013-03-06
2,441 reads
March 2013 – Monthly SQL Server Checklist
It’s the first Monday of the month, do you know where your servers are?
Hopefully, they are still in your data...
2013-03-04
809 reads
Last Weeks Top 10 “Reading” Links #22
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-03-04
589 reads
Reblog: February 22 to February 28
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-01
932 reads
Presentation Materials “A Function is a Function”
Here are the presentation materials for today’s Pragmatic Works Training on the T’s session A Functions Is A Function – Comparison of...
2013-02-28
1,278 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