Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 2
In part 2 of this article, learn how you can move incremental changes in a SQL Server table using Azure Data Factory.
New release: SQL Change Automation 4.1
We’ve heard from users that they really care about static data and were missing the feature in the SQL Change Automation SSMS plugin. In v4.1, we’ve added support for the tracking of static data tables to the SSMS extension, alongside existing support in the VS extension. Maya Malakova has written a technical summary showing how to use this feature. Learn more about the release here.
Types of SQL Server Indexes
In this tip we will go through each type of index that is available in SQL Server and give an overview as well as advice on which index types fit each particular use case.
SSAS Error: Duplicate attribute key found when processing
Learn how to resolve a duplicate value error when processing dimensions in SSAS.
Using Aliases in SQL Prompt
Phil Factor explores the role of table aliases, explaining when they are required, and their general purpose otherwise, the need for sensible naming of aliases, and how SQL Prompt handles them.
Using Calendars and Dates in Power BI
You can use a host of time-intelligence functions in DAX to calculate everything from simple year-to-date totals to moving averages and average opening and closing balances. In this article, Andy Brown shows how to model various scenarios with calendars and dates, and how to get around some of the issues you may encounter.
How Do We Prove Expertise?
Today, Grant Fritchey talks about the two paths to expertise for database professionals and why it’s hard to really know if someone is an expert.
SSRS Audit: All reports executed/not-executed during previous 30 days
This article presents a pair of queries and reports that reads the ReportServer.dbo.ExecutionLog table to list all SSRS reports that were executed or not-executed in the past 30 days, how many times they were executed, and who executed them.
A simple use case for Columnstore Indexes in SQL Server
In this article we look at different use cases for columnstore indexes like when performing SQL Server count * queries.
Data Categorization for AdventureWorks using SQL Data Catalog
Josh Smith shows how to use SQL Data Catalog to perform a 'first cut' data classification for one your SQL Server databases, identifying all columns that are likely to hold personal or otherwise sensitive data.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Kebon Sirih. Tlp/wa:0853-7373-7845
Jl. Kebon Sirih No.6A Lantai 1 B, Gambir, Kecamatan Gambir, Kota Jakarta Pusat, Daerah...
Bank BCA Kantor Kas HOS Cokroaminoto TLP/WA 08216977749
Sukaramai, Kec. Pekanbaru Kota, Kota Pekanbaru, Riau 28155
BCA KCU KELAPA GADING Hub.0853•5504•2311
BCA KCU KELAPA GADING HUB.Tlpn.0821•3111•185 Menara Satu Sentra Klp. Gading, Jl. Boulevard Bar. Raya...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers