Impact Minutes
When downtime strikes, we may have to make decisions about which systems to focus our efforts upon. Steve talks about the impact of a disaster on your choices.
Finding Inactive SQL Server Databases
Phil Factor demonstrates how to use Extended Events to detect acquisition of Intent locks, and so determine which databases are active or apparently 'dormant', and then on which tables data has been modified recently, or which views and stored procedures have been run.
Power BI Theme Generator New Methods and Customizations
New methods and usage for themes were recently introduced for Power BI and in this article we cover how you can use these and customize them for Power BI.
Building SQL Memorial - Getting Started
Introduction One of the projects I've been wanting to tackle for some time is putting up a memorial for those people that our community has lost. I talked about it when Dwain Camps passed, and I kicked myself for not having something available when Tom Roush passed. Recently Gareth Swanepoel suddenly left us after COVID-19 […]
Remembering the Past
We had unfortunately lost quite a few members of our SQL Family. We have a new way to remember them.
SQL Server interview questions for experienced developers
SQL Server tech interview questions must be well crafted to make sure the candidate actually knows the topic. In this article, Sergey Gigoyan provides his favorite questions for interviewing SQL Server developers.
Getting started with the SQL MERGE statement
This article is focused on beginners who have already started writing SQL queries and are now diving deep towards more data processing and complex queries in SQL. When we talk about data processing, an important concept that comes to our mind is performing ETL workloads to a data warehouse. ETL is a very complex topic […]
Live versus Stored Data
Is it always important to have the most current data? Steve notes that you might need to make a decision here.
Create SQL Server Graphics with ggplot2 and R Services
Learn how to create charts and graphs with R and how you can use R code in SSMS to generate and save graphs to an external file.
Is Tempdb Causing a Bottleneck?
One of your SQL Server instance shows a major dip in performance or throughput, affecting all the user databases. You notice that the slow interludes coincide, as if orchestrated. On investigation, it appears that several transactions running over that period were using a lot of space in tempdb. However, which of them, if any, are causing the tempdb bottleneck, and why?
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers