A frequent question among those learning about DevOps is "How do we do code reviews in this automated process?". Grant Fritchey shares three options - and a word of caution - to ensure you can appropriately understand the changes happening in your system.
2021-04-16
Keeping databases secure is critical. In this article, Robert Sheldon explains what to monitor for SQL Server security.
2021-04-16
I was asked to load multiple Excel files, each with multiple Excel worksheets. I found a very easy way to complete this in SSIS using a Script Task. This article will explain how I did this. For this example, I have two Excel files, File1.xlsx and File2.xlsx, as shown here: Each Excel File has three […]
2021-04-15
7,516 reads
In this article we will focus on Power Apps canvas apps which are natively optimized for mobile devices and we will look at potential use cases for canvas apps.
2021-04-15
Migration to the cloud and PaaS solutions has accelerated in the past years, and many organizations now manage hybrid estates. To reflect this, the latest release of SQL Monitor adds Azure SQL Managed Instances to its list of supported cloud platforms. This article explains how to monitor performance and activity for Azure SQL Managed Instances using SQL Monitor, with advice on monitoring hybrid estates and migrating from on-prem to Azure SQL Managed Instance.
2021-04-15
A look at one way to detect fraud using R and a machine learning model.
2021-04-14
2,380 reads
Join Microsoft's Rohan Kumar, and a full team of Azure SQL experts, for Innovate Today with Azure SQL. This free digital event from Microsoft lets you choose the sessions and technical demos that are most interesting to you and focus on the capabilities and possibilities that you want to learn more about.
2021-04-14
Oracle sequences can be used to create artificial IDs for a table. In this article, Jonathan Lewis explains how they work under-the-hood.
2021-04-14
In Part 1 of this series, we examine the structure of data pages and how your tables are stored on these pages.
2021-04-13
15,690 reads
Learn how to export data from SQL Server into Excel and programmatically add new columns to the spreadsheet using C#.
2021-04-13
By Steve Jones
I missed blogging yesterday as I was on stage/backstage for quite a bit of...
By Brian Kelley
A common theme in the PASS Summits I've attended is community and that's definitely...
By Chris Yates
I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying...
Hello T-SQL experts I have a table containing team codes and descriptions. Unfortunately, many...
Hi, In my Always On Availability environment, I am seeing two encrypt_option values as...
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