Recognised expert in SQL Server database administration and patching, PowerShell automation and operational validation, SQL Server Reporting Services and SQL Server Master Data Services, with 10 years of experience.

I focus on building elegant and scalable solutions to tough operational problems, and engage daily with SQL Server and PowerShell communities.

ERRORLOG records max out at 2049 characters

by Cody-Konior

Cody Konior

Stupid question… what's the schema of a table with sys.sp_readerrorlog output? Well you might be surprised if you're used to...

2017-03-02

123 reads

I like you, but I don't like your best practice (power plans)!

by Cody-Konior

Cody Konior

I saw this tweet from the always awesome @DBArgenis and @sqldbawithbeard and couldn't help but feel a bead of sweat...

2016-10-20

129 reads

Recipe for an awesome (free) SQL Server workstation

by Cody-Konior

Cody Konior

Windows 10. Where we're going we don't need legacy software, but if you do, then download PowerShell 5.0 instead.
SQL Server...

2016-08-16

123 reads

Blogs

Daily Coping 24 Sept 2021

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Using environment variable files for SQL Server in containers

By Andrew Pruski

There are a whole bunch of environment variables that can be used to configure...

How to Design Backups in SQL Server?

The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...

Read the latest Blogs

Forums

Volunteer For Something

By Grant Fritchey

Comments posted to this topic are about the item Volunteer For Something

Linked Server location?

I have inherited a SQL Server that makes a call to a Linked Server...

Merge issue

I have a merge stored procedure that may be conflicting with the structure of...

Visit the forum

Question of the Day

The OPENJSON return schema

See possible answers