Announcing SQL Server 2025
Bob Ward announces the next version of SQL Server, now in private preview.
2024-11-22
22,152 reads
Articles
Skipping Columns (& other tricks) Using BCP Format Files (SQL Spackle)
BULK INSERT and BCP are powerful, high performance tools for importing text files. SQL Server MVP Jeff Moden gives us several nifty tips in this introduction to BULK INSERT and BCP Format Files including "Skipping Columns" and the sequestration of bad rows while still loading all the good data.
2024-11-22 (first published: 2014-01-23)
25,674 reads
Transactions
By now, pretty much everyone has heard the stories about the first computers. They were huge, cost a fortune, required incredible amounts of air conditioning, and perhaps more importantly, ran batch jobs submitted on punched cards and magnetic tape. But even before we had these dinosaurs, there were E.A.M (electric accounting machine) units.
2024-11-22
Should That Be One Update Statement or Multiple?
Let’s say we have a couple of update statements we need to run every 15 minutes in the Stack Overflow database, and we’ve built indexes to support them:
2024-11-20
Microsoft SQL announcements at PASS Data Community Summit 2024
Read a summary of the data platform announcements from Microsoft at the PASS Data Community Summit 2024 last week.
2024-11-18
1,034 reads
Explore Pandas in Python to Analyze and Manipulate Tabular Data
Learn how to use Pandas an open-source library for analyzing and manipulating tabular data in Python along with several examples.
2024-11-18
The Right and Wrong of T-SQL DML TRIGGERs (SQL Spackle)
Triggers in T-SQL have many uses. There are right and wrong ways to write triggers. To learn the difference, read on...
2024-11-15 (first published: 2015-03-17)
9,049 reads
Making Temporal Databases Work, Part 3: Saving Data
In part three of this series, Boris Novikov looks at how data is saved and modified in a temporal database and what kind of integrity constraints are needed for temporal tables. If you haven’t seen parts one and two, don’t worry! Links are provided in the article, and we recommend checking them out first.
2024-11-15
Ingesting Data From REST API endpoints: Data Engineering with Fabric
In this article on Fabric we will examine how to get data from a REST API.
2024-11-13
3,662 reads
Relationships with Microsoft Fabric GraphQL API
Learn how to join tables together when using the GraphQL API with Microsoft Fabric in this step-by-step article.
2024-11-13
Blogs
Do This Before You Contact Your SQL Server Consultant
Say you need outside help. You’ve exhausted all the things that you could do...
Microsoft MVP 2026: Ten Years on the Data Platform
I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...
Building AgentDBA’s Slack Escalation
By Arun Sirpal
Until now, a CRITICAL finding did the right internal routing, but the last mile...
Forums
Developer edition cannot be connected from other computers
I installed a new SQL server 2025 Enterprise developer edition for our development environment....
How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning
Comments posted to this topic are about the item How Clustering can be Used...
Moving the Error Log
Comments posted to this topic are about the item Moving the Error Log
Question of the Day
Moving the Error Log
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers