Why you should blog more
I was trying to write an article for a long time. Every time I start writing one, I would put...
2011-09-01
1,237 reads
Blog Posts
Windows 7
The other day I logged on to my backup laptop (Win 7 N 64 Bit) and had this nice little warning and error message to greet me. My activation...
2011-09-01
3 reads
Windows 7
The other day I logged on to my backup laptop (Win 7 N 64 Bit) and had this nice little...
2011-09-01
589 reads
Are You Willing To Relocate?
I've recently been talking to people looking for DBAs and one of the questions that always gets asked early on...
2011-08-31
2,720 reads
BI Battle Royale–Adam beats up a Hippie
Weekday Lunch RAW!
Welcome to the Smack-down ladies and gentleman. I couldn?t believe it when Brian walked into my office the...
2011-08-31
1,797 reads
Bitwise and Derived Table revisited
Today I am going to revisit two posts from the past couple of weeks. I want to revisit them just to make some minor updates and clarifications. This is...
2011-08-31
7 reads
Bitwise and Derived Table revisited
Today I am going to revisit two posts from the past couple of weeks. I want to revisit them just...
2011-08-31
1,803 reads
Book Status #1: Indexing for Performance
As some of you may know, I am writing a book on indexing. So far I’ve written and submitted four...
2011-08-31
1,406 reads
Check the Default Database Setting for your Admin Accounts
Last weekend, as I was waiting for the start of the performance of the Cleveland Orchestra at its summer outdoor...
2011-08-31
1,794 reads
Convert EBCDIC to ASCII in SSIS
Converting EBCDIC to ASCII in SSIS 2008 can seem like a daunting task. There is a lot of manual work...
2011-08-31
8,701 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