Off-Hours Work: A Guide For Managers
If you work in software development or IT long enough eventually you're going to find yourself in a situation where...
2009-10-02
2,012 reads
Kendal Van Dyke
Off-Hours Work: A Guide For Managers
If you work in software development or IT long enough eventually you're going to find yourself in a situation where...
2009-09-29
1,850 reads
SSMS "Connect to Database Engine" Prompt Behavior When Dragging And Dropping Files
A minor annoyance of mine for a long time has been how SSMS will sometimes prompt you to connect to...
2009-09-17
379 reads
Networking While On Vacation
There's been a lot of attention given to professional networking (e.g. Andy Warren's blog posts) recently and if you recall...
2009-09-15
601 reads
How To Get Table Row Counts Quickly And Painlessley
Just a quick note to call out that I've had an article posted on SQLServerCentral that shows how to retrieve...
2009-09-02
445 reads
Why Does Code Outlining In SSMS Only Work When Connected To SQL 2008?
Code Outlining has been part of Visual Studio since VS.NET 2002. If you're not familiar with it, code outlining is...
2009-08-04
465 reads
Things You Need To Know If You Use DFS Replication
In addition to being a SQL DBA I'm also a network administrator, or at least I pretend to be. This...
2009-07-31
2,825 reads
SQL Logins For Windows Domain Accounts Limited To Pre-Windows 2000 Format
You may have noticed that when you create a login on a SQL server that's mapped to a Windows domain...
2009-07-28
653 reads
Interested In *Free* SQL Training? Attend A SQL Saturday Near You!
Can't make the PASS summit? Or maybe you're going but looking for something whet your appetite between now and November....
2009-07-27
754 reads
So You Want To Meet People At PASS…But What Do You Say?
Going to the PASS Summit this November? Let's fast forward and pretend it's November 2. You've made it to Seattle...
2009-07-23
515 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