Benefits for Some, All or Only a Few
As a member of the PASS Board of Directors I attended the PASS Business Analytics Conference (BAC) recently. You can...
2015-04-27
512 reads
As a member of the PASS Board of Directors I attended the PASS Business Analytics Conference (BAC) recently. You can...
2015-04-27
512 reads
It’s been a pretty interesting month on the board.
First, we did have a little problem. I’m sure one or two...
2015-04-23
526 reads
The question came up on SQL Server Central that someone wanted to track queries on their 2008R2 instance and on...
2015-04-21
619 reads
I spend many of my evenings researching and writing. Sometimes it’s writing new books. Sometimes it’s fixing and rewriting old...
2015-04-16
681 reads
The new portal for managing Azure is pretty. I’m not sure I’m in love with it, but it’s pretty.
However, one...
2015-04-24 (first published: 2015-04-13)
5,237 reads
I decided in January that I would write regularly about people that I’m grateful for. Now it’s April. Oops.
The concepts...
2015-04-10
532 reads
If you’re starting the process of moving your databases in Azure SQL Databast to v12, you need to do one...
2015-04-07
2,063 reads
I’ve posted previously about how a foreign key constraint can change how a SELECT query behaves. Logically that just makes...
2015-04-16 (first published: 2015-04-06)
7,516 reads
One of my favorite events of the year is the SQL Saturday in Silicon Valley. They’ve had four of them...
2015-04-03
605 reads
Hello all,
It’s been a while since my last update. Sorry. I’ve just been traveling and presenting and working on books...
2015-03-31
1,093 reads
Next Monday, March 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
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