Sites anglophones


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 …

Power BI Histogram Example using DAX

Publié le 16 septembre 2020 sur sqlservercentral.com
 

The post Power BI Histogram Example using DAX appeared first on SQLServerCentral.

When SQL Server Performance Goes Bad: Rogue Indexes

Publié le 16 septembre 2020 sur sqlservercentral.com
 

The post When SQL Server Performance Goes Bad: Rogue Indexes appeared first on SQLServerCentral.

Dynamic Data Unmasking

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

Dynamic data masking is a SQL Server 2016 feature to mask sensitive data at the column level from non-privileged users. Hiding SSNs is a common example in the documentation. However, the documentation also gives the following warning: The pur …

Free Webcast Wednesday: Pushing the Envelope with Indexing for Edge Case Performance

Publié le 15 septembre 2020 sur brentozar.com
 

Most of the time, conventional clustered and non-clustered indexes work just fine – but not all the time. When you really need to push performance, hand-crafted special index types can give you an amazing boost. Join Microsoft Certified Master, B …


Pages :