Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
 
The Voice of the DBA
 

Simple(r) Coffee

Starbucks has too many order combinations. This article about the challenges for their new CEO notes there are over 170,000 combinations of things customers can order. As someone who has visited a store often and stood behind someone placing an order, that sounds like an accurate number. Sometimes I hear people order things to drink that I had no idea were even possible.

When there are too many choices, sometimes there can be a delay as the person tries to process the information and make a decision. Some people can't make a decision. Others enjoy the variety and keep making different decisions each time. That's fine if you're visiting a restaurant, but it's less useful if you're building software.

I have worked with people who struggle to decide on an approach to solving a problem. In the C++ world, I'd see people struggling to organize classes and members, sometimes spending too much time researching and comparing different methods. They debate when is private or public appropriate, when do we need a superclass or subclass? We would see some paralysis by analysis from certain developers who are endlessly searching for the optimal approach.

Other developers might change their approach constantly, resulting in a lack of consistency across the codebase. In the modern world, I sometimes see users experimenting with different libraries or packages (or data stores) with each new project. They might be consistent within a project for a period of time, but since many teams often shift to different projects over time (or maintain them), how helpful is this? If each new project looks different, we spend a lot of time on developers getting familiar with the technology.

I have tended to adopt the philosophy of strong opinions, loosely held. In other words, I'll pick an approach/platform/technology/etc. and stick with it. Moreover, I'll ask everyone on the team to stick to a similar method of coding. If we need to change, then we can evaluate the proposed change, performance test it, and if we decide it's better, we all adopt this and slowly work to refactor old code as we have time. We never have time, so we only refactor when we have to touch old code for some fix or enhancement. However, when we do touch old code, let's improve it.

My preference is to allow a limited set of technologies in our company at any point in time. We need a process to add or remove something, but this ought to be a decision made to limit our range of technologies and required expertise. I'm not against Python or PowerShell or MongoDB or any other technology, but I don't want things adopted because an individual prefers that technology or thinks it works better. They need to prove that there is a good reason to others, and as a group, we agree that the value of adding a new technology is worth the burden.

Otherwise, we end up in the situation I see often in job descriptions: with a requirement that new hires know dozens of technologies at an expert level because we don't have that person on staff.

And we'll never find them.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
 
  Featured Contents
SQLServerCentral Article

How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions in SQL Server

Noman072 from SQLServerCentral

Learn how to avoid common pitfalls when using T-SQL trigonometric functions in SQL Server.

External Article

Partitioning Data in Microsoft Fabric to Improve Performance for Lakehouses, Warehouses, and Pipelines

Additional Articles from MSSQLTips.com

Learn how to implement data partitioning within Microsoft Fabric to improve performance for Lakehouses, Warehouses, and Pipelines.

Blog Post

From the SQL Server Central Blogs - How to clear the SSMS cache?

SQLPals from Mission: SQL Homeostasis

How to clear the SSMS cache?

If you are reading this, it's probably because you too have this rare need to clear the SSMS cache for...

Blog Post

From the SQL Server Central Blogs - How I Migrated to Azure PostgreSQL Flex from Single Server

hellosqlkitty from SQLKitty

I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also using the Azure migration tool. I had to ultimately do a combo of those because...

Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database

Site Owners from SQLServerCentral

Use this practical guide to analyze and troubleshoot SQL Server performance using wait statistics. You'll learn to identify precisely why your queries are running slowly. And you'll know how to measure the amount of time consumed by each bottleneck so you can focus attention on making the largest improvements first. This edition is updated to cover analysis of wait statistics current with SQL Server 2022. Whether you are new to wait statistics, or already familiar with them, this book provides a deeper understanding on how wait statistics are generated and what they mean for your SQL Server instance’s performance. 

 

  Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

The AG Secondary Logs

What happens when an AG secondary receives a log record from the primary?

Think you know the answer? Click here, and find out if you are right.

 

 

  Yesterday's Question of the Day (by Steve Jones - SSC Editor)

SQL in an Azure VM Backup

If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)

Answer: 15 minutes

Explanation: You can configure a backup for up to every 15 minutes. Ref: Azure Backup for SQL VMs - https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/backup-restore?view=azuresql#azbackup

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.


SQL Server 2017 - Administration
Proc cache slowly decreasing in size until restart is required - In SQL 2017 (14.0.3475.1) the size of the proc cache is slowly decreasing. The workload on the instance has the same profile every day and does not change with time. The proc cache size started at a little over 5G and after about 3 weeks is down to below 1G. Just before the previous restart, […]
Proc cache slowly decreasing in size until restart is required - In SQL 2017 (14.0.3475.1) the size of the proc cache is slowly decreasing. The workload on the instance has the same profile every day and does not change with time. The proc cache size started at a little over 5G and after about 3 weeks is down to below 1G. Just before the previous restart, […]
SQL Server 2019 - Administration
EXTENDED EVENTS Track What's Logging In - Simple one looking for a script that can track what's logging in from where for UPGRADE discovery.  
SQL Server 2019 - Development
Using ROW_NUMBER() to increment every time a value occurs - Hello folks, I have some rather unstructured data coming into a staging column from a file. I can guarantee the order of the data on load using a column I am calling RowNumber. I like to group the data using ROW_NUMBER() every time the value 'CreateDate' occurs. Here is current my effort. Thanks if you […]
how to keep report from running automatically when my params all default to null - Hi I'm standing up a report with 9 visible cascading params , none of which needs to be entered.   all will default to null, If i remember correctly , once i set it up, the report will run automatically without the user hitting the run button because all params default that way.  how can i […]
SQL Azure - Administration
Issue with Creating Linked Server from Azure SQL Managed Instance to On-Premises - Hi, Interestingly, I was able to create a linked server in the reverse direction—from the on-premises SQL Server to my Azure SQL MI—using a remote login and password for authentication. However, when I attempt to establish the link from Azure SQL MI to the on-premises SQL Server, it consistently fails. Additional Details: I have an […]
General
When trying to use a LocalDB, I get an error - I tried to find an appropriate forum to post the question. This one seems to be the closest. I'm sorry if I'm wrong. This is a long story, which I haven't time to go into now. I'm starting a new Blazor Web app using .NET 9 and include what's called Individual Accounts (or Individual Users, […]
Powershell
display bytea image - I moved a table from MsSql to Postgresql that had a field defined as Image in Mssql now in Postgres it's a Bytea field. How can I make sure data copied across with success? Is there some code I could run to make sure Image looks correct from PostgreSQL ? Thanks.
Analysis Services
MDX SSAS Calculated measure for last totals + turnovers - I have a measure with totals for specific dates with the LastNonEmpty aggregation, and a measure with turnovers with the Sum aggregation. Help create a measure with totals for each day that would take into account the last known totals + turnovers from the date of the last totals to the current date. I tried […]
Integration Services
PowerQuery.... don't meet SSIS - I have a powerQuery that reads and transforms a table in a PDF.  Works a champ. If I wanted to write the resulting table's data to SQL Server, I can use DAX Studio (kind of) because it creates a newtable and writes the data to it. But I wanted to just map the columns to […]
SSIS package 'Unexpected Termination' status when running from SSISDB catalog - We are trying to run SSIS package to read Access Database (.mdb) files using Native OLE DB\Microsoft Office 12 Access Database Engine OLE DB Provider in the Source Connection Manager. This package ran successfully from Visual Studio 2019 and also from SSISDB catalog in lower end servers. However, executing the package in higher environments resulted in 'Unexpected […]
T-SQL
Count of Total Appointments within 30 days of each Appointment Date - Good Afternoon. I have a Table where each Record: 1) Represents an Appointment. 2) Has a field Appointment Date. What I am trying to achieve is this: For each Appointment date in the dataset I wish to count up all the Appointments which occur within 30 days. For example, for 1st July 2024, I wish […]
SQL Server 2022 - Administration
I need help accessing my local SQLExpress - My PC has been causing me problems for months. I've told my desktop support team. They reimaged my machine, but it hasn't helped. I cannot run SSMS against the LocalDB I get this error: and that's as far as that goes. If I try to connect to LocalDB I get this error: and that ends […]
SQL Monitoring tools - our client wants to implement Third Party SQL Monitoring tool to monitor SQL server Performance. I would like to understand any recommendation that is being implemented to monitor the performance.
Reporting Services in Managed Instance - Hi , one of my on-premises servers one server is having databases and one more server maintain the reporting services . above 2 servers having connectivity between them . we are planning migrate into Azure Managed Instance .do we need 2 managed instance single managed instance . If Single Managed Instance how can we add […]
 

 

RSS FeedTwitter

This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -