Tag Archives: sql server

Brush Up on Your ETL Skills

Posted on February 21, 2018 by way0utwest

Many of us that work with data will find requests and demands to import or export data at some point. Plenty of us have regular processes that perform these actions, and we may regularly troubleshoot or enhance these activities. In … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Brush Up on Your ETL Skills

Template Configuration

Posted on February 16, 2018 by way0utwest

One of my goals this year is to really spend some time learning more about Extended Events (XE). I’m somewhat embarassed that almost a decade after their introduction in SQL Server 2008, I have a fairly rudimentary grasp of the … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Template Configuration

Getting Your SET Options

Posted on February 6, 2018 by way0utwest

Have you ever used @@options? I haven’t typically needed this, but there are times that you might wonder what options are set for a session. You can check in SSMS, look for defaults, etc., but there’s an easy way. SELECT … Continue reading →

Posted in Blog | Tagged , , | 3 Comments

SSMS Line Numbers

Posted on January 16, 2018 by way0utwest

I typically don’t turn on line numbers if SSMS, but while working with someone on a bit of code, they were referencing line numbers in a large script. By default SSMS shows you the line, column, and character at the … Continue reading →

Posted in Blog | Tagged , , | 1 Comment