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!
How Important is Software?
The user experience from our software is important. Maybe more than many developers realize.
Cloud Databases
There are advantages of cloud databases when your workload requirements grow. Steve thinks it's useful to learn a bit about the options out there.
T-SQL Language Changes in SQL Server 2022 Part 2
Learn about more of the T-SQL language changes in SQL Server 2022 to LTRIM, RTRIM, TRIM, GET_BIT, SET_BIT, LEFT_SHIFT, RIGHT_SHIFT, BIT_COUNT and more.
How to Build a Data Science Time Series Model with SQL Server
https://www.mssqltips.com/sqlservertip/7385/data-science-time-series-model-building-framework-sql-server/
The Redgate 100: Top Influencers List
We're recognizing the individuals in the database community for their work, online influence and thought leadership in our inaugural list of influencers: The Redgate 100.
Stairway to SQL Server Security Level 4: Permissions
A permission gives a principal access to an object to perform certain actions on or with the object. SQL Server has a mind-numbingly huge number of permissions that you can grant to a principal, and you can even deny or revoke those permissions. This sounds a bit complicated, but by the end of this stairway level you’ll understand how SQL Server permissions work and how you can exert very granular control over object creation, data access, and other types of actions on database and server objects.
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server
Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers