Patrick

Patrick Keisler is a Senior CSA - Engineering for Microsoft with over 20 years of SQL Server experience working in various fields such as financial, healthcare, and government. You can follow him on Twitter or listen to him speak at various SQL Saturdays and user group meetings.

All authors

All authors

Blogs

The Comprehensive Guide to Mastering Your SQL DBA Skills

By

Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...

Friday Basics: Authentication vs. Authorization

By

Another security fundamentals topic is authentication versus authorization. For those who have a clear...

A New Word: mcfeely

By

mcfeely – adj. inexplicably moved by predictable and well-worn sentiments, even if they are...

Read the latest Blogs

Forums

Performance

By LearningDBA

Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...

How to install mysql-connector-python-8.4.0.zip it does not have setup.py

By ivanb

How to install mysql-connector-python-8.4.0.zip it does not have setup.py. Checked also: mysql-connector-python-8.4.0.tar.gz

when primary is down and not accessible failover not occured then how to recover

By naga.rohitkumar

HI All, can any one reply on this when primary is down and not...

Visit the forum

Question of the Day

Two Table Hints

What happens when I run this code: 

SELECT
  p.ProductName
, p.ProductCategory
FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);

See possible answers