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.

Blog Post

How to Convert FileTime to DateTime

One of my customers recently wanted to rename each of the SQL audit files will the datetime stamp of when it was created. I explained to them the filename...

2025-01-15 (first published: )

565 reads

Blog Post

Trace Flag 3625 Follow Up

Several months ago, I discussed my customer’s intention to enable trace flag 3625. Since that time, we have observed an intriguing phenomenon when encountering a login failure. To demonstrate...

2024-12-13 (first published: )

480 reads

Blog Post

How to Test Trace Flag 3625

Recently, one of my customers considered enabling Trace Flag 3625 on one of their SQL Servers, but they wanted a way to quickly test its functionality beforehand. For those...

2023-12-22 (first published: )

511 reads

Blogs

Azure Networking: Designing for Change

By

Failing to plan is planning to fail. When organizations first begin implementing Azure networking,...

Using Customer Docker Compose File Names

By

As I use containers more and more to run various things, I decided I...

SQL Server Failover Cluster Instances

By

Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve...

Read the latest Blogs

Forums

SQL Server authentication vs. Trusted connection

By Rod at work

I maintain an application written years ago, where the database is on a Windows...

Handling Engagement Rings & Wedding Band

By iBling Jewels

I’m working on a jewelry e-commerce project and need advice on designing an efficient...

The Duplicate Cursor

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Duplicate Cursor

Visit the forum

Question of the Day

The Duplicate Cursor

Can I run this code:

DECLARE ANewTable CURSOR FOR 
SELECT * FROM ANewTable

See possible answers