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 …
Power BI Histogram Example using DAX
The post Power BI Histogram Example using DAX appeared first on SQLServerCentral.
When SQL Server Performance Goes Bad: Rogue Indexes
The post When SQL Server Performance Goes Bad: Rogue Indexes appeared first on SQLServerCentral.
Dynamic Data Unmasking
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
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 …