Counting Events
After reading through the articles about the pair_matching target (here) and the article on the histogram target (here), this one is...
2015-10-23
607 reads
Blog Posts
Data Warehouse Design Challenge: Relating a Temporal Fact Table to a Date Dimension
This past week I ran into an interesting challenge with a client. The data warehouse is capturing testing data for...
2015-10-23 (first published: 2015-10-19)
2,867 reads
First Day as DBA - Now What?
It's your first day at Corp of
America as DBA. The old DBA left. The sysadmins are managing the SQL Servers.
And...
2015-10-23 (first published: 2015-10-19)
4,217 reads
Improved #MinionBackup and #MinionReindex – new versions!
We released Minion Backup 1.1 and Minion Reindex 1.2 this week! We’ve got a some great new features, and a number of bug fixes....
2015-10-23
669 reads
PASS Summit 2015 Plans
I’m flying out Sunday morning on my usual direct flight from Orlando to Seattle. I like getting there a day...
2015-10-23
594 reads
SQL in the City Comes to Seattle in 3 Days
Last week I spoke at SQL in the City 2015 in London, and it was a great event. We had...
2015-10-23
624 reads
SQL in the City Comes to Seattle in 3 Days
Last week I spoke at SQL in the City 2015 in London, and it was a great event. We had...
2015-10-23
414 reads
SQL Server – Columnstore Index creation error: A columnstore index cannot be created on a SPARSE column
Hi friends, as we know that in SQL Server 2012 a new feature Columnstore index was introduced which made a...
2015-10-23
644 reads
Talk to Me at PASS Summit
If you’re going to PASS and you want to have a chat, I want to talk to you. If it’s...
2015-10-23
519 reads
Webinar – What’s New for Business Intelligence in SQL Server 2016
I’ll be giving a webinar for MSSQLTips.com on Thursday 29th October 2015.
The title is What’s New for Business Intelligence in SQL Server...
2015-10-23
837 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers