SQLSaturday #49 Orlando – Recap
This past weekend I had the pleasure of presenting at another great SQLSaturday event, number 49 actually and the 3rd...
2010-10-21
1,172 reads
Blog Posts
SQLSaturday #59 – Speaker Interview Series #8 with Aaron King.
SQLSaturday #59 – Speaker Interview Series #8 – with Aaron King.
We interrupt this blog post to bring you the latest SQLSaturday#59 News...
2010-10-21
1,111 reads
SSC Editorial – Cheap Fun
I wrote Cheap Fun after buying a really cheap – $1 – wood airplane kit at the store for the kids. Amazing...
2010-10-21
737 reads
The best things in life are free
Greg Gonzalez (blog | twitter) of SqlSentry, last night released a very cool new and free product. Plan explorer is a...
2010-10-21
2,938 reads
Boulder SQL Server User’s Group - Common SQL Server Mistakes
The first iteration of my presentation on Common SQL Server Mistakes, based on the various things I’ve seen in the...
2010-10-20
987 reads
Common SQL Server – Not Indexing FKs
This series looks at Common SQL Server mistakes that I see many people making in SQL Server.
Foreign Keys
It’s way too...
2010-10-20
1,310 reads
Ground Zero Database Design: Part 2
Last week I wrote Ground Zero Database Design, thinking that was a good enough bare-bones intro (with recommended reading!) that...
2010-10-20
739 reads
Kilt Day at the PASS Summit
Last year, with the infinite power at my disposal (read, zero), I declared Wednesday, Kilt Wednesday at the PASS Summit. It took...
2010-10-20
1,434 reads
Minutes of the September 2010 PASS Board Meeting Posted
Please take a few minutes to review the September 2010 minutes (login required). We just had our October meeting on...
2010-10-20
662 reads
New Cumulative Updates for SQL Server 2005 and SQL Server 2008 R2
Late Monday night (October 18, 2010), Microsoft released the latest Cumulative Updates for SQL Server 2005 and for SQL Server...
2010-10-20
926 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