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
StrateSQL
Last Weeks Top 10 “Reading” Links #21
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-02-25
1,005 reads
Webcast “Performance Impacts of User Defined Functions” This Week with Pragmatic Works
Functions might seem to be the answer to all of your desires to consolidate code, and at times they could...
2013-02-25
654 reads
Reblog: February 15 to February 21
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-02-22
914 reads
Presentation Materials “What Are You Waiting For?”
Here are the presentation materials for today’s Pragmatic Works Training on the T’s session What Are You Waiting For – Explanation of...
2013-02-21
563 reads
Running SQLIO with Multiple Files
Not exactly groundbreaking information, but were you aware that you can run SQLIO with multiple files? Until a couple months...
2013-02-21 (first published: 2013-02-13)
2,519 reads
Calculate Bitmasks In PowerShell
Have you ever had to calculate bitmasks on the fly? I have and still do. In this post, I’m going to show...
2013-02-19
1,672 reads
Last Weeks Top 20 “Reading” Links #20
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-02-18
595 reads
Webcast “Value of Performing Wait Analysis” This Week with Pragmatic Works
Ever have your SQL Server slow down for reasons that you can’t explain? Or did you spend all night tuning...
2013-02-18
578 reads
Reblog: February 8 to February 14
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-02-15
889 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