That’s right! I’ll be speaking at this weekend’s SQL Saturday event in Wheeling, WV. I’m the last speaker in track #3. I’m looking forward to Ed Wilson’s PowerShell session at 9:10AM, I need to use more PowerShell in my daily job. I have a couple of scripts that really work for me now, it’s time…
Category: Microsoft SQL
SQL 201-Ranking Functions
It’s been a while since I’ve covered a SQL 201 topic! I want to jump back into it with ranking functions. These are functions that let you represent orders in your data. When you were in school I’m sure you had to take standardized tests. When you did you were given a percentile score. This…
70-432: Post-op
I passed the 70-432! After two months of preparations I did it! I’d like to let you know a little about my experience with SQL, so you can judge how much of this prep you might need to do. I began in 99 as a web programmer using the LAMP stack. Within a few years…
Tips for SQL N00bs
Everyone in PASS and everyone following the #sqlhelp hashtag on twitter was a SQL n00b at one point. That includes me. So when I started compiling my SQL101 material into a book, it dawned on me. I should include those things I wish I’d known sooner about SQL. So I asked anyone who would…
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. But it’s a really simple concept, you can join two queries that have absolutely nothing to do with each other into one statement. I’d like you…
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 you have available on Agent Jobs. After digging into the Agent Jobs properties dialog, I realized there were some extra features I’ve never used. While…
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 the three recovery options, and knowing a bit more about the simple mode. Scenario 1 You’ve got a database that’s used during business hours (0800 to 2000). It’s currently…
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 too much access. Today, I want to cover how you can use the EXECUTE AS OWNER to grant access to a table without granting direct access to…
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 have a good handle on granting permissions using both users and groups. While you need to know how to grant those permissions using the…
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 want to spend an hour looking over the options, and what they mean to how the database will run. This is a quick overview of those options,…