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

See SQL Run

Note: I am perfectly aware of my ability as an artist so let the ribbing begin

Read more

5 comments, 171 reads

Posted in SQLStudies on 30 January 2019

Disabling Indexes

Indexes are probably the number one tool we have to improve performance. That said, there are times when we want to put that index on hold. While indexes dramatically improve read performance they do cause a slight dip in write performance. This isn’t significant most of the time but… Read more

1 comments, 695 reads

Posted in SQLStudies on 28 January 2019

What’s a differential backup?

Of the different basic types of backups (full, differential and log) I find the differential the most interesting, and frequently the least understood. Full backups are easy. The whole database including any log information needed to make the committed transactions durable. Transaction logs aren’t much more complicated. They contain information… Read more

1 comments, 2,020 reads

Posted in SQLStudies on 23 January 2019

Read-only tables

Sometimes you need a table that is read only. You don’t want anyone to be able to write to it for various reasons. It might be historical data that shouldn’t/can’t be changed, it might be lookup information that shouldn’t be changed, etc. There are a couple of ways to… Read more

4 comments, 2,491 reads

Posted in SQLStudies on 21 January 2019

Controlling the firewall for an Azure SQL DB via T-SQL

The other day I took a Microsoft Learn course about securing Azure SQL DB. It was really enjoyable and I learned quite a bit, but one of the things that really stood out was the fact that you can control the firewall via T-SQL. Now the reason this stands out… Read more

2 comments, 1,862 reads

Posted in SQLStudies on 16 January 2019

SQL Bits 2019: The Great Data Heist

SQL Bits is almost here! It’s February 27th to March 2nd. SQL Bits is one of the most popular SQL conferences out there and you still have time to make it! (Although not much, that’s only about a month and a half).

As much as I love PASS and PASS… Read more

0 comments, 680 reads

Posted in SQLStudies on 14 January 2019

#SQLCareer 4/4 January 2nd 2019

Last July (yes, it’s taken me 5+ months to finally finish this) Steve Jones (b/t) suggested that it might be helpful if those of us that work in the IT/database field shared four random days out of our lives. This is the last of mine.

The… Read more

0 comments, 135 reads

Posted in SQLStudies on 10 January 2019

Automation starts by doing something once, very very carefully: T-SQL Tuesday #110

After a while the intros for my T-SQL Tuesday posts get a little boring. So without any further ado, it’s that time, Garry Bargsley (b/t) is our host and the subject is

Automate all the things

Now Garry asked us to tell about something we automated… Read more

5 comments, 152 reads

Posted in SQLStudies on 8 January 2019

SQL Homework – January 2019 – Baselines

Happy New Year! Every year for New Years we all make a big deal of coming up with New Years Resolutions. Here’s one from me to you.

Baselines

Why are baselines important? Have you ever heard The server is slow? Is it? Can you be sure? I mean… Read more

0 comments, 1,028 reads

Posted in SQLStudies on 2 January 2019