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

Synchronous vs Asynchronous

by Kenneth Fisher

SQLStudies

You’ll hear these terms thrown around in programming all the time, but what do they mean and why do we...

2016-10-24

772 reads

Installing SQLCMD

by Kenneth Fisher

SQLStudies

For anyone who wasn’t aware SQLCMD is a command line tool for running T-SQL statements and scripts. Before anyone says...

2016-10-19

825 reads

Using Snippets

by Kenneth Fisher

SQLStudies

A while ago I talked about Templates. This is an easy way to get a, well, template of a piece...

2016-10-17

459 reads

Too many indexes!

by Kenneth Fisher

SQLStudies

Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work.
Different indexes work best...

2016-10-13

574 reads

If backups are taken in silence can a recovery still take place?

by Kenneth Fisher

SQLStudies

My friend Andy Mallon (b/t) is hosting T-SQL Tuesday this month. In case you aren’t aware T-SQL Tuesday is a...

2016-10-11

416 reads

Pinned Tabs

by Kenneth Fisher

SQLStudies

It’s funny how easy it is to find information you aren’t looking for. A few weeks back Stephen Bennett (b)...

2016-10-10 (first published: 2016-09-27)

2,021 reads

Floor, Round, and Ceiling

by Kenneth Fisher

SQLStudies

I saw an interesting question today about rounding. Specifically they always wanted to round down. Now as it happens that...

2016-10-05

623 reads

A quick fix for a full identity column.

by Kenneth Fisher

SQLStudies

A while back I wrote a post on everything I knew about identity columns. In it I mentioned the following:
Negative...

2016-10-03 (first published: 2016-09-21)

2,050 reads

Becoming a Microsoft MVP

by Kenneth Fisher

SQLStudies

I was awarded the Microsoft MVP (data platform) award on Saturday.
On the four days a year (one per quarter) when...

2016-10-03

630 reads

Constant Data Types

by Kenneth Fisher

SQLServerCentral.com

Data Types

Data types are an important part of how tables and variables work. Did you know that constants have databases too?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(17)

Log in or register to rate

You rated this post out of 5. Change rating

2016-10-03

1,655 reads

Discuss

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