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,359 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,185 reads
A quick-start to SQL Server StreamInsight and Complex Event Processing with a step-by-step example on stock quotes.
2019-03-26 (first published: 2010-03-17)
8,619 reads
An example of building a StreamInsight input adapter for retrieving Twitter data in real-time.
2019-03-26 (first published: 2010-09-29)
9,064 reads
An introduction to SQL Server StreamInsight and Complex Event Processing with a focus on Business Intelligence.
2019-03-26 (first published: 2010-01-25)
10,971 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,772 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,402 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,119 reads
Step by step guide to building and debugging a SQL Server StreamInsight input adapter.
2009-11-25
7,256 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,051 reads
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Metro Ps. Baru, Jl. Samanhudi No.103 Lt. Dasar No. 101, 102, Gedung, Kecamatan Sawah...
Jl. Jenderal Sudirman No.3, RT.005/RW.005, Babakan, Kec. Tangerang, Kota Tangerang, Banten 15118
Blok A, Jl. Puri Indah Raya 20-22, Kembangan Sel., Kec. Kembangan, Kota Jakarta Barat,...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers