A week in Seattle in 8 Slides at the PASS Data community Summit 2022
A look back at the PASS Data Community Summit in 8 slides from Tonie Huizer.
Being Agile - A Success Story
Learn how one company adopted, adapted, and learned from the Agile methodology.
SQL Server at Scale - Using an Archive Table - Part 2
In my previous tip, I explained how we are inclined to use archive tables and how they become increasingly problematic over time. This tip will focus on ways to mitigate the issues.
Conditional Formatting with SSRS
An introduction on how to implement condition formatting of cells, such as the font and background colour or font weight, within SSRS using SSRS Expressions.
Securing Your Instances
This week Steve Jones looks at moving the port numbers of your instances for a bit of security.
Is Azure SQL Database a Good Choice for your Database Applications?
In this article, we cover things you should know about Azure SQL Database and why this may be a good choice for your database applications.
Why bother automating?
Bob Pusateri, Database Engineering Lead at Salesforce, joined our recent Summit to discuss how automation can enable digital transformation. Listen in full.
AI Medical Record Scanning
Artificial Intelligence can help humans, both in diagnosis, but also in teaching medical professionals.
Amazon RDS - Configuring a Connection to a SQL Server Instance
In this article, you will learn how to configure an RDS database for connections from client tools.
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers