Learning By Doing
I was recently talking with a friend about doing some research into a NAS solution for home and that I...
2013-03-22 (first published: 2013-03-19)
1,785 reads
SQLAndy
Building My Next Workstation–Part 6 (The End)
Let’s start with a quick review of the pieces and what I paid:
ItemCostAntec P280 Case$90 (may be higher now)ASUS P8Z77-V...
2013-03-12
667 reads
Building My Next Workstation–Part 5
With the motherboard and CPU installed I was ready to add the final and perhaps easiest parts to the build....
2013-03-11
651 reads
Building My Next Workstation–Part 4
Reading about the motherboard choices took a while. Because I had already decided on a CPU, the Intel I7 I...
2013-03-07
777 reads
The End of SQLRally in the US
I saw it in the Connector, but just had time to read the minutes to see what was behind the...
2013-03-06
861 reads
Picking a Conference Venue
I was reading about the American Association of Woodturners annual symposium that will be held in Tampa this year (and...
2013-03-05
638 reads
Building My Next Workstation–Part 3
With a case ordered and a CPU in mind I decided to focus on the power supply next. Remember that...
2013-03-05
649 reads
Notes from SQLSaturday #192
This past weekend I was back in Tampa for the sixth annual SQLSaturday. It’s a trip I always look forward...
2013-03-04
655 reads
Trust in Access
One of the minor features/quirks/annoyances of MS Access is that if you create a single macro or code module you...
2013-03-04
683 reads
Building My Next Workstation–Part 2
Building a computer, at least in the beginning, feels like something you have to do holistically and at the same...
2013-02-25
1,257 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