Using Extended Events to Detect Connection Pooling
What is connection pooling? Lets start with a definition from MSDN. Connecting to a data source can be time consuming....
2015-10-20
135 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-19
481 reads
Kicking the Tires on SSIS 2016
Last week I hosted a webinar in which I reviewed some of the coming changes for SQL Server Integration Services...
2015-10-19 (first published: 2015-10-07)
3,025 reads
Know Before You GO – Target Settings
The last few articles have covered various topics for the event_file and ring_buffer target. The topics range from basic queries in...
2015-10-19
625 reads
Know Before You GO – Target Settings
When adding a Target to a session, a configurable setting may or may not be obviously available for use with the Target. In and of itself, this can be...
2015-10-19
14 reads
PASS Summit 2015
Yes, it is that time of the year again. You know, when all the nut case and normal SQL Server...
2015-10-19
521 reads
2015-10-19
8 reads
2015-10-19
11 reads
2015-10-19
20 reads
2015-10-19
17 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