Watch Your Repairs
Apparently PC repair people have learned a few things from auto mechanics of the past. A news group in the...
2009-07-23
619 reads
Blog Posts
Database Mirroring - Hitting the Limits
When I first heard about database mirroring in 2004, I was excited. Here was a great new feature that would...
2009-07-22
4,377 reads
Featured Blogger: Glenn Berry
This month I’m featuring Glenn Berry, a Denver based MVP that writes Glenn Berry's SQL Server Performance blog. He blogs...
2009-07-22
725 reads
Kindle Alternatives – B&N on Blackberry
I’m not a fan of Blackberry devices. Actually that’s not true, I really dislike them. They’re not intuitive, and I’ve...
2009-07-22
1,288 reads
My Virtual Lab setup Hyper-V 2008 and Virtual Server 2005 R2
One of the things I’ve maintained over the years is a lab to do everything I need. From testing new...
2009-07-22
3,537 reads
Replication Snapshot Errors Caused By Compatibility Level Setting
I ran across an interesting replication error recently that's worth sharing. It happened while using a distributor running SQL 2008,...
2009-07-22
447 reads
Barnes and Noble eBooks
I saw yesterday that Barnes and Noble released their e-reader for iTouch/iPhone, Blackerrys, Mac, and PCs and at the same...
2009-07-21
795 reads
Contest to Win a Free Trip to PASS
MSSQLTips & Idera are sponsoring a contest where the grand prize in an all expenses paid trip to the PASS Summit...
2009-07-21
708 reads
Conversations
Do you know how to start a conversation or how to join one? I usually wait for a pause and...
2009-07-21
665 reads
Kindle Update - Broken
🙁
I was literally stunned and it must have shown on my face because my daughter asked me if I was...
2009-07-21
792 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