SQL Server Schema Compare
A very common requirement which can be satisfied by various tools. Personally I like using Visual Studio 2017 Community Edition...
2017-09-18
791 reads
Confidence Intervals for a proportion – using R
What is the difference between reading numbers as they are presented, and interpreting them in a mature, deeper way? One...
2017-09-28 (first published: 2017-09-18)
1,340 reads
Monday Coffee: Should I learn powershell?
This month’s T-SQL Tuesday’s topic was set by Rob Sewell (b|t) and entitled Let’s all get PoSH
It had a massive...
2017-09-18
818 reads
Generate Markdown Table of Contents based on files within a folder with PowerShell
Last week I was talking with Constantine Kokkinos (b | t) about generating a Table Of Contents (TOC) for a GitHub repository.
He wrote a cool blog post - Generating...
2017-09-18
27 reads
SQL Server database basics
So today I'll talk about some of the basic items for SQL server that helps to understand the reason of some performance recommendations. This first post will list and...
2017-09-16
24 reads
SQL Server database basics
So today I'll talk about some of the basic items for SQL server that helps to understand the reason of...
2017-09-16
157 reads
I want a new gadget with less features
Years ago I bought a Pebble smartwatch. I didn’t back the Kickstarter, but a few friends did and I liked...
2017-09-15
911 reads
PASS Summit 2017 Precon – Virtual SQL Servers: Right to Ludicrous Speed
PASS has continues to ramp up the plans for the PASS Summit in Seattle this October, and my precon session, “Virtual...
2017-09-15
168 reads
PASS Summit 2017 Precon – Virtual SQL Servers: Right to Ludicrous Speed
PASS has continues to ramp up the plans for the PASS Summit in Seattle this October, and my precon session, “Virtual...
2017-09-15
372 reads
The Code Coverage Report
I had someone that told me recently that they needed to find a way to get code coverage in T-SQL....
2017-09-15
868 reads
Blogs
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...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
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