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.

Twitter: @patrickkeisler
Website: https://www.patrickkeisler.com
LinkedIn: https://www.linkedin.com/in/patrickkeisler/

Capture Index Usage Statistics for Better Analysis

by Patrick

Everyday SQL

Starting with SQL Server 2005, Microsoft introduced Dynamic Management Views to help DBAs see what's going inside of SQL Server....

2012-10-23

2,513 reads

Which SQL Instance is Killing Your CPU?

by Patrick

Everyday SQL

You have 5 instances running. How do you know which one is killing your CPU?

As you can see from Windows...

2012-10-16

546 reads

Grant Execute Permission on All Stored Procedures

by Patrick

Everyday SQL

Right out of the box, SQL Server makes it pretty easy to grant SELECT, INSERT, UPDATE, and DELETE to all...

2012-10-10

11,940 reads

How to Make SQL Server Listen on Multiple Ports

by Patrick

Everyday SQL

Have you ever needed an instance of SQL Server to listen on multiple TCP/IP port numbers but didn't know how...

2012-10-05

1,163 reads

Use Powershell to Manage Idera SQL Diagnostic Manager

by Patrick

Everyday SQL

Idera SQL Diagnostic Manager (or as I call it "SQLdm") is a great monitoring and performance tuning tool that I...

2012-09-28

2,676 reads

Welcome to Everday SQL

by Patrick

Everyday SQL

My name is Patrick Keisler and I have been a Microsoft SQL Server DBA for over 12 years. During that...

2012-09-22

343 reads

Blogs

A New Word: Amoransia

amoransia – n. the melodramatic thrill of unrequited love; the longing to pine for...

The Data API Builder Start and Add Extensions in VS Code

One of the things that I like about the Data API Builder (DAB) is...

Using OneLake for Excel Files in Microsoft Fabric

By DataOnWheels

Hey data friends! This blog is to discuss an edge case I’ve run into...

Read the latest Blogs

Forums

DbDefence - how does work this tool?

How it is implemented? I have installed, tried, it is free for dbs <=30...

Technical Pain Behaviors

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Technical Pain Behaviors

trying to call powershell from TSQL statement

Hello, trying to call a powershell file I created, locally on the server, but...

Visit the forum

Question of the Day

Counting Bits

What does the BIT_COUNT function do in SQL Server?

See possible answers