SQLSaturday #160 – Get your SQL learn on in Kalamazoo
If you’re planning on being in the Kalamazoo, MI area this weekend, or just feel like taking a road trip,...
2012-09-17
739 reads
Blog Posts
Why I dislike Third Party Database Monitoring Tools
I have to admit I am not a fan of the various 3rd party monitoring tools (after using a few...
2012-09-17
1,895 reads
SQL Server 2012 Diagnostic Information Queries (September 2012)
Here is the September 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-09-16
1,218 reads
SQLSaturday #171, Pittsburgh
Date: October 6, 2012
Title: Searching for the Holy Grail of DDL Auditing
Abstract:
Who altered this view and how? When was that...
2012-09-16
690 reads
Attendant’s checklist to a SQL Saturday event
Weeks Before The Event
Check for conflict in Schedule
Family Activities (Y/N)Business Appointment (Y/N)Other Commitments (Y/N)Plan the Trip
Distance (calculate travel time)Budget $ (Gasoline,...
2012-09-15
707 reads
After Seven Years, Time for Something New
Earlier this month, I passed the seven year mark at Digineer. It was a weird feeling, since the last time...
2012-09-14
709 reads
Book Review: SQL Server 2012 Integration Services Design Patterns
This book is written by Andy Leonard, Matt Masson, Tim Mitchell, Jessica Moss, and Michelle Ufford. These are all highly...
2012-09-14
2,778 reads
Certificates of Completion for SQL Seminars
Most managers and employers distinguish between attending a conference and training. We (the royal SQL community we) offer quite a...
2012-09-14
1,116 reads
Change file logical name for mirror database
Today I encountered a interesting issue when rename logical name for mirror database.
We have a database which has been setup...
2012-09-14 (first published: 2012-09-09)
3,072 reads
Conference in Florida: SQL Server Live
This conference is new to me. In case it’s new to you, I thought I’d take a moment to point...
2012-09-14
969 reads
Blogs
What is ALM in Fabric?
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
The Most Successful Startups in 2025 — And What They Have in Common
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
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...
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