sql
Another Guest Blog
I’ve got another post up at WMW.com.br! This time I’m taking on CXPACKET waits and parallel queries. I also go into why setting MAXDOP to 1
Latest
sql
SQL 201-Non-Correlated Sub Queries
It's been a while since I've covered any material for my SQL 201 series, so I thought I'd jump back into it with non-correlated sub queries. It's a mouthful.
career
Resume Goodness and Failures
Over the past few weeks I’ve helped out with the hiring process at my current employer. We’ve decided to bring a new person on to help with some
microsoft sql
70-432: A Closer Look at Agent Jobs
I was taking a practice test for the 70-432 when I got a question that covered a scenario I’d never even thought about before. It had to do with options
personal
Happy Memorial Day
Three day weekends are great, aren't they? Extra time away from the office to unwind and spend with your friends and family grilling up a storm. I know I'm
career development
On Confidence
You've really got to open this and savor it. That's seriously an application that was sent in to a colleague this week. After working with most people in IT, It
sql
70-432:Another Backup Scenario
I've covered the differences in the recovery options before. So you should be mostly prepared for the following scenario. It requires you being familiar with
sql
70-432: Execute as Owner
Another topic you'll need to understand in order to pass the 70-432 is how you can grant permissions to a user to accomplish a certain goal, without granting
career development
Work–Life Balance
This week has been a busy one! I'm working up to a vacation this weekend, so there's always a lot of little things to tie up to get ready. You've got to make
sql
70-432: Permissions and Users and Roles, Oh my!
Yeah...I referenced the Wizard of Oz. If I Only Had a Brain The Wizard of Oz — MOVIECLIPS.com But that doesn't take away from the fact you're going to need to
70-432
70-432: Database Options
Have you ever cracked open the properties for a database, and looked at all the options available on that page? If you’re preparing for the 70-432, you might
Monitoring SQL Azure: What the DMVs Don't Tell You Anymore
The first thing a DBA does when something feels wrong is open SSMS and start querying DMVs. sys.dm_exec_requests, sys.dm_os_wait_stats, sys.dm_exec_sessions — the standard toolkit. In 2011, when clients started moving databases to SQL Azure, I kept hearing the same complaint: "