Shrinking Transaction Logs
I see questions on forums all the time about DBA’s or System Admins finding they are out of drive space...
2011-08-31
2,194 reads
Tim Radney - Database Professional
PASS Regional Mentor
Wow, how time flies by. It seems like just a month ago I was made the PASS Regional Mentor for...
2011-08-30
1,399 reads
Learning Transactional Replication
I have been working on a new skill this week and that is implementing transactional replication. I am of course...
2011-08-24
700 reads
Adding an Index to Save Space
Sounds weird right, but that is exactly what has happened with a VLDB I inherited. A third party database that...
2011-08-17
1,037 reads
Steel City SQL User Group
Tonight I will be doing a presentation on TEMPDB to the Steel City SQL Users Group in Birmingham AL. I...
2011-08-16
548 reads
If You Aren’t Measuring It, You Can’t Manage It
It sounds simple and logical doesn’t it. One could say it is common sense right? How many of us are...
2011-08-08
526 reads
Data Warehousing with SSIS
As a DBA why would I consider attending a pre-con by John Welch at SQL Saturday 89 titled Data Warehousing with...
2011-08-08
1,580 reads
I Am Going to Be a Big Brother #sqlpass #firsttimers
Well at the PASS Summit at least. The Summit is trying to make sure that all of our first timers...
2011-08-05
1,121 reads
Register for 24 Hours of PASS NOW! #sqlpass
Do you need to perfect your SQL Server skills? Would you like to get 24 hours of free SQL Server...
2011-08-03
577 reads
I deem September 2011 – SQL Server Month
If you haven’t visited the SQL Saturday website you should take a look. There are SEVEN events planned during September around...
2011-08-02
556 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