Today we’re going to cover a scenario you might face at work, one that’s also a topic you’d need to know in order to pass the 70-432 Database Administrator’s exam. If you have any questions in your preparation for the 70-432, let me know. I’ll be happy to help in any way! Now for the…
Tag: 70432
SQL 102 – REVOKE
Like I mentioned previously REVOKE is like an undo function for GRANT and DENY. If you have a developer and you work with him for a while, you may find that he’s ready to be given a little more leeway in the database. Once you’ve decided to make a change to the permissions, you may…
SQL 102 – DENY
Alright, at this point you should know how to GRANT permission to a database object, but do you know how to DENY permission to an object? DENY uses a syntax similar to GRANT. DENY { ALL [ PRIVILEGES ] } | permission [ (column(s) ) ] [ ON securable ] TO principal I want to…
70-432: So…What’s Going to Break When We Upgrade?
So you’re in a shiny new position and you’re building plans for your migration from SQL 2005 to 2008 when the question hits you. What features are we currently using in our code that will break when we move to the new server? Ohh, tough one right? Not really. Hopefully you’ve used the profiler before. …
70-432:Multiple Solutions, Multiple Instances
At work our database server is humming along. It runs a little under 50% on the CPU, the RAM is a bit high, and the IO is very responsive. But, it could be better. About a quarter of the load on that server comes from one application. It’s a reporting solution built to handle end…