Join BI Architect Bill Pearson as he continues his overview of Attribute Discretization, within his extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution. In this article, we begin a hands-on overview of the use of the Automatic discretization method.
This article describes different ways of improving the performance of SQL Server queries, with a focus on index optimization.
When writing SQL, picking good tables aliases can greatly enhance the readability of your code
This module, part 2 of the online training course "Becoming a Profiler Master", discusses the inner workings of Profiler.
How do you protect and monitor your databases? Auditing is one way, but Steve Jones thinks this subsystem in SQL Server needs to mature.
This Friday Steve Jones has a poll about developers. Help compile a good list of common mistakes made in SQL Server.
This Friday Steve Jones has a poll about developers. Help compile a good list of common mistakes made in SQL Server.
This Friday Steve Jones has a poll about developers. Help compile a good list of common mistakes made in SQL Server.
Now, Internet-hosted distributed applications with connectivity to internal applications—often referred as Software plus Services (S+S)—are gaining popularity. Organizations are leveraging datacenters hosted by third parties to alleviate concerns about hardware, software, reliability, and scalability. These are just some of the new architecture trends that help you build interoperable applications that scale, reduce capital expenditure, and improve reliability. Cloud computing offers many of these benefits.
To scale your SQL Server properly means to make it bigger and better. But what is the best method for 2008?
I am excited to host T-SQL Tuesday for the first time. I want to...
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Comments posted to this topic are about the item Measuring Productivity
Comments posted to this topic are about the item Importing Excel files into SQL...
Comments posted to this topic are about the item Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers