-->
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: July 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, 219 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,885 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, 248 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,604 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, 1,079 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,361 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, 264 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,195 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, 256 reads

Posted in SQLStudies on 3 July 2017