How Many Databases Can You Name?
There is a huge number of databases available. How many could you name? Create our list and then compare to our list of well over 100 databases!
Removing Extended Properties
With the new labeling and classificiation options in SQL Server, there might be a need to remove these labels before deploying the database.
Research on the Changing Workplace
The workplace is certainly changing with the COVID-19 pandemic. Steve shares a few learnings from Microsoft's work from home experiment.
Install SQL Server Integration Services in Visual Studio 2019
Learn the step by step process to install SQL Server 2019 Integration Services in Visual Studio as well as the history for the tool.
Tracking use of Deprecated SQL Server Features
Phil Factor explains how to use SQL Prompt, or SQL Change Automation, to detect use of deprecated SQL Server syntax, during development, and Dynamic Management Views and Extended Events to track its use on working databases.
Honorifics in the 21st century
As data professionals, we should understand how language and forms of address can impact our data model. In the 21st century, we should also learn how to communicate with colleagues in a respectful and professional manner.
Getting Started with Azure Blueprints
Learn about Azure Blueprints, available in the Azure portal, which is a new method of deploying Azure Resources through ARM templates.
The Old Way or the New Way
Learning to adapt the way we work is important for advancing our career, but this can be harder than we expect.
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Pantai Indah Kapuk Tlpn/Wa 0853.7373.7551
Jl. Pantai Indah Selatan Blok DF No.1 & 2, Kapuk Muara, Kecamatan Penjaringan, Jkt...
BCA KCP Tebet Barat 2 Telpon/WA:08137887595
BCA KCP Tebet Barat 2 Telpon/WA:08137887595.Jl. Tebet Raya No.25 B Blok CI, Tebet Tim.,...
BCA KCP Puri Deltamas Tlpn/Wa 0853.7373.7551
Komplek Ruko Puri Deltamas Blok J. 5, Jl. Bandengan Sel. No.43, Daerah Khusus Ibukota...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers