Why you Should Embed Monitoring Earlier in Your Database DevOps Cycle
The post Why you Should Embed Monitoring Earlier in Your Database DevOps Cycle appeared first on SQLServerCentral.
Incremental Data Loading using Azure Data Factory
Introduction In my last article, Loading data in Azure Synapse Analytics using Azure Data Factory, I discussed the step-by-step process for loading data from an Azure storage account to Azure Synapse SQL through Azure Data Factory (ADF). ADF basic …
I Would Love a “Cost Threshold for Recompile” Setting.
I’m tired of sniffing your parameters. In environments where complex queries can get bad plans due to parameter sniffing, it would help to say that all queries with an estimated cost over X should be recompiled every time they run. For example, i …
Managing Azure Blueprints with PowerShell
The post Managing Azure Blueprints with PowerShell appeared first on SQLServerCentral.
SQL Server Synonyms
We all remember the English lesson we had in grammar school where we learned about synonyms. Just in case you don’t remember, a synonym is a noun that has a similar meaning as other words; just like intelligent has the same meaning as smart. SQL …
SQL Server Suddenly Frozen? You Might Be Snapshotting Too Many Databases.
Snapshot backup tools like Azure Site Recovery and Veeam are great for sysadmins. They let you quickly replicate a virtual machine to somewhere else without knowing too much about the server’s contents. To pull it off, they use the Windows Volume …
Dear Past Me on My First Day as a DBA
I recently started a series on Simple Talk for those who want to be a DBA, and it made me think back to my first weeks on the job and what I would tell me “then”, knowing what I know now. If you are just getting started as a database …
Data Masker with SQL Data Catalog Integration Automates Data Protection Process
The post Data Masker with SQL Data Catalog Integration Automates Data Protection Process appeared first on SQLServerCentral.
Why you should embed monitoring earlier in your Database DevOps cycle
The post Why you should embed monitoring earlier in your Database DevOps cycle appeared first on SQLServerCentral.
Introduction to DAX Financial Functions – Part 1
In this article, I will introduce the DAX financial functions. These 50-plus functions debuted around the time of the July 2020 release of Power BI Desktop. DAX financial functions are largely derived from those found in Excel, and so will seem familia …
Azure Data Factory pipelines: Filling in the gaps
Through the term was not really in the vernacular as it is today, I have been a full or part-time “Data Engineer” my entire career. I have been quite comfortable with Microsoft ETL tools like SSIS for many years, dating back to the DTS days …
Posting SQL Server Notifications to Slack
The post Posting SQL Server Notifications to Slack appeared first on SQLServerCentral.
Unindexed Foreign Keys Can Make Performance Worse.
I know. You, dear reader, saw that title and you came in here because you’re furious. You want foreign key relationships configured in all of your tables to prevent bad data from getting in. But you gotta make sure to index them, too. Let’s …
Conditional Formatting with SSRS
An important part of any report is formatting, to both ensure that it is easily readable but also that key information can be quickly and easily identified. In this article I’ll be covering how you can change the formatting of a cell in a tablix or mat …
How to Create a Table with a Partitioned Clustered Columnstore Index
If you need to create a table and you want it to be partitioned right from the start, AND you want it to have a clustered columnstore index, here’s a creation T-SQL example:CREATE TABLE dbo.MyTableName( Id int IDENTITY(1,1), SalesDate datetime NO …