---

Filter by type:

• All
• Blog Posts

PASS is Gone

• by Patrick

• Everyday SQL

On January 15, 2021, PASS will cease to exist. https://www.pass.org/PASS-Blog/ArticleID/888/ArtMID/99177/preview/true I cannot tell you how much this disappoints me. PASS has been around for my entire database career, and...

2020-12-29

Management Studio Find & Replace Using Regular Expressions

• by Patrick

• Everyday SQL

In my last Management Studio tip, I demonstrated how you can drag and drop column names to a query window. The only part I do not like about that...

2020-07-28

1 reads

Management Studio Drag & Drop Column Names

• by Patrick

• Everyday SQL

Continuing on my recent trend of Management Studio tips, here is another that could save you a few minutes. In today’s scenario, we need to write a select statement...

2020-07-07

SQL Server Audit Recipe – xp_cmdshell

• by Patrick

• Everyday SQL

This article assumes you already have a basic understanding of SQL Server Audit, but if not, use this link to catch...

2018-07-17

157 reads

SQL Server Morning Health Checks

• by Patrick

• Everyday SQL

Every now and again as a Microsoft PFE, you get a chance to make a big difference for a customer....

2018-01-08 (first published: 2018-01-02)

2,520 reads

Create a Whitelist for SQL Server - UPDATED!!!

• by Patrick

• Everyday SQL

A while back, I posted an article about creating a WhiteList for access to SQL Server. Since then I have...

2017-05-16

3,007 reads

Dear McAfee, Why are you destroying my buffer pool?

• by Patrick

• Everyday SQL

For the past few months, one my customers had been trying to diagnose an issue with SQL Server paging out...

2017-05-02

1,140 reads

Blob Auditing for Azure SQL Database

• by Patrick

• Everyday SQL

In February 2017, Microsoft announced the general availability of Blob Auditing for Azure SQL Database. While auditing features were available...

2017-04-18

622 reads

AzureRM Module Version

• by Patrick

• Everyday SQL

When working with the AzureRM PowerShell module, remember the module is constantly being updated to take advantage of new features...

2017-04-13

348 reads

A Goal of Speaking at PASS Summit

• by Patrick

• Everyday SQL

Everyone has goals or at least they should have goals. As a young professional out of college, I had plenty...

2016-09-26

561 reads

Filter by type:

• All
• Blog Posts