Archives: November 2015
You have an on call, you have a business continuity plan, you have a disaster recovery plan but what happens when your developer, DBA or whoever is hit by a bus?
User: Oh noes! The web sites down!
One quick call later
Developer: Hmm, it looks… Read more
You’re back? Good. So, her article got me… Read more
The transaction log is made up of one or more files that are used sequentially. So in other words if you have multiple log files then new log information will only be written within one of those files at a time.
To the best of my knowledge there… Read more
Becoming a speaker is one heck of a journey. Early this year I submitted a session to speak at Pass Summit 2015 and was enormously shocked to be accepted as an alternate. Well that was 5 months ago now and a lot has happened since then. I submitted, was… Read more
Every time I install a new version of SSMS I make a handful of changes to the default setup. For my own notes, and in case anyone is interested in some of the things you can do with SSMS I thought I’d post a list of those changes.
This isn’t something you have to do frequently, but sometimes you don’t want the users to have access to certain columns in a table. For example let’s say you have a salary column in your employee table that you don’t want everyone seeing.
There are two fairly simple options.
It’s almost Thanksgiving time again! Let’s see, what am I thankful for? T-SQL Tuesday! Someone else get’s to pick a blog topic for me! In this case it’s the always fun Mickey Stuewe(b/t) and her topic is Data Modeling Gone Wrong. So let’s see ..… Read more
I recently gave my SQL Server Security for Everyone session at Summit 2015. (I’m still in awe about that by the way.)
First of all here are the PowerPoint slides:
Next there we a few questions I said I would look into and here they are:
- I use relink…
If you’ve ever worked through an audit you have probably gotten a request that looks a lot like this:
Please give me a list of all sysadmins.
This is because members of the sysadmin role are super users. They can do anything they want on the instance. But these… Read more