There are many reasons you should monitor your databases, including avoiding performance problems or running out of disk space. Ideally, you want a scalable monitoring solution where you can monitor all your SQL databases in one single place. This article will describe two options that are available: Azure SQL Analytics and Azure SQL Insights. Both […]
2022-03-18
10,265 reads
Introduction Azure Purview is Microsoft’s unified data governance service that helps you discover and get insight into your available data. It replaces Azure Data Catalog and is now based on Apache Atlas, one of the leading open-source data governance and metadata frameworks. Apache Atlas was created by Hortonworks and big names within finance, pharma, etc. […]
2021-02-18
5,160 reads
Learn how to use Biml to create a SSIS-package with a Script component that can read from Twitter.
2019-01-01 (first published: 2016-04-28)
3,769 reads
Tired of building tons of similar SSIS packages for importing files into your data warehouse? Learn how to autogenerate them using Biml.
2018-02-16 (first published: 2015-09-10)
7,374 reads
One of the new features of SQL Server 2016 is the ability to time travel in your databases and visit a specific table at a specific point of time in history. You can also use this feature to audit changes or “undo” whole data warehouse updates.
2017-09-04 (first published: 2016-10-18)
10,039 reads
Step by step guide to building and debugging a SQL Server StreamInsight input adapter.
2009-11-25
7,245 reads
A step by step example of how to add pre-calculated closing balances through T-SQL and semi-additive measures from Johan Åhlén.
2009-11-04
7,046 reads
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Is there a good syllabus for reading these two together? (Yes, it's called the...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers