Using Graph Theory To Group Records
Learn a little basic graph theory in this article that replaces a GROUP BY clause.
Accelerating Digital Transformation: The role of DevOps and Data
SQL Server Central Editor, Steve Jones is joined by a panel of industry experts from around the globe to discuss their experiences with digital transformation, and the impact it had on themselves, their teams and the wider organization.
How to Import and Export Connections from SQL Server Management Studio
In this article we look at how to import and export connection information for servers in SQL Server Management Studio for backup and to move to another installation of SSMS.
Stairway to Advanced T-SQL Level 7: Ordering Your Data Using Ranking Functions
In SQL Server there are 4 different ranking functions: RANK, DENSE_RANK, NTILE, and ROW_NUMBER. These ranking functions were introduced in SQL Server 2005. In this stairway level I will be reviewing each of these different ranking functions, and will show you how to use them by providing a few examples.
The Useful Cloud Tags
Tagging is important to keep track of resources in the cloud. Today Steve asks how you approach this topic.
Working with T-SQL function AVG ()
Learn about the T-SQL function, AVG(), and see how it is used in a few different cases.
Implementing ETL Logging on Lakehouse using Delta Lake's Time Travel capability
In this article I demonstrate how to use Delta Lake's time travel functionality for ETL logging along with steps to take to implement.
The VALUES clause or building tables out of nothing
The VALUES clause makes inserting literal values into a table simple and easy. In this article, Joe Celko explains how to use the VALUES clause.
Blogs
SQLServerCarpenter Tools
Over the past couple of years, I’ve developed several tools that I’ve been using...
usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON
/* Author:Brahmanand Shukla (SQLServerCarpenter.com) Date:27-May-2022 Purpose:To get all the stored procedures and triggers missing the use of...
A New MVP Led Training Initiative – Cloud Formations
By Arun Sirpal
Hello Readers – I wanted to make sure those who follow my blog have...
Forums
SQL Server 2014 Question
So I have inherited an older SQL 2014 Server and have been working on...
Removing UNION and getting the same result
Hi, I need to update my sql script and remove the UNION but get...
SQL Server 2019 HA
Looking for a HA solution for SQL server for our branch offices. Current setup...
Ask SSC