Ed

Ed Leighton-Dick is a SQL Server performance and architecture expert and Founder/Principal Consultant of Kingfisher Technologies, a consultancy focused on SQL Server performance, architecture, and security. He is a frequent volunteer with PASS, including roles as regional mentor, chapter leader of I-380 PASS SQL Server User Group, and organizer of SQL Saturday Iowa City. He can often be found teaching sessions at local, regional, and national events, including user groups, SQL Saturday events, and Iowa Code Camp. Ed can be reached through his blog, edleightondick.com, and on Twitter at @eleightondick.

All authors

Blog Post

SQLNewBlogger, Week 3

I have a confession to make: I haven’t been writing much this week.
Last weekend, I didn’t feel well and didn’t...

2015-11-15

212 reads

Blog Post

SQLNewBlogger, Week 3

I have a confession to make: I haven’t been writing much this week.
Last weekend, I didn’t feel well and didn’t...

2015-11-15

218 reads

Blog Post

SQLNewBlogger, Week 3

I have a confession to make: I haven’t been writing much this week.
Last weekend, I didn’t feel well and didn’t...

2015-11-15

320 reads

All authors

Blogs

How to Run Databases on Kubernetes: An 8-Step Guide

By

In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...

Episode 11 of Simple Talks: Oracle

By

The 11th episode is now live, recorded a few weeks ago at the PASS...

A New Word: Mornden

By

mornden – n. the self-container pajama universe shared by two people on a long...

Read the latest Blogs

Forums

What is the best index strategy for a table that gets truncated?

By water490

Hi everyone My SSIS package does a bulk insert of csv files into a...

Blob Storage automated downloads

By Brandie Tarvin

Dipping my toes into the waters of Azure and of course before I get...

Announcing SQL Server 2025

By Press Release

Comments posted to this topic are about the item Announcing SQL Server 2025

Visit the forum

Question of the Day

Running Steve's Code

Can you run this code in any of your SQL Server 2019 databases without error? 

CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
    
        SELECT Consumer_ID ,
               Trend_Category ,
               Bit_Trace
        FROM    NewWorldDB.dbo.MarketTrend;
    
GO

See possible answers