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

Daily Coping Tip

Get outside and notice how the weather feels

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.

For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

Metrics and Measures

Many organizations have been trying to find better ways to build and deploy software for their customers. Whether they deal with the general public or internal customers, we know that delivering software that customers use can be a competitive advantage. That's the goal of DevOps.
 
While most developers and management want to do this, they sometimes forget what the goal is. Instead, they want to continue to work in a similar manner themselves while giving lip service to actual change. They often do this while pushing others to somehow produce more and better software inside the same system. I see this over and over inside various companies.
 
To become better, many of us use metrics and measurement of data to help guide us in determining how to move forward. In the area of software, there are a number of research reports showing which metrics are indicative of organizations that do a good job of delivering value to their customers. There are four main metrics: deploy frequency, lead time, change fail percentage, and mean time to repair. These are highlighted, though there are plenty of other things to track in your software process.
 
However, aiming to just improve their metrics as the primary goal isn't going to make your software better. The goal is to deliver software that meets your customers' needs. Quicker, better quality, more features, and all those things that customers use are what is important. These metrics are there to help guide you, not to be the targets of efforts.  There's a good article that talks about some of the downsides of just trying to improve these metrics.
 
The goal is the continuous delivery of value to customers. The way we do this is by experimenting with code, getting rapid feedback from customers, adjusting and improving the code, and repeating the process, learning from our efforts. We drive automation to make this smooth and easy while enabling us to get our software to customers at the pace that suits our situation. It sounds vague and amorphous, and it is.
 
There is a bit of an art to developing a process that efficiently builds software. It depends highly on the people involved, and on two other things. First, guiding them to improve their process and skills with references to practices that have worked well. Second, giving them the freedom and support to experiment and learn from their efforts. In doing those two things, it's important to remember that while you can measure how well things are changing, aiming to improve the measurements often doesn't help you improve the goal: building better software.
 
It's good to measure things, but keep in mind that the measures are not the goal.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

ChatGPT and PowerShell – Some practical examples

Daniel Calbimonte from SQLServerCentral

See how well ChatGPT works with questions on generating PowerShell code.

External Article

New functions in SQL Server 2022 - LEFT_SHIFT and RIGHT_SHIFT

Additional Articles from MSSQLTips.com

Learn about the new functions LEFT_SHIFT and RIGHT_SHIFT in SQL Server 2022 and how these functions could be used.

External Article

The business value of frequent deployments

Additional Articles from Redgate

The multi-million-dollar question for you and your business is... what is the real business value of frequent deployments? Part one of three in this series on the value of database DevOps.

Blog Post

From the SQL Server Central Blogs - The Microsoft Ability Summit in Review

DataOnWheels from DataOnWheels

As many of you are aware, I have been dealing with a progressive version of ALS which is affecting my hands and arms and thus my ability to type....

Blog Post

From the SQL Server Central Blogs - Intelligent Query Processing (IQP)

Almighty from SQLSERVERSdba

In SQL Server 2022, a new feature called Intelligent Query Processing (IQP) makes use of machine learning to enhance query performance. Because of the automatic workload adjustment provided by...

Technical Article

Enabling Accelerated Data Recovery

Steve Jones - SSC Editor from SQLServerCentral

 

SQL Server 2022 Query Performance Tuning

SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance

Additional Articles from SQLServerCentral

Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumulated by the author. The book Includes expanded information on using extended events, automatic execution plan correction, and other advanced features now available in SQL Server.

 

 

 

 

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

SQL Server 2022 Restore and DBCompat

I have a new SQL Server 2022 instance. What is the earliest version of a SQL Server backup from which I can restore and what is the lowest db compat level?

Answer: Earliest backup is SQL Server 2005 and db compat level 100

Explanation: The earliest backup you can restore from on SQL Server 2022 is SQL Server 2005. The lowest db compatibility level, however, is 100. This is the SQL Server 2008 level. Ref:

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
Distributor database in publisher in ALWAYSON setup - Hi. SQL Version 2017 . I have one existing ALWAYSON AG setup.  I want to setup transactional replication On top of AG, Does Distributor database can able to configure and choose primary, secondary replica nodes while configure distributor role? please suggest. Or Remote distributor choose? Thanks
SQL Server 2016 - Administration
Troubleshooting TCP Provider: Error code 0x274C - Hello experts, I'm trying to help troubleshoot an issue affecting the connections between one of our Linux application servers and one of SQL 2016 servers. Source OS/Driver: Red Hat Enterprise Linux 7 (64-bit) ODBC Driver 11 for SQL Server Destination OS/SQL: Windows Server 2016 Standard Microsoft SQL Server 2016 (SP3-CU1-GDR) (KB5021128) - 13.0.7024.30 (X64) The […]
SQL Server 2016 - Development and T-SQL
Need to append 2 columns - Hi. Sorry for my original post not being clear. I think I am providing everything needed and I am clear now. This code uses the table ClientVisit and I'm including the create table for ClientVisit go WITH latest_visits AS ( SELECT client_id, MAX(timein) AS latest_visit_date FROM ClientVisit GROUP BY client_id ), latest_primary_visits AS ( SELECT […]
Issue Extracting 2nd Level Node Data from JSON File - Hi all, I'm venturing into the world of JSON and am currently trying to extract data out of and into SQL. Here's the problem, I cannot seem to get data out of the 2nd node in the example below. There is a related_resources and resource_type node that sit under the notes node.  It will not […]
Islands (no gaps) - Problem solved but could this be done better? - I've obfuscated my data, but this is legitimately the way the data in my table is distributed.  A "User" can have different tiers.  They may belong to one for a while, get bumped up, then get bumped down.  I need the start and end for each tier the user has been in.  They might go […]
SQL Server 2019 - Administration
Index and Statistics Maintenance - What are some best practices for maintaining indexes and statistics in SQL Server 2019? I want to ensure that my indexes and statistics are optimized on a regular basis. Are there any specific techniques or tools that are recommended? Any tips or resources would be greatly appreciated!
Troubleshooting slow running query - I have a process that uses 2 tables in PROD and it has been running slow in PROD. The tables are identical in UAT and the process runs much faster in UAT. What is the best way to tackle this....I was thinking of using Extended Events to capture the details. Is this the best approach?  […]
How to resolve Login differences between Primary and Secondary cluster nodes - I'm a bit rusty with SQL clustering so please bear with me, thanks. I have a 2-server availabilty group. The other day it failed over during a patching reboot, and a Linked Server connection no longer worked while it was failed over to secondary. Initiating a manual failover back to the original primary resolved the […]
SQL Server 2019 - Development
Replace function not working - Hi I have some data which is logging web errors. It returns data that looks similar to this... Array ( [error] => Quote not found [module] => api [detail] => 10038 ) I need to replace the Array ( [error] => with an empty string. So the end result looks like... Quote not found [module] […]
SELECT ROWS ON TIME CRITERIA - Hi, I would like to retrieve only the rows after 23:59:59 but I am getting the output as shown in the picture. Please advise how to write a correct where clause SELECT ID, STARTDATE, STARTTIME, ENDTIME FROM MACHINELOG WHERE (STARTTIME > CAST('00:00:00' as time(0)) AND ENDTIME < CAST('09:00:00' as time)) ORDER BY ID DESC
SELECT ROWS ON TIME CRITERIA - Hi, I would like to retrieve only the rows after 23:59:59 but I am getting the output as shown in the picture. Please advise how to write a correct where clause SELECT ID, STARTDATE, STARTTIME, ENDTIME FROM MACHINELOG WHERE (STARTTIME > CAST('00:00:00' as time(0)) AND ENDTIME < CAST('09:00:00' as time)) ORDER BY ID DESC
Iterate and assign Query help - Table:SchoolTeacher TeacherName Zip City State ------------ ---- ------ ------ Sam 12345 NJ NewYork Pat 12345 NJ NewYork Peter 12588 Spring MD School: SchoolLocationID Zip City State -------------- ------- ----- ----- 105 12345 NV NewYork 105 12345 NJ NewYork 106 12345 NJ NewYork 107 12588 Spring MD BusinessRule: 1) Match should be done on Zipcodes if […]
General
Help with sql statement to sum how many Individual Items from KIT Parts - SO I need to sum for each Individual Part that is need each day. You can order Parts individually or in a KIT. For instance a 455-TP kit includes (455-01,455-02,455-05,455-12) So and order might be 2 of a 455-TP and 2 of a 455-02 so for this order I would need  2 each of 455-01,455-05,455-12 […]
Multiple tables in MySQL - My have three tables (Stores, Item, and StoreInv) and I'm attempting to construct a join that includes all entries from Stores and Items even if no matching records exist in StoreInv. Probably best explained using an example: Table for storage: StoreId ------- Store1 Store2 Store3 Table of contents: ItemId ------- A B C StoreInv table […]
Strategies and Ideas
DWH'ing from scratch - Hello,   We are looking to build a data warehouse from scratch.  I was curious to know if someone might be able to point me in the right direction of a solid certification program for this?
 

 

RSS FeedTwitter

This email has been sent to {email}. 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

 

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