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

774 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

892 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

462 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

582 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

419 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,026 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

631 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,055 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

635 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,662 reads

Discuss

Blogs

Future-Proofing: How to Stay Ahead in FinOps

Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...

Introducing the SQL Server on Kubernetes Operator

By Anthony Nocentino

Are you considering replatforming your SQL Server workload due to recent vendor changes, but...

Advice I Like: Rewards from Work

The greatest rewards come from working on something that nobody has words for. If...

Read the latest Blogs

Forums

Removing TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE

Poor Names

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Poor Names

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

Comments posted to this topic are about the item The day-to-day pressures of a...

Visit the forum

Question of the Day

Removing TDE

How do I remove TDE encryption of data from database xxx?

See possible answers