The Covid-19 pandemic has provided examples of how uncertain data can eventually be presented to the public as certainty. How, as data people, should we represent uncertainty in our data?

An Introduction to PowerShell for a DBA

by Alex Chamchourine

SQLServerCentral.com

PowerShell

An introduction to PowerShell that covers basics alone with some more advanced features. It will walk you through from the very beginning to the writing of a few useful scripts.

Are You Ready To Change Your Work Environment?

by Steve Jones

SQLServerCentral

Career Growth

With many of us working from home, Steve wonders if you want to change anything.

Export SQL Server Tables to Excel

by Additional Articles

MSSQLTips.com

Sometimes there is a need to export data for a lot of different SQL Server tables into an Excel file. In this tip we look at how we can quickly export several tables into one Excel workbook where each table is stored in a different worksheet.

A Security Regression

by Steve Jones

SQLServerCentral

Security

Marriott has had another security breach. Does this mean they aren't taking security seriously? Steve has a few thoughts.

DAX for SQL Folks: Part II - Translating SQL Queries to DAX Queries

by Frank A. Banin

SQLServerCentral

Introduction In response to my approach in the popular MDX Guide for SQL Folks series, I am using SQL as a good frame of reference for starting or developing a new approach for improving your Data Analysis Expression(DAX) language learning experience. This is useful for developers starting to learn the DAX language to more advanced developers who […]

Free Training Week: How I Use the First Responder Kit – sp_Blitz

by Additional Articles

SQLServerCentral

When you’re first approaching a SQL Server, start with sp_Blitz. We’ll cover my favorite parameters and what I look for in the results, and then start building our notes in Markdown for our eventual health check recommendations for the rest of our team.