Notes on the Jacksonville Code Camp 2009
I'm a couple weeks last posting this, but wanted to get my notes down anyway for future use. The goal of...
2008-09-09
465 reads
Blog Posts
Brown Bag Lunches/Training - Do They Work?
I'll define a brown bag lunch as a training event held at lunch time where someone on the team does...
2008-09-08
1,100 reads
Marketing - Seth Godin
I'm starting a series of blog posts from the Business of Software conference that I attended last week in Boston....
2008-09-08
981 reads
Naked Conversations
Sorry, I couldn't help not including 'Book Review' on the subject line, hopefully you're not too disappointed!
I just finished reading...
2008-09-07
357 reads
Wish-list for SQL Server Replication
I have been working on sql server replication (on sql server 2K5) for more than 1 year now, starting from...
2008-09-07
903 reads
Renaming Databases Posted on SQLServerCentral.com
Renaming Databases was just published on SSC, another in my lastest effort to expose some of the hidden complexities in seemingly...
2008-09-04
295 reads
Vacations
If all has gone well I've been on vacation this week, enjoying the world class quartz sand at Siesta Key...
2008-09-04
1,110 reads
Kindle - Value on the Road
I still need to jot some thoughts about using the Kindle, but a quick note from traveling.
I downloaded 3 or...
2008-09-03
434 reads
Performance Tuning Tips From the Consultant Perspective
I do very little consulting these days, perhaps 4-5 weeks per year, and that only to make sure I maintain...
2008-09-03
295 reads
Creating Databases Posted on SQLServerCentral.com
Creating Databases was actually posted last week, but got distracted with some other stuff. A basis walk through of creating...
2008-09-02
398 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
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