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

Effective Engineering

I'm not the smartest developer or DBA. I find myself mystified at times by Itzik's posts on T-SQL queries and I'm amazed at times by the complex systems that I see the DCAC people put together. I can usually figure things out (sometimes by asking the authors a question), but it's not always easy to do. We have some truly gifted, incredibly intelligent people in this business.

I am, however, effective. I have been very successful in my career at getting things done well enough, things that work well, meet the needs of my client/employer, and meeting deadlines. I don't just slap things together, but think about them, build them, test them (don't forget this), and then make sure they're working when they're deployed.

Sometimes this might take a few PRs or patches for patches, but I get things done.

I saw this post on Linked In noting Platform Engineering is Dead, which is a great title, but not really true, and not quite reflected in the piece. The author worked on the Software Delivery Enablement team, which is what the platform engineering team is supposed to do.

I see similar complaints about DevOps, and previously saw complaints about Cloud computing or Agile or Scrum or SOLID. There have been similar complaints about how some new methodology or idea isn't working and should be abandoned in favor of this other new thing.

Ultimately, near the end of the piece on Linked In, there is this:"we also knew how to help them use solutions to deliver software better, and we partnered with them instead of inflicting things upon them."

This is what Software Engineering should be. In waterfall, we want to have customers tell us what they want and build that. Often customers don't know what they want, so we decided Agile would help. DevOps is a way of talking about a partnership between developers and operations that still delivers what the customer wants, quickly.

Platform Engineering or Software Delivery Enablement or whatever name you give it is still partnering with customers to deliver what they need. Not what you think they need or what you want to build, but what they need.

Whenever Agile or Scrum or DevOps or Platform Engineering doesn't work, it's because you've forgotten that this is a partnership.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Converting Old Running Total Code to Window Functions

Steve Jones - SSC Editor from SQLServerCentral

This article looks at the old style of calculating a running total and how to convert that to code that uses a window function.

External Article

SQL Index Rebuild vs Reorganize Comparison

Additional Articles from MSSQLTips.com

This tip covers the differences and similarities between SQL Server index rebuild and index reorganize operations.

Blog Post

From the SQL Server Central Blogs - Monday Monitor Tips–Finding CUs for My Instance

Steve Jones - SSC Editor from The Voice of the DBA

How can I quickly get a CU patch for a system that’s out of date? I’ll discuss that situation. You might think you get to patch every instance every...

Blog Post

From the SQL Server Central Blogs - Why CFOs Can’t Afford to Delay BI Adoption

Joyful Craftsmen from Joyful Craftsmen Blog

The post Why CFOs Can’t Afford to Delay BI Adoption appeared first on Joyful Craftsmen.

Deciphering Data Architectures

Deciphering Data Architectures

Additional Articles from SQLServerCentral

Data fabric, data lakehouse, and data mesh have recently appeared as viable alternatives to the modern data warehouse. These new architectures have solid benefits, but they're also surrounded by a lot of hyperbole and confusion. This practical book provides a guided tour of these architectures to help data professionals understand the pros and cons of each.

 

 Question of the Day

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

 

Migration Assistant Issues

If I run the Data Migration Assistant to check for an upgrade from SQL Server 2008 to SQL Server 2022, which categories of issues are pointed out as potential items that can affect an upgrade? (choose 3)

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)

Enable a Disabled Index

I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?

Answer: ALTER INDEX LoggerCI on dbo.Logger REBUILD

Explanation: The ALTER INDEX command with REBUILD is used. Ref: Enabling Indexes and Constraints - https://learn.microsoft.com/en-us/sql/relational-databases/indexes/enable-indexes-and-constraints?view=sql-server-ver16

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 - Development
Error 28054 related to master key root cause and solution required - I am getting the following error in SQL Server Error Log randomly on few days. I want to know the root cause for this error so that we can decide on applicable solution for this particular error. Service Broker needs to access the master key in the database. Error code:32. The master key has to […]
How to attach Database created in higher version to lower version of SQL Server - I have attempted to attach a database created in a higher version of SQL Server to a lower version, but I encountered errors. I also tried the backup and restore method, which resulted in errors as well. According to the following link, I explored several options but was unsuccessful: https://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/ 1. Generate Scripts Wizard in […]
SQL Server 2016 - Administration
application not connecting to secondary -   Hi the application which  has the connection string of the listener configured connects to node S01  but when failed over to S02  it  does not connect there are no applicable error in the SQL logs and windows logs please let me know    
Development - SQL Server 2014
Query to return all data that has same site, section and date - I have a query Select Id, WOCode, Site, Section, CompletionDate from work orders where type = 'BRE'. I want to be able to return list of all WOCode that has same Site,Section and CompletionDate. The date field will be date only with no time
SQL Server 2019 - Administration
sql monitoring tool - Has anybody had any experience with Nagios as a SQLServer monitoring tool. What were the pros and cons you had faced while using it. Please advise.
Failed restore database - Hi All , I have issue restoring small database . SQL version : SQL 2014 In the server , At first I took a backup of database ( bak file ) and compressed it . Then I copied ( standard copy ) to my local laptop from server , after that I copied back to […]
SQL Server 2019 - Development
max and min dates - Hi I am trying to get the first and last days for the following where date_next_compare is less than 28 but having more than that would mean the max date for that range. Sorry if isn't clear. I currently have this:   I want to see two rows like below. I tried doing min and […]
Pivot Mistake - Hi all, I have this query where I make a pivot to extract the data segmented by Hours: select ‘Amount’ as Amount, [0] ,[1] ,[2] ,[2] ,[3] ,[4] ,[5] ,[6] ,[7] ,[8] ,[9] ,[10] ,[11] ,[12] ,[13] ,[14] ,[15] ,[16] ,[17] ,[18] ,[19] ,[20] ,[21] ,[22] ,[23] from (select sum(efeneg) ‘Amount’,left(hormsg,2) ‘Time’,left(hormsg,2) ‘Time’,left(hormsg,2) ‘Time’. from […]
open query via linked server to db2 is showing terrible performance - Hi this post is mostly about cross server concepts vs a query being sent to and run on the target server and then the data simply coming back over the network.  but any feedback is appreciated. we have a sql server linked server thru which the db2 erp query (view) shown below is sent to […]
General
What is Azure Data Studio or GitHub asking me? - I have an Azure Data Studio question (or maybe it's a GitHub question, I'm not sure), but I couldn't find a forum here to ask it. So, please excuse my asking it here. I am busy writing a T-SQL script, using Azure Data Studio. I committed my changes locally, then I tried pushing them to […]
How do data visualization consultants overcome the challenge of integrating? - Integrating multiple data sources is challenging due to differences in data formats, structures, and quality. Data visualization consultants must first establish data connections and ensure consistent data formatting. This often involves using ETL (Extract, Transform, Load) processes to clean and combine data. They must also handle data refreshes and ensure that integrated data is up-to-date. […]
SQL Server 2022 - Administration
SQLExternalMonitoring what is it in sp_who2 result - If I run sp_who2, one of item in the list is showing using program SQLExternalMonitoring , what is it? it uses quite a bit cpu and ram. 70 sleeping NT AUTHORITY\SYSTEM SNOCSMASQP01 . master AWAITING COMMAND 170846212 57458731 09/26 10:31:41 SQLExternalMonitoring 70 0   Thanks,
Linked Server to SAP HANA database. - Greetings all.  It's been a very long time, but I'm back.  Does anyone have experience with setting up a linked server to a SAP HANA database?  I have hanaclient-2.8.20-windows-x64 installed and a DSN created using the HDBODBC driver that comes with the client install.  I am able to use the DSN to connect with generic […]
SQL job & SSIS package excution - Hi SQL experts, We have installed SQL Server with 2022 and using this as SSIS server. SSIS DB is the only one database on this server. We deployed a SSIS package, which is scheduled to run every 1 hr through SQL agent job. The job is failing sometimes & running successfully other times.  The job […]
SQL Server 2022 - Development
SQL Query Optimizer Supporting Parameterized Query and WHERE Clause Optimization - I am looking for a SQL query optimization tool that can enhance my query execution times. I have already tried EverSQL and SQL Tuning, but they are not meeting my requirements for the following reasons: 1. Parameterized Queries: Both tools seem to struggle with parameterized queries and do not optimize them correctly. 2. WHERE Clause […]
 

 

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

 

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