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.
Azure Synapse Link for SQL: From production to a data warehouse in a few clicks
Microsoft announced Azure Synapse Link for SQL. In this article, MVP Dennes Torres explains the new feature.
Why a leading bank with over 1,400 databases chose to think again about Redgate SQL Monitor
Headquartered in Louisville, Kentucky, Republic Bank is one of the most innovative and forward-looking banks in the US, with 42 full-service banking centers across five states and assets of $6.2 billion. Find out why they chose Redgate SQL Monitor.
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.
The Useful Cloud Tags
Tagging is important to keep track of resources in the cloud. Today Steve asks how you approach this topic.
Blogs
SQL Homework – July 2022 – Update your resume.
Resumes have been on my mind a lot recently. I’ve been thinking that I...
A Blogging Break
By Steve Jones
Outside of coping tips, I’m gonna take a break from blogging. I’ve been aiming...
Extended Events for Anything But Query Tuning: Unique Constraint Violations
Most of the time when I talk about or demo Extended Events, I spend...
Forums
Establishing a Connection to PostgreSQL with GoLang
Comments posted to this topic are about the item Establishing a Connection to PostgreSQL...
Power BI Pro License usage based on Operations performed by Users
hi Friends, Requirement: Create a query or Power BI report/dashboard that displays users, their...
Extracting Linked Server details from Data Sources of SSRS Paginated Reports
hi Friends, Here is the example Scenario: An SSRS Paginated Report has 2 data...
Ask SSC