I’m presenting at the PASS Business Analytics Conference
I am fortunate enough to have been selected to give a presentation at the PASS Business Analytics Conference in San Jose, CA...
2013-12-19
656 reads
Blog Posts
MDX Implementing Logical OR On Members of Different Hierarchies
Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli
In MDX, when two or more members...
2013-12-19 (first published: 2013-12-15)
1,584 reads
Nominated for the Tribal Awards
I’ve been notified I am a finalist for the category Best New Voice at the Tribal Awards. These awards are...
2013-12-19
1,052 reads
Nominated for the Tribal Awards
I’ve been notified I am a finalist for the category Best New Voice at the Tribal Awards. These awards are...
2013-12-19
922 reads
To All Recruiters - Canned Emails Kill Kittens: Day 9
Small disclaimer
I'm going to file this one under rant. Let me first say that there are some wonderful recruiting agencies...
2013-12-19
649 reads
Transactions: Rolling back part of a transaction.
In my previous post I mentioned the fact that the ROLLBACK command rolls back the entire transaction all the way...
2013-12-19
683 reads
Data Architecture VC hosts Nigel Sammy: TSQL Tips and Tricks
Please join the Data Architecture Virtual Chapter as they host SQL Server MVP Nigel Sammy his take for T-SQL Tips...
2013-12-18
606 reads
Increasing database unit tests connection timeout period in VS 2012
Have your ever had a timeout error in a visual studio 2012 unit test like below?
How to get around this...
2013-12-18
1,024 reads
Parameterization – A quick note on a CSS SQL article
I just finished reading an excellent CSS article, How Simple Parameterization works, which is well written and well worth a...
2013-12-18
550 reads
Popular DBCC's And Our Third Winner Of The Month!: Day 8
Winner Announcement!
The third winner of this month is Annapu Reddy Gayathri! I've seen a nice increase of participants so far. I...
2013-12-18
438 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