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

Remotely shutting down an instance

by Kenneth Fisher

SQLStudies

This month for T-SQL Tuesday Mike Donnelly (b/t) decided to pick a topic to fit in with Ed Leighton-Dick’s (b/t)...

2015-04-23 (first published: 2015-04-14)

5,313 reads

Backup before you restore

by Kenneth Fisher

SQLStudies

You should always be recoverable. If you haven’t heard that before, take note of it. It’s important.
A while back...

2015-04-22

495 reads

The hidden security of msdb

by Kenneth Fisher

SQLStudies

To be fair it’s not actually hidden, just not so well known.
Have you ever wondered how to grant permissions...

2015-04-20

1,384 reads

Adding, altering or removing multiple columns from a table

by Kenneth Fisher

SQLStudies

I was recently asked to do some fairly heavy modifications to a table. It involved adding 6 new columns, removing...

2015-04-16

666 reads

Make sure you back up the Service Master Key

by Kenneth Fisher

SQLStudies

I’m by no means an expert in SQL Server encryption. What I do know however, is that the Service Master...

2015-04-08

779 reads

What is a CTE

by Kenneth Fisher

SQLStudies

CTEs (Common Table Expressions) are one of the most interesting and useful tools added to T-SQL in the last decade....

2015-04-06

690 reads

Port numbers and SQL Server

by Kenneth Fisher

SQLStudies

I made a mistake the other day. I’ll admit it. I was wrong. Now I know all of you are...

2015-04-03 (first published: 2015-03-30)

8,313 reads

Microsoft buys the dictionary

by Kenneth Fisher

SQLStudies

It seems that Microsoft has finally gotten tired of all the jokes about the word “performant” or using “ask” as...

2015-04-01

482 reads

Clean out all bad characters from a string.

by Kenneth Fisher

SQLStudies

I have a customer who is having a problem with a load. He is getting a fair number of bad...

2015-03-25

1,084 reads

0 to Speaker

by Kenneth Fisher

SQLStudies

Recently the last day to submit a session for the 2015 Pass Summit rolled around. I mention this because I...

2015-03-23

688 reads

Blogs

Top 8 Courses to Learn SQL for Data Science in 2024 & Beyond

By Tracy McKibben

In the realm of data science, SQL (Structured Query Language) reigns supreme. It's your...

Going to Cloud? Look at the Shared Responsibility Model

By Brian Kelley

The bottom line here is this: the idea that a CSP takes care of...

How Long Will It Take to Learn SQL? The Truth Might Surprise You

By Tracy McKibben

In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...

Read the latest Blogs

Forums

WhatsApp +1 6573454360 buy parrots online

Explore a vibrant avian market online, offering a kaleidoscope of parrot species including majestic...

Restore dbs

The below code works for backup files only from local drives. When replaced with...

Fine-tune SQL for better performance

I have been asked to fine-tune the following SQL that was written by a...

Visit the forum

Question of the Day

Initial Config of tempdb

What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?

See possible answers