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

Virtual Log Files

Today’s post is a guest article from a friend of Dallas DBAs, writer, and fantastic DBA Jules Behrens (B|L) One common performance issue that is not well known that...

2020-11-24

21 reads

Renaming SQL Server Databases

Video walkthrough of renaming or “flipping” databases to minimize down time during a refresh.  Most commonly when moving a copy from prod to dev. My Pluralsight courses for new...

2020-10-12

5 reads

SQL Server Express Size Limit

My Pluralsight course for new SQL Server DBAs   (Needs to upgrade to a bigger bowl) Common scenario: Company is using SQL Server Express to save on licensing costs...

2020-07-02

200 reads

TIL: Dismount-DbaDatabase and Mount-DbaDatabase

We have a double feature for today’s dbatools blog post, as these two commands go hand-in-hand. Todays commands: Dismount-DbaDatabase and Mount-DbaDatabase Detach-DbaDatabase and Attach-DbaDatabase can be used as aliases....

2020-07-01 (first published: )

169 reads

TIL: Get-DbaErrorLog

Ed: SQLDork is a Junior DBA on the team here, learning the DBATools in addition to normal DBA stuff™ Today’s dbatools command is Get-DbaErrorLog, which is very similar to...

2020-05-29

17 reads

Blogs

Goal Progress–November 2020

By

This is my report, which continues on from the Oct report. It’s getting near...

Azure Synapse Analytics is GA!

By

(Note: I will give a demo on Azure Synapse Analytics this Saturday Dec 5th...

5 Things You Should Know About Azure SQL

By

Azure SQL offers up a world of benefits that can be captured by consumers...

Read the latest Blogs

Forums

Database, RAM and processor Information

By sizal0234

Hi, I need to find the size of all db's and server's processor and...

reference for writing stored procedures (especially spatial) in DB2

By pietlinden

I can write stored procedures in SQL Server ... is there a guide somewhere...

A Technology Collapse

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Technology Collapse

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers