Solving the Running Total and Ordinal Rank Problems (Rewritten)
Revisiting his very popular article on the running total and ordinal rank problems, MVP Jeff Moden brings us a detailed analysis of how you might want to implement a solution in T-SQL.
Stairway to T-SQL DML Level 4: The Mathematics of SQL: Part 1
A relational database contains tables that relate to each other by key values. When querying data from these related tables you may choose to select data from a single table or many tables. If you select data from many tables, you normally join those tables together using specified join criteria. The concepts of selecting data from tables and joining tables together is all about managing and manipulating sets of data. In Level 4 of this Stairway we will explore the concepts of set theory and mathematical operators to join, merge, and return data from multiple SQL Server tables.
Monitoring your servers and databases with SCOM and SQL Monitor
SCOM is good at monitoring the status of your servers. SQL Monitor give you a detailed view of your SQL Server instances, and databases, right across your network, however they are hosted. By using tools appropriately, for the tasks they do well, you benefit from a simpler and more comprehensive overall strategy.
SQL Server Subquery in Select Statement with Where Clause
In this part of the temporary data store tip series we look at using subqueries to select data as well as how to use for inserts, updates and deletes.
DBA Walkthrough – Adding space on IBM AIX Power Machines
Learn how to manage storage/filesystems on IBM AIX - Power machines. Learn from this demo of expanding a filesytem on AIX so that your DBA's get a high level overview of how AIX storage management works.
No State Based Deployments
Today Steve Jones talks about deploying your database changes, and how you can't ever really depend on a state based approach.
Bringing certainty to the uncertainty of Brexit
These are tough times for businesses in the EU. Is the UK going to be in or out? Quite simply, businesses are finding it difficult to plan anything when everything is up in the air, and no one can confirm what will happen next. All of which is making many businesses wary of making a decision to invest in their IT infrastructure. Enter DevOps.
Introduction to the Cosmos DB Emulator
Cosmos DB delivers a wide range of advantages over traditional SQL and NoSQL-based data stores, including support for multiple consistency levels, latency and throughput guarantees, policy-based geo-fencing, automatic scaling, and multi-master replication model. However, it is a significant departure from the traditional database management and development approach that most database administrators are familiar with. Discover the offerings that you can use at no cost to gain hands-on experience with Cosmos DB.
Creating Aliases for Docker Commands in Linux
In this article you will learn how to create and use alias commands for Docker, to make Docker's command line experience easier and more productive.
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers