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

Why do I (they) own that database?

Ever looked at the list of databases and wonder why you own one of them? Or why some other user owns the database? Just to be clear, by owner I mean the one and only actual owner of the database, not just a member of the db_owner role. This… Read more

2 comments, 82 reads

Posted in SQLStudies on 20 February 2019

Error in SSMS: Attempted to read or write protected memory.

There are a lot of reasons to write a blog post. One of my favorites is when I’ve been asked the same question multiple times (frequently by multiple people). I write a blog, everyone reads it and I never get asked the question again! Right? No? Yea, probably not. But… Read more

2 comments, 68 reads

Posted in SQLStudies on 18 February 2019

DBA Myths: Can a differential backup get bigger than the full backup?

The thing about DBA Myths is that they are generally widespread and widely believed. At least I believed this one until I posted What’s a differential Backup? and Randolph West (b/t) pointed out that my belief that differential backups can’t get larger than full backups was… Read more

4 comments, 386 reads

Posted in SQLStudies on 14 February 2019

What is your why?: T-SQL Tuesday #111

This month Andy Leonard (b/t) wants to know why we do what we do. Funnily enough, this is something I think about on a fairly regular basis. Like most people, I have a lot of reasons for doing things, but for me, most of them come… Read more

0 comments, 636 reads

Posted in SQLStudies on 12 February 2019

Using Cloud Academy

The other day I talked about using Microsoft Learn. Well, honestly, Cloud Academy is the learning tool I’ve been using the most recently. It’s not free (we’ll get to pricing in a minute) but it is something that my company is paying for and encouraging us to use. In… Read more

0 comments, 174 reads

Posted in SQLStudies on 6 February 2019

SQL Homework – February 2019 – Instance configurations

This homework series really has two purposes. It’s a primer for beginners. These are tasks I think most if not all database developers and DBAs should know how to do. And giving it at least one shot means you’ll be more comfortable when the task inevitably comes up. On the… Read more

4 comments, 155 reads

Posted in SQLStudies on 4 February 2019

See SQL Run

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

Read more

5 comments, 178 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, 2,277 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,074 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,516 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,872 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, 682 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, 138 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, 158 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,034 reads

Posted in SQLStudies on 2 January 2019

Using Microsoft Learn

I’ve just signed up on Microsoft’s new learning opportunity Microsoft Learn. The main categories are Azure, Business Apps, and Windows Development. There seem to be quite a few classes for each category and at that this is still fairly new and I expect it will grow over time. Everything… Read more

3 comments, 376 reads

Posted in SQLStudies on 31 December 2018

Identity in a SELECT

Always be learning right? So when I saw this I had to go HU?! That’s new. What’s going on here?

SELECT
	IDENTITY(INT, 1,1) AS Id,

Now, looking at it a bit more closely you’ll see that this is a function call, not just a property. Now, in my… Read more

4 comments, 3,784 reads

Posted in SQLStudies on 19 December 2018

Savings changes is not permitted. The changes you have made require the following tables to be dropped and re-created.

Microsoft does a lot of things to try to help us not shoot ourselves in the foot. This little error is one of them. It’s an annoying error, and almost everyone turns it off automatically, so what is it and why is it there? Well, by default, when using the… Read more

4 comments, 928 reads

Posted in SQLStudies on 17 December 2018

Bulk insert and an identity column

TL;DR; BULK INSERT doesn’t have an easy way to specify a column list so the columns in the insert file must match the columns in the table unless you use a format file or a staging table.

As simple as they appear on the surface identity columns are fairly complicated… Read more

1 comments, 302 reads

Posted in SQLStudies on 12 December 2018

Moving SSISDB is not as easy as it sounds

We’ve been doing a lot of upgrading recently and at one point had to move an instance from one 2016 server to another. In the process, we found out (the hard way) that it’s not that easy to move SSISDB (the SSIS Catalog that may or may not be named… Read more

0 comments, 170 reads

Posted in SQLStudies on 10 December 2018

Older posts