SQL301
Manually Deleting Stinks!
Go ahead and set up your TroubledTable by running the Create Troubled Table T-SQl Script. Now take a look at your duplicate rows. SELECT email, COUNT(*) FROM
microsoft sql
SQL301
Design Patterns Session
On February 6, I'm going to tele-present a session on T-SQL design patterns to the Brazil SQL Server Users Group. During this session I'll cover three common
sqlmcm
How Much Logging Goes on for a Clustered Index Drop?
A week back @fatherjack put out a question on #sqlhelp that immediately drew my curiousity. He wanted to know how much his log file would grow if he dropped his
microsoft sql
Who Shrank Roger Rabbit
It all started Thursday afternoon, about 1500. I was walking back from Starbucks with my afternoon pick-me-up, when a co-worker mentioned we have this process
sqlmcm
88-970: My Study Guide
Since I know I'm going to go for the SQL MCM next year, I'm going to start collecting all of my study materials here, on my blog. Hopefully that way it can jump
sql
70-450: Complete!
After another month of studying, I finally took the 70-450. I'm happy to say I passed! I did learn one thing from the exam: I should spend more time with
Certification
70-450: IO Throughput
Today I'm getting back to studying for the 70-450. To follow up the last few articles I'm still in the first bullet point from the official guide. Designing a
Certification
70-450: Calculating Table Size
In my previous three posts I covered different RAID solutions, and when I use each type of RAID. That's just the first part of the first section of the 70-450.
sqlsaturday
SQL Saturday #87 – Louisville, KY Recap
Starting Wednesday of last week I was able to attend the local SQL Server User Group and then that Saturday I attended SQL Saturday #87 in Louisville, KY! There
Certification
70-450:Implementing RAID Solutions
Problem 1 Developers come to you with a new physical database server that hosts a single database. It's going to be your responsibility now. Currently the
Certification
70-450: SQL and RAID 5/10
Continuing SQL and RAID, let's pick up RAID 5 and RAID 1+0 (or just 10) This content is still for the first skill measured in the 70-450, per the official
Certification
70-450: SQL, RAID 0, RAID1
Let's get ready for the 70-450. Hit the official Microsoft page for the 450, and you'll see the first skills measured on the exam: Designing a SQL Server