Rethinking SQL Explicit Transactions
This article looks at a simple example of using explicit transactions when modifying data in SQL Server tables.
Learning New Technology Is Challenging
On nights and weekends, I've been playing with Arduino controllers. I have a couple of projects I'm working through (building a robot that can roll around with "eyes" to avoid obstacles). I've also been trying to work with STM32 controllers, because in a lot of ways, they're more powerful than an Arduino. However, I've hit […]
Assembling Your Own Toolbox
Building a toolbox of useful scripts and code is important for any technology professional.
Data Masking: Static vs Dynamic
Learn about how static data masking differs from dynamic masking and learn which one might be best for your organization.
Build Conditional Logic - SQL IF, BEGIN, END, ELSE, ELSEIF
Learn how to build conditional logic when writing SQL code using IF, BEGIN, END, ELSE, and ELSEIF logic.
Improving the Quality of Data Governance: Where to Start?
How do we set about improving the quality of data governance within an organization? What are the priorities? Data Governance is generally considered to mean providing clear roles, responsibilities, policies, principles, and organizational structures that can ensure that data is managed well, in a way that benefits the whole organization. Where do you start?
The Value of Seniority
Some people might seem like they are from the future, but their experience is just shining through.
Delivering Cloud Transformation Excellence: Collaboration, Communication and Governance - Part 6
This article covers tips on establishing, enhancing, and empowering collaboration, communication, and governance on Cloud Transformation projects.
Transaction locking and row versioning guide
In any database, mismanagement of transactions often leads to contention and performance problems in systems that have many users. As the number of users that access the data increases, it becomes important to have applications that use transactions efficiently. This guide describes the locking and row versioning mechanisms the SQL Server Database Engine uses to ensure the physical integrity of each transaction and provides information on how applications can control transactions efficiently.
How to work with Python in Azure Data Studio
Learn how to use Python code with Azure Data Studio to work with SQL Server data.
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers