Jason Brimhall

Implicit Conversion Fail

Implicit conversions are not uncommon in the computing world and can be viewed as kind of a fail-safe for when we don't quite follow decent practices when designing the...

2019-06-18 (first published: )

292 reads

Mass Backup All Sessions

Migrating Extended Event Sessions from one server to another should be a simple task. So simple, one would think there was no need to give it a second thought,...

2019-06-12 (first published: )

174 reads

Note to Self

Not only should you pay respect to those giving of their time, but you should spend a little time to also give back to the community. I will say...

2019-06-11

9 reads

Easy Open Event Log Files

Extended Events is a powerful tool with plenty of ease of use and flexibility. This flexibility allows the DBA to better service the needs of the developers when the...

2019-06-07

216 reads

Puzzles and Daily Trivia

One of my favorite database automations is to send trivia style questions daily. This helps me to mentor and assess other dba talent within an organization without being too...

2019-05-31 (first published: )

211 reads

Event Log File Paths

How does one consistently find the correct path to the Extended Event Log file (XEL file)? This article shows a thorough method to capture that information for all sessions...

2019-05-20

90 reads

Blogs

The Azure-SSIS IR Startup Time

By

If you want to run SSIS packages in Azure Data Factory, you need the...

What is a container anyway?

By

Recently there was a thread on Twitter which established that a lot of IT...

Comparing Execution Plans

By

When you run a query twice, and get dramatically different run times, your first...

Read the latest Blogs

Forums

Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

passing delimited text from stored procedure to show in flat file

By mcfarlandparkway

i have a sample data where i have header row / detailed / total...

Strange update trigger behavior

By andre-119936

Hi. I create a update trigger on a table to audit data changes... the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers