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

128 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

131 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

127 reads

Blogs

My 2024 in Data: Music

This is my last week of the year working (I guess I come back...

A New Word: Suente

suente– n. the state of being so familiar with someone that you can be...

Side Projects

By Andrew Pruski

Anyone (everyone?) who has ever tried to learn a programming language knows that to...

Read the latest Blogs

Forums

Timeout Error while executing a TSQL statement in Sql server Express Edition

By IT researcher

I am getting the below error when I execute a SQL command in SQL...

Timeout Error while executing a TSQL statement in Sql server Express Edition

By IT researcher

I am getting the below error when I execute a SQL command in SQL...

Sql script replace and rearrange numbers

By diegodeveloper

Hi everyone. I have this table and this information. (left side of the image)...

Visit the forum

Question of the Day

DCL

We have DDL, DML, and DCL. What is DCL used for?

See possible answers