Stairway to Database DevOps Level 1: Setup a Local Git Repo with Azure DevOps
In this first level of the Stairway to DevOps, you will learn how to get version control set up on your local machine and connect to an Azure DevOps repository.
Community at PASS Summit
Last Saturday, September 23, was the first day of Fall. Regardless of how much has happened and changed over the last three and a half years, time keeps marching forward. And yet, there's exciting familiarity every time I see November approaching because I know something special is about to happen for those of us in […]
A Staffing Disaster
An Azure datacenter had a failure after an incident, partially because they didn't have enough people. Steve notes that staffing is a challenge in many ways.
Sending Multiple Attachments in Email from Azure Data Factory Pipeline
This article shows how you can have your Azure Data Factory (ADF) pipeline send an email using a Logic App.
Post-migration Validation and Optimization Guide
SQL Server post migration step is very crucial for reconciling any data accuracy and completeness, as well as uncover performance issues with the workload.
Profiler and Server Side Traces
Profiler is a GUI based tool that runs a SQL Server trace to capture the metrics listed above as well additional data. This data can then be used to determine where your SQL Server performance issues are related to your TSQL code. Running a trace without using Profiler is known as a Server Side Trace. You can create and start the trace using TSQL commands instead of having to use the GUI.
How Much Code Can You Review?
Code reviews are a part of many developers' lives, but is there a limit to what you can do effectively?
Running a Service
The way we view our jobs might change how we do them. Steve has some advice on how to think about the work you do.
Stairway to DAX and Power BI Level 26: Time Intelligence – Dates Functions: The DAX “Total to Date” Functions
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three similar DAX Time Intelligence functions related to Date: TOTALMTD(), TOTALQTD(), and TOTALMYD(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.
Blogs
A New Word: Ghough
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
T-SQL Tuesday: Encryption and Data Protection
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Parameterize your Databricks notebooks with widgets
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
Forums
Need help on query within 2 column, generate another column
Hi, This is my table and data CREATE TABLE [dbo].[rpt_AR_StatementOfAcct_100]( [Id] [int] IDENTITY(1,1) NOT...
SELECT blocking DML and DDL
Hi All. I am seeing a scenario where SELECT is blocking a TRUNCATE statement...
query filling up tempdb
Hi All, Need some help in tune a function which is reading TB's of...
Ask SSC