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

Dem queries

Dem queries, dem queries, dem slow queries,
Dem queries, dem queries, dem fast queries,
Dem queries, dem queries, dem big queries,
Now write dem crazy queries!

The common table expression (CTE)’s connected to the SELECT clause,
The SELECT clause is connected to the FROM clause,
The FROM clause is connected… Read more

2 comments, 889 reads

Posted in SQLStudies on 27 February 2019

Using the Microsoft Authenticator app to log into Azure

So I was trying to work on a blog post about the new truncation error this morning and realized I don’t have the version of SQL that I need installed on my machine (SQL 2019). I could (and probably should) install it on my machine at some point, but this… Read more

0 comments, 172 reads

Posted in SQLStudies on 25 February 2019

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, 120 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, 86 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

6 comments, 2,377 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, 659 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, 200 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, 186 reads

Posted in SQLStudies on 4 February 2019