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/

In-Memory OLTP and the Identity Column

by Patrick

Everyday SQL

Over the past month I've been playing around with the new In-Memory OLTP (code name: "Hekaton") features within SQL Server...

2013-11-12

1,510 reads

TSQL Tuesday #47 - Your Best SQL Server SWAG

by Patrick

Everyday SQL

The host for T-SQL Tuesday #47 is Kendal Van Dyke (blog|twitter), and his topic of choice is about the best...

2013-10-08

950 reads

One Year Later

by Patrick

Everyday SQL

Wow! It’s been one year since I launched my blog, and my how things have changed.

Accomplishments Over the Past...

2013-09-24

691 reads

The Case of the NULL Query_Plan

by Patrick

Everyday SQL

As a DBA, we're often asked to troubleshoot performance issues for stored procedures. One of the most common tools at...

2013-09-06 (first published: 2013-09-03)

3,260 reads

How to Tell If Your Users are Connecting to the Availability Group Listener

by Patrick

Everyday SQL

You've spent a lot of time planning and building out a new SQL Server 2012 environment complete with Availability Group...

2013-08-29 (first published: 2013-08-27)

2,407 reads

PASS Summit 2013 - You Ain't From Around Here Are Ya?

by Patrick

Everyday SQL

I know what y'all are thinkin', what's Charlotte got to do with SQL Server? Just hear me out. There's a...

2013-08-20

1,279 reads

Are You the Primary Replica?

by Patrick

Everyday SQL

UPDATED -- Jul 3, 2015 -- To verify database exists, per comments by Konstantinos Katsoridis. Thanks for finding the bug!

In my recent adventures...

2013-07-23

1,641 reads

Setup an Availability Group with Multiple Subnets in VMware Workstation

by Patrick

Everyday SQL

Before we get started, I want to make it clear this is NOT how you would normally configure all these...

2013-07-16

2,519 reads

VMware vSphere Storage Performance - Thick vs Thin Provisioning

by Patrick

Everyday SQL

Industry experts will tell you that virtualization of your environment is not done to improve performance, it's done to make...

2013-06-25

4,427 reads

Investigating Plan Cache Bloat

by Patrick

Everyday SQL

SQL Server includes a DMV, sys.dm_exec_query_stats, that returns performance statistics for each query plan cached in memory. However, it can...

2013-05-28

1,135 reads

Blogs

Flyway Tips: AI Deployment Script Descriptions

With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...

A New Word: Fawtle

fawtle – n. a weird little flaw built into your partner that somehow only...

Post-quantum key exchange – Insurance policy for your packets

By anup.varier@gmail.com

AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...

Read the latest Blogs

Forums

High Availability setup - has anyone seen this method?

By Paul Lancaster

Hi all, I recently moved to a new employer who have their HA setup...

Semantic Search in SQL Server 2025

By Deepam Ghosh

Comments posted to this topic are about the item Semantic Search in SQL Server...

Encoding URLs

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Encoding URLs

Visit the forum

Question of the Day

Encoding URLs

I have this data in a table:

CREATE TABLE Response
( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY
, ResponseVal VARBINARY(5000)
)
GO

If I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use?

See possible answers