-->
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.

Deploy an SSIS project to the SSIS catalog.

You’ve installed SSDT, created an SSIS project, created any packages you need and now you want to place that project and its packages onto the SQL instance so you can run them. FYI there are several ways to do this using package or project deployment, I’m just going… Read more

0 comments, 117 reads

Posted in SQLStudies on 21 August 2017

Creating an SSIS project

Now that SSDT (SQL Server Data Tools) has been installed the next step is to create a project. First, open up Visual Studios 2015 or SQL Server Data Tools 2015 (SSDT is really just a set of modules added to Visual Studio).

Menu File -> New -> Project

Here we… Read more

0 comments, 143 reads

Posted in SQLStudies on 16 August 2017

Installing the (currently) latest Data Tools

I’m working on a project right now and it’s going to require me not only to refresh my SSIS skills a bit but learn a few things that are only available with the latest tools. So everyone ready for a few SSIS posts? Good. Me too!

Step One and Post… Read more

5 comments, 137 reads

Posted in SQLStudies on 14 August 2017

500 posts

Well, that’s something to be proud of. This is my 500th post on this blog. Not including a handful of articles and posts on other people’s blogs. I have to admit, when I started (almost exactly 5 years ago) I don’t think I expected to have reached this point. In… Read more

6 comments, 171 reads

Posted in SQLStudies on 10 August 2017

Interview Patterns and Anti-Patterns Combined

It’s that time again. T-SQL Tuesday. The monthly blog party started by Adam Machanic (b/t) seven and a half years ago!! We have a host, who picks a topic (on the first Tuesday of the month) and then we all write about that topic over the… Read more

4 comments, 100 reads

Posted in SQLStudies on 8 August 2017

SQL Homework – August 2017 – Create a table

If you didn’t see it last month I’ve started doing monthly SQL Homework. The first month was backups, this month it’s tables.

Here is your homework for August!

  1. Create a table with at least 3 columns.
  2. Add 5 rows to the table.
  3. Add one column to the table.
  4. Update…

Read more

2 comments, 153 reads

Posted in SQLStudies on 2 August 2017

DBA Dice

I’ve always thought it would be fun to have a DBA themed magic 8-ball. Now you may not be aware of this but the inside of a magic 8-ball is actually a 20 sided die. So since a custom magic 8-ball is more than this cheap geek is willing to… Read more

0 comments, 117 reads

Posted in SQLStudies on 31 July 2017

Performance is bad. Did you change anything recently? No. Are you sure?

Ever have this conversation?

Dev: Hey, can you help me? The performance on my application is terrible all of a sudden.
DBA: Sure thing. Has any code changed recently?
Dev: No. Nothing’s changed at all. Everything is just suddenly slower.
DBA: Are you sure?

Want to bet some code has… Read more

3 comments, 2,563 reads

Posted in SQLStudies on 26 July 2017

Default SQL Agent Reports – Top Jobs

Looking at what a job has been doing is important. Particularly if something is going wrong. Now there are several ways to do this depending on your preference. You can use the system views.

 
Honestly, though, as much as I love writing queries for… Read more

1 comments, 180 reads

Posted in SQLStudies on 24 July 2017

Default Database Reports – Disk Usage by Table

Every now and again you need to know how big a table is. Or several tables. Or all of the tables. Number of rows is frequently handy when you’re going to create a new index or otherwise modify the table. The amount of space used by the indexes can be… Read more

1 comments, 1,450 reads

Posted in SQLStudies on 19 July 2017

Default Instance Reports – Configuration Changes History

Hey, who changed the max memory setting for the xyz instance? The good news is that this information is captured in the default trace. Even better is the fact that there is a report that will pull the data out of the default trace and make it nice and… Read more

0 comments, 943 reads

Posted in SQLStudies on 17 July 2017

Default reports in SSMS

As DBAs our stock in trade is information and there is certainly an impressive amount available. The diagnostic views are the most common place to get the information we need but every now and again it’s nice to get an organized/pretty view. To that end, you can write your own… Read more

1 comments, 2,183 reads

Posted in SQLStudies on 13 July 2017

Save and save often

It’s the second Tuesday of the month, and as I’m sure you remember that means it’s time for T-SQL Tuesday! This month we are hosted by Raul Gonzalez (b/t) and the topic is Lessons learned the hard way.

I’m going to take this opportunity to… Read more

2 comments, 198 reads

Posted in SQLStudies on 11 July 2017

What is the system_health extended events session?

Similar to the default trace the system_health session is automatically started up when the instance starts and collects information about what’s going on.

Per BOL you get the following information:

  • Errors with a severity of >= 20.
  • Memory related errors (Errors 17803, 701, 802, 8645, 8651, 8657 and 8902).
  • Non-yielding…

Read more

1 comments, 1,054 reads

Posted in SQLStudies on 5 July 2017

SQL Homework – July 2017

For years Russ Thomas (b/t) has done a Monthly DBA Challenge and in fact I’ve used it as insperation a number of blog posts myself. Here is part of his description of it:

Often the task is what I consider a low frequency / high liability…

Read more

9 comments, 202 reads

Posted in SQLStudies on 3 July 2017

SQL Crossword : T-SQL Keywords : June 2017

I did a SQL crossword last month (not my first one either) and it was pretty popular so I asked around and I’ve decided to make this a regular thing (end of the month or so) for a little while (till I get bored with it). I’m going… Read more

2 comments, 1,821 reads

Posted in SQLStudies on 28 June 2017

Temp table quiz

Brent Ozar (b/t) posted a pop quiz on twitter earlier today.

Go ahead and give it a shot .. I’ll wait.

So? What do you think? Did you get it right? I did, but I wasn’t 100% certain, nor did I initially think through all of… Read more

10 comments, 348 reads

Posted in SQLStudies on 26 June 2017

Dynamically generate the command line DMA statement for each database

If you are upgrading your instance to 2016 (or 2017 soon) then you probably are going to want to run the DMA (Database Migration Assistant). If you are doing a BUNCH of upgrades at once (say 100 instances or something) then you probably don’t want to use the… Read more

0 comments, 323 reads

Posted in SQLStudies on 21 June 2017

Adding Identity to an existing column

A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He then ran into an issue where he had to have one. The easiest thing is to create a new int column with an identity column right? Unfortunately in this case… Read more

1 comments, 263 reads

Posted in SQLStudies on 19 June 2017

Turning ANSI_PADDING off, and why you shouldn’t

I ran into an interesting error the other day while doing a partition switch.

Partition switch failed because : column ‘xyz’ does not have the same ANSI trimming semantics in tables ‘a’ and ‘b’

It turned out it was because the ANSI_PADDING setting was different between the two tables (well,… Read more

4 comments, 1,976 reads

Posted in SQLStudies on 15 June 2017

Older posts