SQL RNNR

Life Support 2008 – Audit Logons

Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep work involves auditing your server for any users that may still be using the instance.
Related...

2019-08-09 (first published: )

219 reads

Finding Data Gaps

Quality data is a goal we all strive to attain. Nobody wants to have bad data. Yet, despite our best efforts, the problem of bad data has its way...

2019-08-05 (first published: )

429 reads

Event Files on Linux

For the most part, things work the way you might expect them to work in windows - except it is on Linux. Sure some things are different, but SQL...

2019-07-29 (first published: )

147 reads

Is That Database in Use?

This article demonstrates how to use Extended Events to determine if a database is being used by someone or something.
Related Posts:

Finding Deprecated Uses in SQL Server November 7, 2016...

2019-07-22 (first published: )

861 reads

Join a List of Values

There are multiple ways of retrieving data from a table when you have a list of values. This article explores the use of the table value constructor.
Related Posts:

Correlate Trace...

2019-07-18 (first published: )

491 reads

Database File Changes

Data professionals around the globe are frequently finding themselves occupied with figuring out why and when a file (data or log) for a database has changed in size. Whether...

2019-07-10 (first published: )

239 reads

Job History – Back to Basics

An important part of any DBAs job is to ensure database related jobs are running prim and proper. Sometimes that just doesn't happen. When jobs are being overlooked, it...

2019-07-04 (first published: )

434 reads

Blogs

Invest in Yourself Stop Making Excuses

By

Bob Pusateri (B|T) tweeted a quote image that really struck a chord with me...

Every Execution Plan Is An Estimated Plan

By

I consider myself to be the most responsible for making such a huge deal...

SQLSaturday Orlando Notes – Kahoot

By

The last two years we did Family Feud as part of our end of...

Read the latest Blogs

Forums

SQL Management studio 2014 express edition

By bokswager

Guys, Can I use SSMS 2014 Express edition to connect to a lower and...

unable access sql provider in powershell without running an invoke-sqlcmd first

By Steve T

I encountered a weird issue and hope that somebody may have a fix for...

Function to pad Bigint with leading zeros or other single characters

By Shane Clarke

Comments posted to this topic are about the item Function to pad Bigint with...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers