Kevin3NF

Kevin Hill is a career SQL Server DBA living in Dallas, TX. His specialities include HA/DR, Best Practice configuration, Performance tuning and teaching new and accidental DBAs
  • Interests: Cycling, family, sci-fi, DBA stuff

Blog Post

SQL Server Best Practices

As a CIO or CTO, one of your primary responsibilities is to ensure that your organization’s data is managed effectively and efficiently. To do this, you need to have...

2022-09-14

8 reads

Blog Post

SQL Server Migration and Upgrade

(This post written by Jon Biggs (t), one of our Senior DBAs) We are currently performing migrations with upgrade of multiple-instance SQL Servers to new servers. The migrations are...

2022-03-22

27 reads

Blog Post

Group By Starting Characters

I was chatting with Jeff (b|t) on my team yesterday and the context escapes me but I had this thought: “Can you Group By the beginning characters, or a...

2021-10-29 (first published: )

475 reads

Blog Post

Do Full Backups Break Log Shipping?

TLDR: Nope. Keep on doing your full backups. Make sure that any databases you Log Ship are NOT also doing log backups in your SQL Maintenance Plans, Ola Jobs,...

2021-10-22 (first published: )

296 reads

Blog Post

How old are those stats?

SQL Server maintains a variety of stats about all sort of performance items. Index usage (or missing indexes) Query performance Corrupt pages Disk IO performance Way more than I...

2021-10-11 (first published: )

282 reads

Blog Post

TIL: Backup-DbaDatabase

(This post comes from one of our Junior DBAs – @SQLDork) I’m learning how to use dbatools. Today’s command: Backup-DbaDatabase I’m using the 64-bit PowerShell ISE (running as administrator),...

2021-04-26 (first published: )

521 reads

Blogs

Registered for the Data Community Summit

By

I was reminded this week that I needed to get registered for the Data...

Daily Coping 5 Oct 2022

By

Today’s coping tip is to choose to see your mistakes as steps to help...

Restore HEADERONLY and FILELISTONLY

By

Good day reader.  This post is coming to you from a busy week in...

Read the latest Blogs

Forums

Change tracking - Date a row changed

By cbarus

We have change tracking enabled on one of our databases and I am looking...

Grant user permissions to a view but the base tables live in another database

By Maxer

I have two databases on the same server.  I have a service account I...

The ORDER BY clause is invalid in views

By micky007

Hi, I'm trying to run the below SQL code but I'm getting this error:...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers