This stairway series was started in 2015. As such, the focus was on SQL Server 2012 and SQL Server 2014 only. When SQL Server 2016 was released, with lots of improvements in the columnstore technology, I decided to finish the planned levels with the original focus on SQL Server 2012 and 2014, and add one extra level with a brief overview of the improvements available in SQL Server 2016.
In this article we look at how to automate a SQL Server database restore using a PowerShell script.
Recently a customer asked me for help with setting up a test of an Azure SQL Database in the single database tier with Geo-Replication to work with Transparent Data Encryption (TDE) with a customer-managed key, also known as Bring Your Own Key (BYOK). It is very simple to do it when you use service-managed keys, […]
In this article we look at the incremental refresh feature when working with Power BI data sources and how to implement for your reports.
Today Steve looks at one possible future of offices, which might be something we own.
This article shows a basic Azure Data Factory pipeline to load data into Azure Synapse.
In this article, Diogo Souza explains GitFlow, a branching model for Git. He demonstrates how to work with GitFlow to create and deploy a feature and a hotfix to GitHub.
In this article we look at the incremental refresh feature when working with Power BI data sources and how to implement for your reports.
There are plenty of experts that look to teach you about query tuning and the internals of query execution in SQL Server.
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Jl. Daan Mogot No.95, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah Khusus...
BCA KCP Pandanaran Telpon/wa:0821°8168°291.No. 101 A, Jl. Pandanaran, Mugassari, Kec. Semarang Sel., Kota Semarang,...
FC8R+CHV, Jl. Syeikh Baing Yusuf, Nagri Kaler, Kec. Purwakarta, Kabupaten Purwakarta, Jawa Barat 41119
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