ERRORLOG records max out at 2049 characters

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

How many Backups is Too Many?

Does this title seem strange?  Of course we know this is the true answer:

https://cdn.meme.am/cache/instances/folder633/58097633.jpg
But here is a story of a...

Identify SQL Accounts Without Password Policy Enforced

When ‘Enforce Password Policy’ for SQL Server logins is turned off, you can make your password anything you want! Hooray!...

Implicit Time Conversions – #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Loading to Azure from On-Prem SSIS

In my introduction to the topic of using SSIS in the cloud, I noted that SSIS is not currently available...

Power BI Hands-On Workshops in April, 2017

During the month of April, I will be delivering three full-day Power BI hands-On workshops.  Each of these events will...

Random Blog Post Challenge

OK, for no particular reason at all or maybe because I had too much food at lunch or just because...

ScriptDom parsing and NoViableAltExceptions

If you have ever tried to debug a program that used the TSql Script Dom to parse some T-SQL you will know that the process is extremely slow and...

ScriptDom parsing and NoViableAltExceptions

If you have ever tried to debug a program that used the TSql Script Dom to parse some T-SQL you...

ScriptDom parsing and NoViableAltExceptions

If you have ever tried to debug a program that used the TSql Script Dom to parse some T-SQL you...