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


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: January 2018

The difference between blogging about something you know, and something you are learning (Love blogging! Live!)

Challenge accepted!

The first thing…

Read more

4 comments, 507 reads

Posted in SQLStudies on 31 January 2018

How To: Install SQL Server on an Azure VM

Last month I demonstrated creating an Azure VM with SQL installed using one of the default templates. While this is a very easy way to stand up a SQL Server very quickly there are some downsides. Specifically, you have very few install options. For the most part, you can… Read more

2 comments, 535 reads

Posted in SQLStudies on 29 January 2018

Help it takes forever to open the SQL Server Log!

Just to be very clear, I’m talking about the SQL Server Log, not database logs. Sometimes this is called the Error Log (and in fact the text files containing the data are named ERRORLOG, ERRORLOG.1, etc) although it contains a lot more information than just errors. And just to make… Read more

0 comments, 425 reads

Posted in SQLStudies on 24 January 2018

What’s dbo?

Don’t you hate it how certain words (well, acronyms in this case) get reused to mean multiple things? dbo seems to cause a great deal of confusion because of this.

First, dbo is an acronym standing for DataBase Owner. And there are three common usages for… Read more

4 comments, 1,959 reads

Posted in SQLStudies on 22 January 2018

How to read a technical blog

There are thousands, tens of thousands, probably hundreds of thousands of blogs out there on all sorts of topics. If you do a search on a subject you are likely to get back multiple (if not large multiples) of responses and it can be hard to know what advice is… Read more

4 comments, 295 reads

Posted in SQLStudies on 17 January 2018

Who should own the database?

TL;DR; SA, or if you are really paranoid then you can create a disabled SQL login with minimal permissions and use that.

The database has to be owned by someone, doesn’t it? (FYI, yes it does) So who? How about Bob in accounting. It’s the accounting database. That makes sense… Read more

6 comments, 2,590 reads

Posted in SQLStudies on 15 January 2018

Fun with sp_rename

Currently the only way to rename objects in SQL Server is to use sp_rename. Although that may be changing in the near future. There is a new command RENAME that is specifically for Azure SQL Data Warehouse and Parallel Data Warehouse. With any luck they will migrate that… Read more

0 comments, 327 reads

Posted in SQLStudies on 11 January 2018

A Solution for Squirrely SQL Server Security: TSQL Tuesday #98

It’s the first T-SQL Tuesday of the year! Arun Sirpal (b/t) is our host this month. Thanks, Arun! The subject he has selected is Your Technical Challenges Conquered. This is a particularly hard subject for me. Generally, when I have a problem and come up… Read more

0 comments, 294 reads

Posted in SQLStudies on 9 January 2018

SQL Homework – January 2017 – Inspect an Execution Plan

It’s a new year and yet education never ends. So this month let’s take a look at an important part of performance tuning. The Execution Plan. When a query is run, the optimizer goes through and selects what it feels will be the good enough plan to plan that query.… Read more

6 comments, 2,486 reads

Posted in SQLStudies on 3 January 2018