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

Daily Coping Tip

Make some tasty food for someone who will appreciate it.

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.

Reducing Debt and Increasing Security

Many of us know that reducing financial debt in our lives leads to a bit more security in our minds. We are better able to cope with unexpected expenses when we have the ability to get credit or pay for something in cash. If you've ever had a major house repair, car calamity, or (hopefully not) medical issue, you know what I mean. At least in the US. That last one is less of an issue in many other countries.

We know that our code has technical debt, and often we fight a battle with project managers and business people over whether we should spend time paying down that technical or developing new features. We certainly can do both, but often that's not a choice we are given. If we do get the chance to reduce technical debt, it's a tiny fraction of the time that is allocated to adding something new.

There might be a better argument to reducing some technical debt: security. There's an article that talks about the security risk posed by moving too fast and not ensuring here is rigorous security testing. This is a common problem in many companies that adopt some of DevOps, but forget that quickly deploying new code isn't the only principle. We also need to learn from our mistakes and quickly correct them.

I am a big fan of releasing often, especially for security purposes, but those releases need to build on each other with not only new code but refactored old code that doesn't perform well or has a security issue. More importantly, we need to ensure when we find issues in code, that all developers are aware of the problem and don't repeat the issue. We also need to update our testing to ensure that humans don't continue to write code in a style that causes known issues.

This is less of a developer issue than a managerial one. The C-suite and all management that are involved in software need to prioritize security so that known issues are fixed quickly. This also should involve ensuring that technical debt is kept under control as a lot of this poorly written code increases the chances that a vulnerability is in the code. Either because the code isn't well written or because developers avoid touching the code in the future.

The best solutions, to me, involve DevOps. Make small changes, deploy them, instrument them, and learn if they work well. If not, fix them quickly. While this might end up delaying some features, ultimately it ensures that our software is in better shape, with a reduced risk of simple security mistakes upsetting our customers.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

How to Visualize Python Charts in Power BI

Daniel Calbimonte from SQLServerCentral

This article will show how you can code in Python and produce a chart for Power BI.

External Article

Re-baselining a Database using Flyway Desktop

Additional Articles from Redgate

Over time, Flyway projects can accumulate a lot of migration scripts, with many database objects being created, altered, and dropped across many files. Tonie Huizer explains why you might want to create a new baseline migration file to create the latest version of a Flyway-managed database in a single leap, and how to persuade Flyway Desktop to do it.

External Article

Metrics that matter for IT organizations on an agile journey

Additional Articles from SimpleTalk

Measuring the wrong things is worse than not measuring anything. In this article, Mallika Gunturu explains the right things to measure for agile.

Blog Post

From the SQL Server Central Blogs - Max server memory recommendations are just a suggestion

Randolph West from Born SQL with Randolph West

Some of you might know me because of the Max Server Memory Matrix, a chart I created based off a decade-old algorithm developed by Jonathan Kehayias. The chart has...

Blog Post

From the SQL Server Central Blogs - SQL Homework – August 2022 – Replication part 1

Kenneth.Fisher from SQLStudies

You’ll hear a lot of people complain about replication. Including me. That said, replication is an amazing tool. There really ... Continue reading

 

 Question of the Day

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

 

GENERATE_SERIES Permissions

In SQL Server 2022, I want to allow a user permission to execute the GENERATE_SERIES function. What minimal permissions does the user need?

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)

Python in Power BI

I want to use Python to import data into a Power BI Desktop report. If I have the need to pick a specific version of Python that is used to run scripts, what are my options?

Answer: In the Power BI Desktop options, you can select the version of python based on what is installed on your system

Explanation: If you have multiple versions of Python on your system, you can select the Options menu in Power BI and there is a Python Scripting section where you can select the version of python to use. 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
Which version of SSMS to connect to SSIS 2008 - I suspect that an SSIS package in source control is not the latest deployed version in production. I want to pull the current deployed package from the production server and check its logic. This package is deployed to an old SQL 2008R2 box that I'm currently working on moving all the SSIS packages off and […]
SQL Server 2017 - Development
DB Mail sysmail keeps stopping. sysmail_start_sp takes forever and never finshes - i use exec dbo.sysmail_start_sp to start DB Mail but it keeps running forever. When i check the status using EXEC dbo.sysmail_help_status_sp , it shows Started. But i automcatically goes in STOPPED mode and i have to restart DB Mail. None of the emails are going through and can be viewed in sysmail_mailitems table with status […]
SSIS Rows per Batch and Max Insert Commit Size - I have an SSIS package which is copying 5 large tables daily. There is no WHERE logic in these data pulls, every record is selected and the source tables will only keep growing. Currently, we are now at the point where the SSIS package causes the Transaction Log on the target SQL Server to run […]
SQL Server 2016 - Administration
Truncate partition table failed due to index not partition. Help please. - I have 1 table which has a partition on Date column. However this table has a unique constraints on it's ID. Here's how the table creation script looks like. CREATE TABLE [TestDB].[dbo].[tblDS2]( [GSN_ID] [varchar](50) NOT NULL, [DS2_Lot_ID] [varchar](50) NULL, [DS2_SubLot_ID] [varchar](50) NULL, [DS2_X] [smallint] NULL, [DS2_Y] [smallint] NULL, [DS2_Bin] [varchar](10) NULL, [DS2_Date] [smalldatetime] NULL, [GsnBeforeFix] […]
Can I retrieve T-SQL from Maintenance Plan without using GUI? - Can I retrieve T-SQL from Maintenance Plan steps by running a query ? (without using GUI in SSMS)
Stored procedure able to be built over table that doesn't exist - SQL 2016 SP3 So we're updating some procedures to use a different table, it's the same name but different schema, neither one uses the dbo schema. The table under the old schema has been deleted. I found that I was able to successfully build the procedure even though I missed changing one of the references […]
SQL Server 2016 - Development and T-SQL
Read multiple files of same name and process in DB - Hi All, I have a requirement like, we will receive multiple csv files in a shared path and those files needs to be processed to the corresponding tables. Say for eg: if Employee file has 3 files like employee_2022_08_08_11_11 / employee_2022_08_07_12_00 / employee_2022_08_08_16_07 i need to process these three files to my employee table and […]
Administration - SQL Server 2014
Sql Reconfigure - Hi Will the below script will stop services ot will execute without restarting services sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'max server memory', 65536; --64GB GO RECONFIGURE; GO WAITFOR DELAY '00:02:00'; GO sp_configure 'max server memory', 215040; --210 GB GO RECONFIGURE; GO Thanks  
Development - SQL Server 2014
Use 2 CTEs in a Single SQL Query - Hi , I'm trying to union 2 CTE queries into one.  but must be missing something.  as I get an issue after the union . I tried a few things but no luck. Im trying to select different Meshtypes as per query. The first CTE is sum_cte and the s2nd is sum_cte2 this is what […]
SQL Server 2019 - Development
Finding Special Characters in Email Address - Hi All, I have to find the special characters in email address apart from alphabets, numbers SELECT EmailAddress AS ValidEmail FROM Contacts WHERE EmailAddress LIKE '%_@__%.__%' AND PATINDEX('%[^a-z,0-9,@,.,_,\-]%', EmailAddress) = 0 GO   Regards Sathish Kumar
when check directory at shared path remotely it display not exist (false) althou - when check directory at shared path remotely it display not exist (false) although it exists I have shared path '\\192.168.7.9\Import\8' I face issue when try to check this directory path exist or not . when run script python on sql server 2019 it must return true because directory path exist but my issue is python script return […]
SQL Server 2008 Administration
How to restore a database with Full Text Search - HI, The SQL Server instance is 2008 R2. I have a database with a Full Recovery Model and Full Text Search. I need to make a copy of the database on the same server. I have used SSMS to make a backup of the database. I checked the box "Copy-only backup". I want to create […]
Azure Data Factory
Any good resource to learn Data Factory ? - I just joined a company and I'm new to Azure. It's a powerful tool but I don't like Data Factory because it reminds me of SSIS and I think it's just clumsy and quite difficult to create pipelines, let alone debug them. Although, I don't know of I hate it because I don't know how […]
XML
XML Query to return xml element as column for specific attribute value - Despite having read several articles/examples, I can't solve what seems like it should be a simple problem -- How do I return an xml element value as a column for a specified value of an attribute in that same element. e.g.,     31 -- How I return this as LengthMinutes?     […]
Integration Services
How to unzip the Updates files and avoid which are already unzipped? - Hi everyone, I recently started using WinSCP. I download some .zip files using it from a remote server on a daily basis. These files are basically updates that arrive on the server on a daily basis and save to my local folder: D:\Updates\ Named like these: UPDATE_20220805.zip, UPDATE_20220804.zip, UPDATE_20220803.zip, UPDATE_20220802.zip .....   I want to […]
 

 

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

 

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