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

IRL #8: SQL Server Down

Problem: My PocketDBA® client called in with a non-responsive SQL Server. Application errors, timeout, alerts firing. SQL Server box is up, and the services are running. Background: This is...

2023-09-06

23 reads

Blog Post

SQL Server is not a Car

Lets compare them anyway, just for fun. Both have an engine Both have a monitoring device (Dashboard/Activity Monitor) Both need power (Gas/Electricity) Both need to be told what do...

2023-09-05

24 reads

Blog Post

Code That Writes Code

“Work Smarter, not Harder” We’ve all heard it before, pretty much any job, anywhere. In our DBA slice of the IT world, this is very relevant to how we...

2023-05-08 (first published: )

499 reads

Blog Post

Where Is My SQL Server Errorlog?

If you need to find the SQL Server ErrorLog in a hurry and don’t want to spend 30 minutes drilling into every drive on the server: “I don’t watch...

2022-11-21 (first published: )

241 reads

Blog Post

SQL Server Registered Servers

Query multiple SQL Server instances at one time! Thanks for watching! Kevin3NF Follow @Dallas_DBAs
The post SQL Server Registered Servers appeared first on DallasDBAs.com.

2022-11-09 (first published: )

373 reads

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

12 reads

Blogs

Quick Filtering in SSMS–#SQLNewBlogger

By

I saw someone limit the databases they see in SSMS, which isn’t something I...

Penetration Testing your SQL Server, Part 1 – The Recon Mission

By

Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...

SQL Saturday Denver 2023–VCS Primer for the Database slides

By

My slides are here: VCS Primer Denver 2023 This was an overview of what...

Read the latest Blogs

Forums

High tempdb usage alternatives

By anoop.mig29

Hi We have an stored procedure which runs frequently and  it contain logic in...

high latency in sql server transactional replication

By anoop.mig29

Hi I am new to replication and we have database of size around 2TB...

get week number of month

By GrassHopper

I want to query a table that has a datetime column ([CreateDateTime])  and get...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers