SharePoint Disaster Recovery Plan
Hot standby disaster recovery process where SharePoint farm will become available in minutes
SQL Server Machine Learning Services – Part 6: Merging Data Frames in Python
In the final article in this series, Robert Sheldon demonstrates combining data sources with multiple formats into one Python data frame.
Stairway to U-SQL Level 20: Querying External Data with U-SQL
Did you know you can query SQL Server data with U-SQL? It's true! Find out how in this latest stairway step.
SET IMPLICIT_TRANSACTIONS ON Is One Hell of a Bad Idea
By default, when you run a query in SQL Server, your delete/update/insert (DUI) is finished as soon as your query finishes. That’s because the default behavior of SQL Server is IMPLICIT_TRANSACTIONS OFF – meaning, SQL Server doesn’t hold your queries open waiting for a COMMIT or ROLLBACK.
AI in Industries
It is important to showcase how Artificial Intelligence is being used in various fields and industries with some facts
Changing Data Types on Large Tables: The INT to BIGINT Conundrum
Changing a data type seems like a simple task unless the table is quite large and downtime must be kept to a minimum. Danny Kruge walks you through the process he created to change an INT to a BIGINT in a large table.
Intervals Part 1 - Definitions and Terms
Learn the basic terms and definitions for intervals in SQL Server.
Troublesome Names
Building a name-and-address database sounds a disarmingly simple task, but if your name happens to be D'Arcy Join, then you probably know, from painful experience, that most programmers don't get it right.
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