SQL Server: The danger of large data types
Databases are platforms that are designed to securely store and retrieve your data. Perhaps that’s why they’re called a data...
2017-09-22
426 reads
How Mature are you in Database DevOps?
I remember seeing the Carnegie Mellon Software Capability Maturity Model (CMM) when I was in university. It was fascinating, and...
2017-09-22
952 reads
PASS Summit 2017 is Coming
The yearly PASS Summit is just around the corner, a little less than six weeks away. For those not familiar...
2017-09-22
352 reads
How Do I Analyze a SQL Server Execution Plan?
A query is slow, and you figure out how to collect the query execution plan. Now what? In this video, I talk “big picture” about what execution plans are,...
2017-09-22
60 reads
Restore BACPAC to SQL Azure
Hello!
2 posts in 1 day? When you’re hot, you’re hot!
I’m actually writing this one whilst I’m waiting for a BACPAC...
2017-09-22
367 reads
How To Update Visual Studio 2017
(AKA how I lost a morning)
Hello!
This morning I needed to update my version of SSDT, but before I could do...
2017-09-22
779 reads
SQLpassion Online Training in October 2017
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-09-21
471 reads
Distributed Writes
In SQL Server, scaling out reads (i.e. using Active secondary replicas via AlwaysOn Availability Groups) is a lot easier than scaling out...
2017-09-21
745 reads
Recover Deleted Data from SQL Table Using Transaction Log and LSNs
Introduction
At times a user may perform UPDATE operation or DELETE operation in SQL server database without applying the WHERE condition....
2017-09-28 (first published: 2017-09-21)
4,995 reads
What’s a SQL Compare Snapshot?
I saw a short video from Grant Fritchey on the Redgate channel that shows how to cerate a snapshot in...
2017-09-21
818 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