Kenneth Fisher

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 https://sqlstudies.com/.

The parts of an object’s name

by Kenneth Fisher

SQLStudies

Any object within a database in SQL Server has what is called a four part name. Which rather implies four...

2017-03-20

359 reads

Review of Azure Fundamentals class on Openedx

by Kenneth Fisher

SQLStudies

My company has recently adopted a Cloud first attitude. Now that’s different from Microsoft’s Cloud first. Microsoft is putting new...

2017-03-08

512 reads

Queries with optional parameters

by Kenneth Fisher

SQLStudies

These are those queries where you are pulling for, let’s say, a first name, a last name, a state, and/or...

2017-03-06 (first published: 2017-02-27)

3,525 reads

Using GROUP BY instead of DISTINCT

by Kenneth Fisher

SQLStudies

Recently, Aaron Bertrand (b/t) posted Performance Surprises and Assumptions : GROUP BY vs. DISTINCT. In it he says he prefers GROUP...

2017-03-06

2,436 reads

Event storming! It’s raining emails!

by Kenneth Fisher

SQLStudies

One of the most common ways to get an event notification is by email. So what happens when you get...

2017-03-01

379 reads

What’s in my backup file?

by Kenneth Fisher

SQLStudies

Restoring a backup file is pretty easy right?
RESTORE DATABASE [Test] FROM DISK = 'C:\backups\backup.bak';Ok, but what if more than one database...

2017-02-22

938 reads

Penny wise, pound stupid

by Kenneth Fisher

SQLStudies

Growing up my mother used this phrase quite a bit. Penny wise, pound stupid. (In case you didn’t know the...

2017-02-20

414 reads

Deadlock priority

by Kenneth Fisher

SQLStudies

Everyone deals with deadlocks from time to time. But sometimes we need to control who’s the deadlock victim and who...

2017-02-17 (first published: 2017-02-08)

2,896 reads

Deadlock on ALTER DATABASE

by Kenneth Fisher

SQLStudies

I had an interesting problem recently. A database was stuck in single user mode. How exactly was it stuck you...

2017-02-16

1,413 reads

Server level database permissions

by Kenneth Fisher

SQLStudies

Sometimes you have a requirement to grant permissions to every database on an instance. Historically this has required creating a...

2017-02-14

720 reads

Blogs

Why Databases Still Fascinate Me

I get asked a lot about why or how I began working with databases...

Monday Monitor Tips: ServiceNow Integration

Earlier this year I visited a customer that was using the Redgate Monitor webhook...

Inspecting TSQL Abstract Syntax Trees

TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....

Read the latest Blogs

Forums

How Do I Choose a Good Ophthalmologist in Dubai for Eye Checkups?

By Dr. Medha Sharma

Choosing the right Ophthalmologist in Dubai starts with checking credentials, experience with children, and...

SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration

Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...

Cannot get KB959420

By fabio@fullin.com.ar

Hi, we lost our sever sql2000 To restore database to a new one we...

Visit the forum

Question of the Day

The New Database CheckDB

I run this code:

create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')

What is returned?

See possible answers