Simple And Amusing Question Of The Day
I was working on a script today to check the range of some values and trying to take the time...
2014-04-11
573 reads
SQLAndy
Quarterly Goals
Over time I’ve settled on quarterly goals as the best way to focus on the stuff I most want to...
2014-04-11
531 reads
Writing My Next Question Of The Day
I ran into a simple error last week and saved it to convert to a question. It’s another one where...
2014-04-07
564 reads
Follow Up To A Questionable Trigger
This question of the day didn’t turn out well at all – required too big a leap the way it was...
2014-04-04
500 reads
SQLServerCentral Editorial: Team Reputation
Maybe too serious a topic for a Friday, I wrote Team Reputation because I like working for good teams – who...
2014-04-04
603 reads
The Untold Story of SQLHotties.com
Back when SQLSaturday was in the #20’s or so I bought SQLHotties.com, thinking it would be good for an April...
2014-04-03
567 reads
PASS Election Season Begins
Saw the announcement in the Connector today that the process of selecting the Nominating Committee (which vets applications for the...
2014-04-02
526 reads
A Questionable Trigger–Question Of the Day
A Questionable Trigger is the SQLServerCentral Question of the Day today. It’s my latest and perhaps the hardest. Here is...
2014-04-02
465 reads
Solid State Tapes–Prelaunch News!
Note: Sorry for the vague details on the tech part, you’ll get all of that tomorrow – this is what I...
2014-04-01
453 reads
Follow Up on The Unusable User–Question Of The Day
I posted about one of my questions of the day called The Unusable User last week and wanted to return...
2014-03-31
1,200 reads
Blogs
Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday!
Next Monday, March 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
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...
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