Stairway to MDX - Level 4: The Order() Function: Beyond Cube Hierarchies
Bill Pearson continues his examination of the versatile Order() function, focusing upon its use in providing dataset sorts that reach beyond dimensional hierarchies
Stairway to MDX - Level 5: Members, and an Introduction to the MDX Members Functions
Bill explains what is meant by a 'Member' and 'Member function' in MDX. A member is an item in a dimension that include the 'measures' which are the values of the attributes that belong to a dimension. 'Measures' are themselves members of a dimension called the “measures” dimension. MDX has a set of functions, known as member functions, each of which allow us to perform operations upon any member of a dimension
Stairway to Server-side Tracing - Level 1 - Overview of Tracing
The first part of our stairway series on SQL Trace examines the overview of this subsystem in SQL Server, it's architecture and the kind of information it returns.
Stairway to Server-side Tracing - Level 1 - Overview of Tracing
The first part of our stairway series on SQL Trace examines the overview of this subsystem in SQL Server, it's architecture and the kind of information it returns.
Stairway to Server-side Tracing - Level 10: Profiler versus Server-Side tracing
Compares and contrasts tracing using Profiler with server-side tracing, illustrating important performance differences so that one can choose the right tool for the task at hand.
Stairway to Server-side Tracing - Level 2: Creating a SQL Trace Using T-SQL (Stairway Series)
This is the second article in our Stairway Series on SQL Tracing. Learn how to build traces in code with T-SQL.
Stairway to Server-side Tracing - Level 2: Creating a SQL Trace Using T-SQL (Stairway Series)
This is the second article in our Stairway Series on SQL Tracing. Learn how to build traces in code with T-SQL.
Stairway to Server-side Tracing - Level 3: Creating a SQL Trace Using SQL Server Profiler
In this third article of our Stairway Series on tracing, Dan Guzman goes into the method of using Profiler to help you create a custom trace of the events that you need to monitor.
Stairway to Server-side Tracing - Level 3: Creating a SQL Trace Using SQL Server Profiler
In this third article of our Stairway Series on tracing, Dan Guzman goes into the method of using Profiler to help you create a custom trace of the events that you need to monitor.
Stairway to Server-side Tracing - Level 4: How to Create and View Default and black box Trace Data
An introduction to the SQL Server default and black box traces targeted at DBAs who are new to these specialized traces. The article shows how to enable and disable the default trace feature and create a black box trace. The captured events are discussed along with how to view current and historical trace data of these traces.
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