Sites anglophones


Why you Should Embed Monitoring Earlier in Your Database DevOps Cycle

Publié le 24 septembre 2020 sur sqlservercentral.com
 

The post Why you Should Embed Monitoring Earlier in Your Database DevOps Cycle appeared first on SQLServerCentral.

Incremental Data Loading using Azure Data Factory

Publié le 24 septembre 2020 sur sqlservercentral.com
 

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.

Publié le 23 septembre 2020 sur brentozar.com
 

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

Publié le 23 septembre 2020 sur sqlservercentral.com
 

The post Managing Azure Blueprints with PowerShell appeared first on SQLServerCentral.

SQL Server Synonyms

Publié le 22 septembre 2020 sur simple-talk.com
 

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.

Publié le 22 septembre 2020 sur brentozar.com
 

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

Publié le 22 septembre 2020 sur sqlservercentral.com
 

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

Publié le 22 septembre 2020 sur sqlservercentral.com
 

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

Publié le 21 septembre 2020 sur sqlservercentral.com
 

The post Why you should embed monitoring earlier in your Database DevOps cycle appeared first on SQLServerCentral.

Introduction to DAX Financial Functions – Part 1

Publié le 19 septembre 2020 sur simple-talk.com
 

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

Publié le 18 septembre 2020 sur simple-talk.com
 

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

Publié le 18 septembre 2020 sur sqlservercentral.com
 

The post Posting SQL Server Notifications to Slack appeared first on SQLServerCentral.

Unindexed Foreign Keys Can Make Performance Worse.

Publié le 17 septembre 2020 sur brentozar.com
 

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

Publié le 17 septembre 2020 sur sqlservercentral.com
 

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

Publié le 16 septembre 2020 sur brentozar.com
 

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 …


Pages :