Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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.

I want to blog but …

I don’t know how to get started.

Pretty simple. There are a number of free blogging sites out there. Personally I use WordPress. All you need to do is go to http://www.wordpress.com and sign up for a free space.

I have a blog but setting it up seems like a…

Read more

0 comments, 100 reads

Posted in SQLStudies on 4 March 2015

SQL Judo’s Monthly Challenge – March 2014 – Powershell something

Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be fun (and good practice) to do them. Another major benefit is that it will force me to move out of my normal comfort zone. For… Read more

0 comments, 95 reads

Posted in SQLStudies on 2 March 2015

Using sp_DBPermissions and sp_SrvPermissions v6.0

It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting.

Changes

sp_SrvPermissions
— V5.5
— 7/22/2014 – Changed strings to unicode
— V6.0
— 10/19/2014 – Add @UserLikeSearch and @IncludeMSShipped parameters.

sp_DBPermissions
— V5.5
— 7/15/2014 – Bunch of changes… Read more

0 comments, 106 reads

Posted in SQLStudies on 25 February 2015

Tales of a DBA fed up with NOLOCK. Part 2

Feb 16, 2015
Dear Diary,
A few weeks back I introduced HAL002 to a database managed by some annoying devs. They were not just putting NOLOCK on almost every query but they had SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED at the beginning of the stored procedures. HAL’s done his job… Read more

6 comments, 3,512 reads

Posted in SQLStudies on 23 February 2015

Test your UPDATEs and DELETEs before you run them

This isn’t so much of a best practice, it comes more under the heading of being careful. Let’s say you have a DELETE statement (or UPDATE) that you need to run. You can certainly put it in a transaction. Run it, test it, then if you’ve made a mistake roll… Read more

14 comments, 1,398 reads

Posted in SQLStudies on 18 February 2015

Tales of a DBA fed up with NOLOCK. Part 1

Nov 12, 2014
Dear Diary,
They asked for help again. Every now and again everything slows down and they see a lot of timeouts. They have tried rebooting the SQL instance and that fixes the problem but it’s only a temporary solution. Of course last time they asked for my… Read more

35 comments, 6,513 reads

Posted in SQLStudies on 16 February 2015

TSQL Tuesday #63 – How do you manage security: Rollup

When I decided on security as my topic for February’s T-SQL Tuesday blog party my thought was that security was a topic everyone would have something to say about as it’s something that touches the lives of every DBA at some level or another. Well it turns out I was… Read more

1 comments, 205 reads

Posted in SQLStudies on 12 February 2015

TSQL Tuesday #63: – DBA Myths: You can’t deny something to a member of db_owner database role

So I’m hosting T-SQL Tuesday this month and decided that since security is something everyone has to deal with it would make a fun topic for this month. I’d actually written this post before I wrote my hosting post for T-SQL Tuesday but it fit so well I couldn’t bring… Read more

7 comments, 5,866 reads

Posted in SQLStudies on 10 February 2015

Dealing with layered function calls

T-SQL is not the best language in the world for formatting strings. It can be done, but typically you are going to end up with lots of function calls. Let’s say I want to output the Rate as a string 5 characters wide padded with 0’s on the left. So… Read more

4 comments, 5,494 reads

Posted in SQLStudies on 5 February 2015

TSQL Tuesday #63 – How do you manage security?

Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought we might talk about security. Security is one of those subjects that most DBAs have to deal with regardless of specialty. So as something we all have to work with… Read more

26 comments, 282 reads

Posted in SQLStudies on 3 February 2015

A quick email interview of Pass President Thomas LaRock

Back in December I had the thought that it would be fun to do an email interview with someone. As I thought about it Thomas LaRock (b/t) sounded like a good choice since he has been working in the community for quite a while and is… Read more

2 comments, 5,501 reads

Posted in SQLStudies on 28 January 2015

SQL Judo’s Monthly Challenge – February 2014 – KILL with the DAC

Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be fun (and good practice) to do them. Another major benefit is that it will force me to move out of my normal comfort zone. For… Read more

1 comments, 5,485 reads

Posted in SQLStudies on 26 January 2015

Constraint names, Say NO to the default

Have you ever seen a constraint with a name like PK__TableNam__EA185FBF8FF1529D? It’s kind of funny looking right? I mean it makes no difference in terms of how things run but it does make it a bit of a pain when you need to code with it. Say dropping the… Read more

10 comments, 1,221 reads

Posted in SQLStudies on 21 January 2015

Except and Intersect

EXCEPT and INTERSECT are two uncommon commands. Not that they do anything odd but they aren’t exactly well known in any detail or used very often. I’ve been using them myself a bit recently and thought I would explore.

Per BOL:

EXCEPT returns any distinct values from the left query…

Read more

5 comments, 6,574 reads

Posted in SQLStudies on 19 January 2015

Pagination in SQL Server

It amazes me how much easier certain tasks have gotten in SQL Server. I was watching the Nov 2014 SQL Skills insiders video on OFFSET and FETCH by Jonathan Kehayias (b/t) and remembered fondly an interview I did many, many years ago. As part of the… Read more

5 comments, 6,478 reads

Posted in SQLStudies on 15 January 2015

TSQL Tuesday #62: Invitation to Healthy SQL – Why Page Verify?

I don’t think anyone’s ever been happy to get a support call at 11pm on a Saturday night. However this past Saturday that call did have a few things going for it. First of all I was able to spend the first hour or so of it watching the MidnightDBAs… Read more

0 comments, 5,687 reads

Posted in SQLStudies on 13 January 2015

Discussing Security with Boris Hristov on SQLHangout #29

Over the years I’ve done a number of posts on various aspects of security. In fact the first thing I ever wrote was security related. A brief explanation and solution for the Double Hop problem on SQL Server Central. Well continuing that theme I had an all to brief, but… Read more

0 comments, 132 reads

Posted in SQLStudies on 12 January 2015

Finding the reason for the error “Subquery returned more than 1 value”

First this type of error is because a subquery returned more than one row when it wasn’t allowed to. In some cases (setting the result to a variable or doing an equality (=) for example) a subquery can only return one row. Because this is a error that specifically mentions… Read more

1 comments, 425 reads

Posted in SQLStudies on 7 January 2015

SQL Judo’s Monthly Challenge – January 2014 – Restore the Master

Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be fun (and good practice) to start doing them and blog about it. Another major benefit is that it will force me to move out of… Read more

5 comments, 5,442 reads

Posted in SQLStudies on 5 January 2015

2014 in review

The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog.

Here’s an excerpt:

The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 160,000 times in 2014. If it were an exhibit at the Louvre Museum, it would take about 7 days for…

Read more

0 comments, 137 reads

Posted in SQLStudies on 30 December 2014

Older posts