Learn a little basic graph theory in this article that replaces a GROUP BY clause.
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.
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.
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.
Tagging is important to keep track of resources in the cloud. Today Steve asks how you approach this topic.
Learn about the T-SQL function, AVG(), and see how it is used in a few different cases.
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 makes inserting literal values into a table simple and easy. In this article, Joe Celko explains how to use the VALUES clause.
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Foreword In the second part of this...
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
Now that your CFS has been setup it’s time to get the word out...
Comments posted to this topic are about the item The July Fourth Anniversary
Comments posted to this topic are about the item Independence Day 2022
Hi, I have looked at some examples of Employee > Manager Hierarchy using Recursive...