Migrating an on premise SQL Server Database to Azure
For this article I want to show you how to import a BACPAC file to create a new Azure SQL Database which is Microsoft’s Platform as a Service(PaaS) offering.
Database Version Control
By placing under source control everything we need to describe any version of a database, we make it much easier to achieve consistent database builds and releases, to find out who made which changes and why, and to access all database support materials. Matthew Skelton explains how to make sure your version control system fully supports all phases of the database lifecycle, from governance, development, delivery and through to operations.
Stairway to T-SQL: Beyond The Basics Level 6: Using the CASE Expression and IIF Function
There are times where you need to write a single T-SQL statement that is able to return different T-SQL expressions based on the evaluation of another expression. When you need this kind of functionality you can use the CASE expression or IIF function to meet this requirement. In this Stairway level Gregory Larsen reviews the CASE and IIF syntax and showing you examples of how the CASE expression and IIF function.
Getting Started Tuning Performance in Azure SQL Database
Tim Radney talks about the initial differences he has encountered while mastering the art of performance tuning Azure SQL Database.
What Does the Near-Future of PowerShell & SQL Server Look Like? An Interview with Ken Van Hyning
Ken Van Hyning is the Engineering Manager for the SQL Server tools, including SQLPS.
Row Level Security with SQL Server 2016
Have you ever wanted an easier way to provide security at the record level? If so, you can now easily do this with the Row Level Security feature that is being introduced with SQL Server 2016. Greg Larsen shows you how easy it is to use this new feature as a way to provide user access to a specific set of records.
Exporting Azure Data Factory (ADF) into TFS Source Control
Have you created a Data Factory in Azure and are wondering how to get it into TFS and source control? This article will show you how.
SQL Server System Functions: The Basics
Every SQL Server Database programmer needs to be familiar with the System Functions. These range from the sublime (such as @@rowcount or @@identity) to the ridiculous (IsNumeric()) Robert Sheldon provides an overview of the most commonly used of them.
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Alamat BCA KCU Pantai Indah Kapuk Tlp:0817825533
Hub Via Wa:62817825533 Alamat: Jl. Pantai Indah Kapuk Utara I Blok F, RT.6/RW.2, Kamal...
Alamat Kantor BCA KCU Taman Duta Mas Tlp:0817825533
Hub Via Wa:62817825533 Alamat: ABC dan 11 H, Jl. Pangeran Tubagus Angke No.10, RT.14/RW.11,...
Alamat Kantor BCA KCU Tanjung Priok Tlp:0817825533
Hub Via Wa:62817825533 Alamat: Jl. Enggano No.22-23, RT.8/RW.16, Tj. Priok, Kec. Tj. Priok, Jkt...
Question of the Day
Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers