SQL RNNR

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

183 reads

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-05-31

11 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: )

171 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

88 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

Blogs

SQL Server Containers Are Boring

By

Not really, but sort of. The beauty of containers, at least in a dev/test...

Public Role Permissions – Back to Basics

By

If you are being serious in your role, then the amount of times you...

It’s interesting how an OR short circuits.

By

I recently did a post on the case expression short circuting and received a...

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

Always on AG and SQL Upgrade

By Admingod

Looking to upgrade from SQL Server 2014 to SQL 2016 which has always on...

Migration from server to server

By rrizzojr

I recently migrated from Windows 2003 SBS running SQL 2005 Express along with SSMS...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers