SQL Server Diagnostic Information Queries for February 2014
I improved the file-level latency query this month and made some other small improvements to a few other queries. Rather...
2014-02-06
1,188 reads
Blog Posts
Thank You!
I am humbled and honored (and more than a little horrified) to be on this list of the Best of...
2014-02-06
708 reads
Virtual Lab – Design and Setup
This is part of a series where I set up a virtual lab for testing and misc work. The other...
2014-02-06
1,298 reads
Virtualization resource consumption counters lie to you
OK, so maybe they do not lie to you, but I got your attention. In virtualized environments, the performance statistics...
2014-02-06 (first published: 2014-01-28)
2,152 reads
Your top 10 favorite Excel posts of 2013
The most popular Excel blog posts of 2013 reflect your interest in the new capabilities we’ve added to Excel this...
2014-02-06
360 reads
Automate T-SQL Merge For Loading Dimensions
If you’re a data warehouse developer, chances are you use T-SQL Merge statement to process slowly changing dimensions. If you’ve...
2014-02-05
1,362 reads
Free data & statistics, data collection, analysis, visualization and sharing – knoema.com
Knoema is a knowledge platform. The basic idea is to connect data with analytical and presentation tools. As a result,...
2014-02-05
560 reads
Just use Version Control
There are free systems out there. If you have no budget, and want to get started, download one of these:
Subversion:...
2014-02-05 (first published: 2014-01-28)
2,956 reads
Master Data Services for the Beginner Part 03
Introduction
In yesterday’s discussion we looked at creating entities and their related attributes. We learnt that a ‘model’ could be very...
2014-02-05 (first published: 2014-01-28)
6,250 reads
New Data Science – What’s Next?
While every organization is different, their “big data” is often very similar. It typically comprises massive amounts of data across...
2014-02-05
414 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