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

Daily Coping Tip

Write a list of things you feel grateful for in life and why

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.

The Responsibility for Bugs

Most software has bugs. Actually, maybe all software has bugs, but often we can live with some of them. Over time, vendors regularly issue patches to fix things, and despite these issues, many of us continue to use software productively, if not happily. We live with some workarounds or issues, and continue to get work done, entertain ourselves, and the world keeps moving forward.

Recently a software developer issued a full refund to customers that had been running into issues with their software, in this case a game. Apparently this is more of a platform issue, as the early reviewers saw the game on a PC, and many of the complaints are on dedicated consoles. The developer of the game has promised patches to fix the main issues, but if customers want a refund, they can get one.

I've had issues with plenty of software in the past, as vendors release a new version that might not have been tested as well as it should. I've also seen plenty of scale issues, where software is tested or architected for a certain scale, but customers use it at larger scales. My work with large enterprises, showed the latter to be the case more often than I'd like.

In the case of the game, the public outcry can cause lots of changes, mostly because the goodwill and reputation of the vendor are at stake. However, in many enterprise software sales, there isn't a public disclosure of issues that prevent other customers from learning of issues. Part of this is a lack of detailed public reviews of software, and part of this is that users don't often share specific issues outside of their organization.

I wish more vendors were held accountable for bugs, and with responsibility to patch and mitigate them. However, I also see that software is used in so many different ways, with many configurations, that it can be hard to comprehensively test everything. I also know that there are bugs that very few customers hit, and the cost to deal with these can be high.

Ultimately, I think I'd like to have more transparency required about which bugs customers hit and in which environments. I'd also like to have some requirement that some percentage of bugs must be fixed within a timeframe or customers entitled to some compensation. I know this might lead to many simple bugs fixed, but perhaps it would also pressure software vendors to improve their quality a little more than they do today.

Steve Jones - SSC Editor

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

 
 Featured Contents

Data Element Names and Scoping Rules in SQL

Joe Celko from SQLServerCentral

How you name data elements in databases and applications programs has often been a matter of personal taste. Decades ago, when I worked for state government, there is a COBOL programmer who would pick a theme for his programs. The paragraphs and variables would be named based on the current theme. One of his programs […]

Import Data from PDF to SQL Server

Additional Articles from MSSQLTips.com

In this article we look at how we can use R and SQL Server to import lottery numbers from a PDF document into a SQL Server table.

Masking Data in Practice

Additional Articles from Redgate

Phil Factor takes a strategic look at common SQL data masking techniques, and the challenges inherent in masking certain types of sensitive and personal data, while ensuring that it still looks like the real data, and retains its referential integrity, and distribution characteristics.

From the SQL Server Central Blogs - SQL Homework – January 2020 – Create an End of Year/New Year checklist.

Kenneth.Fisher from SQLStudies

It’s a brand new year and hopefully it will be better than last year. While that may be particularly true ... Continue reading

From the SQL Server Central Blogs - Identify the (Top 20) most expensive queries across your SQL Server using Query Store

matthew.mcgiffen 73574 from Matthew McGiffen DBA

Script to identify the most expensive queries on your database server using the Query Store DMVs. This allows you to look at data from a specific time frame, as...

 

 Question of the Day

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

 

CLOSEing a cursor

What does the CLOSE command do to a cursor?

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)

Sending Your Local Branch Up

I clone a Git repository and am on the main branch. I have created a new branch in Git with this code:

git branch featureSteve

I now add some code to the repo and commit it. However, I've made a mistake. What is it?

 

Answer: I didn't checkout the branch

Explanation: Using git branch will create a branch, but it does not checkout the branch for work. You need to use "git checkout featureSteve" before adding code. 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
DBCC CHECKTABLE Errors - Hi all, Please see attached for the output of DBCC CHECKTABLE on one of our tables. The affected records are almost certainly attachments we are storing as VARBINARY in the table. I'd like to know what my options are. Restoring to a previous backup is unfortunately not possible. I am okay with repairing with data […]
Exec SSIS package from TSQL Agent Job Step - Hello, I have a SSIS Package deployed to the SSISDB Catalog.  I have a stored procedure setup to create an execution, pass in a few variables/parameters and then start the execution. I created a tsql jobstep to call the stored procedure. This works as long as the agent job is owned by an SA user. […]
SQL Server 2016 - Administration
ETL Tool job is slow - Hi Experts, I need some piece of advice on how to about this below scenario. In our environment we have ETL solution called BODS to load data into a datawarehouse. Application team says, one of the ETL job is running slow. Basically, it is not a SQL Agent Job. ETL tool has its own job […]
SQL Server 2016 - Development and T-SQL
Script for employees and their monthly man hours - Dear Everyone I hope you are all safe I have a script which needs to be modified for gathering the monthly man hours for my company. I use a cursor to add the employee ID and man hours into the cursor and display it at the end of the cursor. I cant get to display […]
Administration - SQL Server 2014
shrinking data file - Hello all, I am struggling with shrinking of a big database in TB. I read on many links and it is recommended not to shrink the file because it may cause defragmantation. In my case it is absolutely needed.  I went through this article and did some shrinking on some dev DB and it worked […]
Development - SQL Server 2014
T-SQL Query select with a heap table without join - Hi, i have a query for selecting data on multi tables with a join but  one of my tables is a heap table with million rows without join (no clustered index and no non_clustered index) performance is very bad, do you have an idea to perform?
SQL Server DLLs required on user's PC - Hi, I have deployed my program on several user's PCs and they get the following error I believe when the program tries to Open a connection: "Login filed for user". Kind of a strange error., since the credentials are in the program and I don't get the error when I run from my PC, but […]
SQL 2012 - General
At wits end with Service Master Key, please help. - Recently our linked servers are failing due to the following "Generic failure...Service Master Key..." So knowing what I know I need to regenerate the Service Master Key using: ALTER SERVICE MASTER KEY FORCE REGENERATE Which I get the following: The current master key cannot be decrypted. The error was ignored because the FORCE option was […]
SQL Server 2019 - Administration
I have 4 nodes and i want 3 instances on 3 nodes and 4th as passive for windows - I have 4 nodes and i want 3 instances on 3 nodes and 4th as passive for windows fail over cluster i am not sure what should be ideal architecture and how to proceed with further any one has detailed idea and if can help me would be greatful
Does Migration assistant support SSRS - I see the migration assistant tool has support for database engine and SSIS, but I don't see SSRS, So no support for SSRS?   Thanks
Encryption key for SSRS - do I need to restore or not? - Encryption key - do I need to restore it or not ? I am testing some SSRS migration process. I noticed if I migrate from a server to a different server, I do need to restore encryption key after restore the report dbs. But if I just change an existing server from one name to […]
SQL Server 2019 - Development
Failed to Initialized SQL CMD Library? - Hello~ I have a scheduled SSMS Job that had been working without issue, but started failing recently with the following error: Message Executed as user: NT AUTHORITY\SYSTEM. Failed to initialize sqlcmd library with error number -2147467259. [SQLSTATE 42000] (Error 22050).  The step failed. The job is simply running a T-SQL script that counts the number […]
Decimal places - Another decimal question re decimal points within a case statement. Trying to get  2 decimal points for each case statement but not getting the results expected. Thanks for any help. select f.Month ,f.Site ,ISNULL(f.num,0) as 'NUM' ,f.DEN ,case when f.HAI ='A' then (isnull(f.NUM,0)/f.DEN) *10000 when f.HAI ='B' then (isnull(f.NUM,0)/f.den) *1000 when f.HAI ='C' then (isnull(f.NUM,0)/f.den) […]
is value is contained in column - new column - i need to add a column to determine if ID and specified Type exist in the table (1 if exists, 0 if not)   Specific Type: B ID   Type    Desired Column 1      A          1 1      B          1 2      A    […]
Anything that is NOT about SQL!
SSC Fantasy Football 2021 - Placeholder for the 2021 league. Congrats to the 2020 winners: First - Way0utwest Cowboys - $100 Second - British Bulldogs - $75 Third - SSC Ravens - $50 I'll do the same prizes next year. Everyone from 2019 has first crack at the league (12 teams), but if you're interested in joining, leave a note […]
 

 

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

 

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