How Hard is Kubernetes?
Mercedes has taken advantage of containers and Kubernetes to build knowledge in their staff. This investment helps them adapt and change their technology to meet the needs of the business.
INSERT EXEC statement cannot be nested, the Simple Solution
Step-by-step guide to solve the "INSERT EXEC cannot be nested" problem by using a CLR when unit testing stored procedures using the tSQLt framework.
5 things to look for in a 3rd party database monitoring tool
Are you evaluating the effectiveness of your homegrown database monitoring tool or looking at investing in a 3rd party one? This helpful blog post suggests 5 things to look for in your evaluations.
Create a Table in Microsoft SQL Server
Learn how to create a table in SQL Server using T-SQL along with several different examples that build upon each other to create the final table.
DBA to Data Engineer
A title change can come with a salary bump in some cases, but you might need to work to achieve both of those. Steve has a few ideas today.
Getting More Information From the String or Binary Data Truncated Error
Get more information from the string or binary data truncated message to help troubleshoot data problems on SQL Server 2016, 2017, and 2019.
Introduction to Testing a Flyway Development
How to use Flyway Teams to run basic tests whenever it successfully executes a migration, checking that all the business processes supported by our database always produce the expected results.
Power BI Dynamic X and Y Axis Using Groupings in Field Parameters
In this step-by-step article, learn how to dynamically select what displays on the X or Y axis of a Power BI chart.
How to Visualize Python Charts in Power BI
This article will show how you can code in Python and produce a chart for Power BI.
Reducing Debt and Increasing Security
DevOps is often thought of as bringing more features to customers, but it can also help security.
Blogs
Day 2 at PASS Data Community Summit 2024
By Steve Jones
I missed blogging yesterday as I was on stage/backstage for quite a bit of...
PASS Summit 2024 – Wednesday
By Brian Kelley
A common theme in the PASS Summits I've attended is community and that's definitely...
Taming Database Challenges: Insights from Redgate Keynote
By Chris Yates
I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying...
Forums
Deduplicating rows by choosing the row with the shortest string
Hello T-SQL experts I have a table containing team codes and descriptions. Unfortunately, many...
Unencrypted connections in Always on Availability Group
Hi, In my Always On Availability environment, I am seeing two encrypt_option values as...
Question of the Day
Using Outer Joins
I have this data in a SQL Server 2019 database:
Customer table CustomerID CustomerName 1 Steve 2 Andy 3 Brian 4 Allen 5 Devin 6 Sally OrderHeader table OrderID CustomerID OrderDate 1 1 2024-02-01 2 1 2024-03-01 3 3 2024-04-01 4 4 2024-05-01 6 4 2024-05-01 7 3 2024-06-07 8 2 2024-04-07I want a list of all customers and their order counts for a period of time, including zero orders. If I run this query, how many rows are returned?
SELECT c.CustomerName, COUNT(oh.OrderID) FROM dbo.Customer AS c LEFT JOIN dbo.OrderHeader AS oh ON oh.CustomerID = c.CustomerID WHERE oh.Orderdate > '2024/04/01' GROUP BY c.CustomerNameSee possible answers