-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLStudies

My name is Kenneth Fisher and I am Senior DBA for a large (multi-national) insurance company. I have been working with databases for over 20 years starting with Clarion and Foxpro. I’ve been working with SQL Server for 12 years but have only really started “studying” the subject for the last 3. I don’t have any real "specialities" but I enjoy trouble shooting and teaching. Thus far I’ve earned by MCITP Database Administrator 2008, MCTS Database Administrator 2005, and MCTS Database Developer 2008. I’m currently studying for my MCITP Database Developer 2008 and should start in on the 2012 exams next year. My blog is at www.sqlstudies.com.

Archives: May 2015

Multiple Windows Groups with different default databases

A question came up at work the other day, mostly as a mind game, but you never know it might actually come up at some point. So here is the idea.

  • UserA is a member of Group1, Group2 and Group3.
  • Group1 is set up as a server principal with a…

Read more

2 comments, 1,441 reads

Posted in SQLStudies on 28 May 2015

Default database

What?
The default database is one of the options when creating a login in SQL Server. This is the initial database that the login will connect to when logging in. Unless of course you specify a different database in your connection string.
 
How?

-- Creating a login with a…

Read more

1 comments, 633 reads

Posted in SQLStudies on 26 May 2015

Adding new users & groups in windows

I do a lot of testing with security in SQL Server. And of course to do a thorough job of it I need not just SQL Server logins but Windows logins. And that means I need to be able to create and delete windows users and groups. I could do… Read more

3 comments, 535 reads

Posted in SQLStudies on 20 May 2015

Extending your metadata with Extended Properties

Ever wanted to put a comment on a table? Or maybe even a column? How about an expiration date on a object? Well as it happens you can. Extended properties allow you to add a name/value property to a number of the objects in SQL Server. In fact if you… Read more

9 comments, 5,484 reads

Posted in SQLStudies on 18 May 2015

Test first; Mileage may vary;

I went to a SQL Saturday recently and saw a number of great sessions. If you haven’t been to a SQL Saturday before I highly recommend it. It’s a day of free training and networking put on by Pass. The training is done by members of the community who… Read more

2 comments, 471 reads

Posted in SQLStudies on 14 May 2015

TSQL Tuesday #66: Monitoring

If a user is going to call me about problem, I’d much rather know about it ahead of time. In fact my favorite problems are the ones I’ve already fixed before the users ever notice it. In order to manage this amazing feat you have to monitor your instances, your… Read more

1 comments, 4,747 reads

Posted in SQLStudies on 12 May 2015

Notes on Presenting

As you may know I’m preparing to write my first presentation. I have a great abstract and an outline of the presentation itself. Next step is creating the Powerpoint slides. Then practicing the presentation itself. So while going to my latest SQL Saturday I decided to take the opportunity… Read more

9 comments, 415 reads

Posted in SQLStudies on 6 May 2015

Building a job to monitor other jobs

The other day Tom Roush (b/t) and Tim Radney (b/t) were having a discussion on twitter about using scheduled windows tasks to run SQL Processes. Now why would you ever want to do this? Well if you are running SQL Server Express… Read more

5 comments, 6,104 reads

Posted in SQLStudies on 4 May 2015