The Value of an Artist
A short while ago someone complained that some of the headlines on SSC were deceiving in terms of what they...
2010-06-15
661 reads
Blog Posts
Virtualizing Servers in Production
The company where I work has been using virtualization in development, QA, testing, etc., for many years now. We have...
2010-06-15
864 reads
Daily SQL Server 2008 New Feature – Day 22
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-14
399 reads
Jacksonville Code Camp Call for Speakers
Bayer White has announced the call for speakers for the 2010 Jacksonville Code Camp to be held August 28, 2010...
2010-06-14
308 reads
Maps in Reports!
I’ve been playing with SQL Server 2008 R2 for quite a while in the CTP’s and what not. But, I hadn’t made...
2010-06-14
1,222 reads
Me and Lil’ Buck at TechEd
I had been hearing about Lil’ Buck and so when I finally caught up with Buck Woody (Blog | Twitter) at...
2010-06-14
805 reads
Potential Pre-Cons for SQLSaturday #49
In previous years we’ve just invited a speaker or two to submit a presentation for an all day paid event...
2010-06-14
370 reads
SQL Saturday 35 Dallas - Postmortem
We're three weeks removed from the first annual SQL Saturday Dallas event, so I've had a little time to gather...
2010-06-14
963 reads
SSC Editorial – Bad Database Design
I wrote this editorial about bad design based on some real world experiences. It’s a fun story, maybe even borderline...
2010-06-14
377 reads
Tie It Back
I gave the Modern Resume: Building Your Brand presentation last week at the SQL Saturday #22 - Pensacola event and had...
2010-06-14
657 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
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