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

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

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

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

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

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

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

435 reads

Blogs

Power Platform Quick Tips – Episode 03: Documenting Power Automate Flow Logic

By

Welcome back to my series on Power Platform quick tips! In this episode you...

State of Database DevOps Survey

By

Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe...

HP is the 2019 Laptop Winner

By

This is for me, not necessarily for you, but I decided to go with...

Read the latest Blogs

Forums

Tracking History in Fact Table

By Niggles

Hi, I was hoping somebody would be able to offer advice in relation to...

How to get information about an AG group using powershell

By vsamantha35

Hi Experts, Does anyone has a powershell script which displays below information: for a...

Find out who stopped my SQL Services

By vsamantha35

Hi Experts, Is there a way to find out which windows user has stopped...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers