Stairway to AlwaysOn Level 2: Storage 101
In this new level of the stairway, we examine the storage knowledge you need for an AlwaysOn configuration.
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.
The Growth of IQP
Steve talks about some of the Intelligent Query Processing improvements in SQL Server 2022.
Convert Problematic Data in SQL Server
In this article, we look at various ways to convert problematic data in SQL Server by using TRY_CAST, TRY_CONVERT, and TRY_PARSE.
Join the EAP: Next-gen database cloning
Redgate’s database cloning technology is getting an upgrade: Multi-RDBMS, instance-level clones, and support for containerized workflows. Automate DevOps test data for fast quality releases across your software organization. Learn more and gain first access by joining the early access program!
Blogs
Daily Coping 6 Oct 2022
By Steve Jones
Today’s coping tip is to remind yourself that you are enough just as you...
What you can do is based on more than your direct permissions.
What you have access to is not just what you have direct permissions to....
Registered for the Data Community Summit
By Steve Jones
I was reminded this week that I needed to get registered for the Data...
Forums
I must be loosing my mind. Odd data issue
I have a guest table on two servers. Call them prod1 and prod2. The...
How to insert data from same set of tables selecting different id from the same
I am trying to insert same set of records with student id 1234 (All...
Increment max value by over a complete dataset
In a weird situation where I have limited say in the ultimate solution. Switching...
Ask SSC