Click here to monitor SSC
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.

Creating a connect entry.

I recently wrote a blog about how to tell why your SQL login isn’t working. There were a lot of good comments and several of them suggested that I create a connect entry to make the error easier to understand. There was also a question of how to create… Read more

4 comments, 66 reads

Posted in SQLStudies on 23 January 2017

Lead Blocker

Blocking is just part of life I’m afraid. Because we have locks (and yes we have to have them, and no, NOLOCK doesn’t avoid them) we will have blocking. Typically it’s going to be very brief and you won’t even notice it. But sometimes you get a query or… Read more

5 comments, 107 reads

Posted in SQLStudies on 18 January 2017

What is COPY_ONLY?

You’ll frequently hear that you should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up the backup chain. Just in case you haven’t: You should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up the backup chain.

But you may… Read more

2 comments, 1,690 reads

Posted in SQLStudies on 16 January 2017

Why won’t my SQL Logins work?

I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a side by side upgrade and the only server principals used by the application were SQL Server authenticated logins. I tried over and over again but kept getting the same error. Read more

9 comments, 335 reads

Posted in SQLStudies on 12 January 2017

Connect suggestion to add included columns to sp_helpindex

I’m a big fan of the sp_help system stored procedures, which is why I’ve been a bit disappointed that the sp_helpindex stored procedure is rather badly flawed. It doesn’t have the included columns from the index. This seems a bit strange to me since included columns first appeared in… Read more

0 comments, 124 reads

Posted in SQLStudies on 10 January 2017

A detailed view into your Azure resources

I’ve been studying Azure recently and came across a really interesting Azure site.

resources.azure.com

To give you an idea why I find this view so interesting I’m going to drill down to a SQL Database that I have.

Up front, you can see some interesting information. The location, status, service… Read more

0 comments, 962 reads

Posted in SQLStudies on 5 January 2017

sp_refreshsqlmodule_internal – The user does not have permission to perform this action.

Honestly, I’m only posting this because I had a hard time finding anything posted on this error and I found it somewhat unclear. Here is a quick walk through to produce the error:

-- Create server principal.
CREATE LOGIN SQLTest WITH PASSWORD = 'SQLTest';
GO
-- Create a database principal…

Read more

0 comments, 151 reads

Posted in SQLStudies on 28 December 2016

A semester’s worth of Backup and Recovery blogs – The TSQL Tuesday 85 Rollup

I was thrilled to host TSQL Tuesday #85, the last TSQL Tuesday of 2016. My subject was backup and recovery and I was pleased to see this line of my invitation quoted several times.

Backups are one of the most common things DBAs discuss, and they are at once one…

Read more

0 comments, 163 reads

Posted in SQLStudies on 26 December 2016

sp_helptext vs object_definition()

I’ve been using sp_helptext for years. Honestly I probably end up using it at least once a day. But I was recently exposed to object_definition() which has a similar output. There are, however, a few differences.

sp_helptext

This system function returns the text of any (T-SQL) code based object. I.e.… Read more

3 comments, 153 reads

Posted in SQLStudies on 21 December 2016

:OUT :OUT darn results!

Years ago I worked for a company that had a rather cool way of handling requests. When we ran the request the query we used and the output were saved to a directory on the network. This way if there were any questions about what had been done we had… Read more

2 comments, 129 reads

Posted in SQLStudies on 19 December 2016

An interview with me

The other day I received an email asking for some help with a school project. Would I please answer some questions about my career and industry. Well after some due diligence I answered the questions. But the questions were rather interesting and the answers turned out pretty well (IMHO) so… Read more

6 comments, 157 reads

Posted in SQLStudies on 15 December 2016

DBA Myths: You can only restore one differential backup

Ok, I know I’m hosting T-SQL Tuesday this month but I still had post I wanted to share.
 

The basic steps when restoring backups are

Full Recovery

  1. The most recent full backup.
  2. The most recent differential backup.
  3. All log backups after the most recent differential.

 
Simple Recovery

  1. The…

Read more

1 comments, 144 reads

Posted in SQLStudies on 13 December 2016

Fixing Data Migration Assistant timeouts

I’ve been really excited about the new Data Migration Assistant (DMA) since I first heard about it. One of the things I like best about it is that unlike the old Upgrade Advisor it doesn’t have to be run on the server being upgraded. You can run it against… Read more

0 comments, 167 reads

Posted in SQLStudies on 8 December 2016

TSQL Tuesday #85 Invite – Backup and Recovery

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.

No. Wait. Sorry, that was last time. This time I want to hear about backup and recovery.

Backups are one of the most common… Read more

10 comments, 203 reads

Posted in SQLStudies on 6 December 2016

Using OUTPUT with a field list.

I recently wrote an article for SQL Server Central about using OUTPUT. In case you aren’t aware OUTPUT is a clause that lets you output the changed data from an INSERT, UPDATE, DELETE, or MERGE statement. One of the comments on the article was a question… Read more

2 comments, 160 reads

Posted in SQLStudies on 30 November 2016

Easy to read CHECKDB

If you ask a senior DBA what are the top 5 most important commands in T-SQL you’ll probably see DBCC CHECKDB in most if not all of those lists. Unfortunately, the output can be long, overwhelming and a more than a bit difficult to read. So here are a few… Read more

9 comments, 1,702 reads

Posted in SQLStudies on 28 November 2016

It greatly pleases me to announce, HAL0003!

I while back as part of a T-SQL Tuesday post I created HAL0001, then later HAL0002 with a long-term goal of building up a database version of HAL9000. Well, at the rate I’m going I may have to pass this on to my kids (or even grandkids). But in… Read more

10 comments, 203 reads

Posted in SQLStudies on 23 November 2016

Reload a table quickly.

Sometimes loading new data or even changes into a table just isn’t going to work. You need a complete reload. A summary table of data from the previous month, for example. It just doesn’t make sense to do an update. You delete/truncate and you re-load. Unfortunately, this leaves the table… Read more

4 comments, 1,926 reads

Posted in SQLStudies on 21 November 2016

SQLSkills waits and latches library

SQLSkills is an amazing resource for the SQL Server community. Between their blogs, white papers, and the SQLSkills Insider emails you should make a point of taking a look. But earlier this year they announced an absolutely astounding new offering. A library of wait types and latches. So now… Read more

2 comments, 290 reads

Posted in SQLStudies on 16 November 2016

When was my index created or at least last updated?

SQL Server stores a create date and a change date for each object in the sys.objects system view.

Unfortunately while tables, views and even constraints are objects, indexes are not. Or at least they aren’t stored in the sys.objects system view. And the sys.indexes system view doesn’t have any dates… Read more

1 comments, 1,495 reads

Posted in SQLStudies on 14 November 2016

Older posts