Speaking at SQL Saturday #49 Orlando
To all who live within a drive (or even a flight) to Orlando I really recommend you attend SQL Saturday Orlando next Saturday October...
2010-10-07
713 reads
Devin Knight
Knight's Microsoft Business Intelligence 24-Hour Trainer released
Today the much awaited Knight's Microsoft Business Intelligence 24-Hour Trainer book was release. In this book you will learn about...
2010-09-28
975 reads
SSAS - Defining Attribute Relationships in 2005 and 2008
Attribute relationships inside of Analysis Services are a critical piece to the design of your dimensions.The benefits of creating attribute...
2010-09-20
1,600 reads
MDX Aggregate Named Set Than Others
In this quick post I wanted to provide some code that's been useful to me recently. This MDX statement creates...
2010-09-17
2,478 reads
MDX - Calculating the Percent of a Named Set
Getting the percent of something in MDX seems like a pretty easy task but can be complicated when extra logic...
2010-09-08
1,139 reads
Creating a PerformancePoint 2010 Data Source
In a previous post I wrote about getting started with PerformancePoint 2010.In that post you learned about what PerformancePoint is...
2010-09-01
905 reads
SQL Lunch #26 Analysis Services Security
Today at 12:30 EST I will be presenting for SQL Lunch on the topic of Analysis Services Security. Make sure to be...
2010-08-05
695 reads
Getting Started With PerformancePoint 2010
PerformancePoint is a great tool for monitoring and analyzing the performance of your business at a high level but also...
2010-08-03
1,255 reads
SSIS - Event Handler Performance
Event handlers are a great tool for managing errors and other events that occur during the execution of a package...
2010-07-20
1,141 reads
SSIS - Event Handler Performance
Event handlers are a great tool for managing errors and other events that occur during the execution of a package...
2010-07-19
3,969 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
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