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

Daily Coping Tip

Aim to be good enough, rather than perfect

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.

Aiming for Better Data Governance

At Redgate, we have customers all over the world. I'm lucky that I get to work with, and sometimes meet, people dealing with all sorts of situations, environments, and even regional challenges. As a dev and DBA, I've never worried about anything other than varchar(). Now I have customers that have lots of languages and other issues that need to be accounted for in their designs.

One of the areas that has become more important in the last few years is Data Privacy and Protection. Between the GDPR and other legislation, and growing concern from customers, many organizations are starting to pay more attention to this area. Less so in the US, where we seem to be behind most of the rest of the world.

I saw a piece recently on the reasons why we might need more data governance in companies. Actually, the piece talks about needing more money for the Chief Data Officer's budget, though I'm not sure most organizations have anyone in that role. A few do, and certainly I've seen some growth in companies worried about this, but it's still a minority.

While regulations might change, and there could be a quick need to improve our processes in this area, I think the bigger issue is competition. More consumers are fickle, easily changing services whenever they are unhappy. More companies are building competitive services, and if you cannot satisfy your customers, they'll go elsewhere. Increasingly consumers are considering data security and data privacy to be more important than in the past.

I'd urge you to think about these issues inside your organization, and try to be better in new projects. Ensure you could comply with the CCPA or the GDPR if necessary. That need could come quicker than you expect.

Steve Jones - SSC Editor

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

Redgate University
 
 Featured Contents
Stairway to Biml

Stairway to Biml Level 7 – Populating the Database for a Custom Biml Framework

Andy Leonard from SQLServerCentral.com

In this next level of the Stairway to Biml, we look at a custom framework in Biml.

Power BI Histogram Example using DAX

Additional Articles from MSSQLTips.com

Companies use a Bell Curve approach to measure performance. As part of this approach they create a histogram. A histogram is a statistical concept and according to Wikipedia it is defined as a graphical distribution of the numerical data. A histogram is made of several bins and bins can be considered a range of values or a benchmark

When SQL Server Performance Goes Bad: Rogue Indexes

Additional Articles from Redgate

Phil Factor explains how SQL Monitor helps focus performance tuning efforts on the tables and queries where 'rogue indexes' might be a significant problem, and then how to identify both 'missing' indexes that might be beneficial to the overall workload, and those that are unused or duplicated, and so are doing more harm than good.

Free eBook: Defensive Database Programming

Press Release from Redgate

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.

From the SQL Server Central Blogs - Resizing Tempdb (When TEMPDB Wont Shrink)

SQLEspresso from SQLEspresso

Occasionally, we must resize or realign our Tempdb log file (.ldf) or data files (.mdf or .ndf) due to a growth event that forces the file size out of...

From the SQL Server Central Blogs - #tsql2sday #130 – Automate your stress away – Getting more SSIS Agent Job information

mrrobsewell from SQL DBA With A Beard

Automation T-SQL Tuesday was started by Adam Machanic (blog|twitter) is hosted by a different person each month. The host selects the theme, and then the blogging begins. worldwide, on...

 

 Question of the Day

Today's question (by BTylerWhite):

 

Updating Python Dictionary Values

I have the following nested dictionary in Python 3: 
people = {1: {'last_name': 'Dactyl',
              'first_name': 'Teri',
              'age': 27
              },
          2: {'last_name': 'Zerd',
              'first_name': 'Liz',
              'age': 22
              }
          }
Which of the following options will allow me to update Teri's last name to set the value to "Dactill" rather than "Dactyl"?

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)

Finding Perfmon Data

I've got some scripts on my SQL Server 2017 server that uses sysperfinfo to read performance counter data. I know this code should be upgraded, but what DMV should I use?

Answer: sys.dm_os_performance_counters

Explanation: The DMV to use is sys.dm_os_performance_counters. Ref: Mapping System Tables to System Views (Transact-SQL) - https://docs.microsoft.com/en-us/sql/relational-databases/system-tables/mapping-system-tables-to-system-views-transact-sql?view=sql-server-ver15 

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
Replication - I would like to know if any one in this group has worked with Qlik attunity Replicate it is a Data Replication Software. Thanks in Advance!
How does sql server agent access the azure storage blob - Good morning all , I must configure an automated backup to an azure blob storage in the backup script I have correctly configured the credential now what right is needed for the sql server agent startup account to access the storage azure blob thank you for your help
SQL Server 2017 - Development
How long will a view stay cached in memory? - I've inherited a stored procedure that is using a view several times to load temp tables. I'm thinking I can increase performance by loading a temp table with the data from the view and then use the temp table instead of the view. Im just not sure if once a view is called if it […]
SQL Server 2016 - Administration
trace flag -T460 not working - So this is probably me being a div. 2016 SP1 I've enabled -T460 in my starting params via SSCM & restarted.  I can see this "applied" in the "registry start up parameters..." line in the errorLog. When I try an insert that results in the "string or binary data would be truncated" error I still […]
SQL Server 2016 - Development and T-SQL
SUM and JOIN 2 columns with different tables but did not SUM Qty - Good day! Need help re SUM and JOIN 2 columns with different tables but did not SUM qty and duplicates row result here's the sample data tables; Transfer Shipment table; TransTO - TransFROM -  ItemNo   -   Desc   -   Desc2   -   VariantCode   -   Qty Location1      HO               Item01         Active      Black […]
Formatting dates returned in query - I have a statement below in a query that is returning the invoiced date as 2020-08-24 22:00:10.493 How can I get those query results in MM-DD-YYYY which I think is format 101?   SELECT I.InvoiceDate
SQL Server 2019 - Administration
Can't delete auto created statistics on SQL Server 2019 - Hi, I'm have sysadmin rights but it is not possible for me to delete auto created statisitcs. I receive the message, that the statistic doesn't exits or I do not have enough rights to do this.   drop statistics [company$Sales Line].[_WA_Sys_00000001_73A22229]; What can I do to delete the auto created statistics.
SQL Server 2019 - Development
How to write query for multiple rows into a single row for different columns - How to write query for multiple rows into a single row for different columns in SQL Server While storing in table, I am inserting like below. CountryIDCityID TownID 10 6 11 10 6 12 10 3 11 10 3 12 10 3 13 11 9 11 11 9 12 11 14 11 11 14 12 […]
Creating a unique Batch ID for Update - Hi There, I'm trying to write a query that sets a batch of rows to have a single uniquely generated ID on the fly. Tried lots of things and just can't get it right. Below are sample scripts to create the table and insert some test data along with two update queries that do not […]
Reporting Services
Condition Based Parameter - SSRS - Hi, I have a situation that I am unable to find any solution by browsing. I have an internal parameter @Category which has to be passed null value to StoredProc if we select @subCategory option "All". If we select any other value in @SubCategory drop down, I need to pass the selected value to Dataset […]
General
Import a large SQL query definition from a text file - The query definition has about 75 lines.     It is part of an Excel VBA routine in which I connect to a MS SQL database using ADO.  One reason to go with an external file is to avoid adding the line break characters such as  " & _  at the end of every line. I […]
Powershell
Need Powershell script to change SQL Server service password - Need sample Powershell script to change PWDS for SQL Server services (on many SQL Servers). We need to modify the SQL Server 'services' passwords (SQL Server, SQL Agent, IS, RS, AS) on several dozen SQL Servers. I am local admin and SQL sysadmin on every server - and I have all current service accts & […]
remove lines from flat file with no header - I have a file that has a delimiter of bar (|) and has no headers. I need a way to remove bad data rows if it meets criteria. Then create a new file with rows removed, and keep a log of the bad rows. This is my criteria for rows I don't want in the […]
Integration Services
Unable to cast COM object of type error using SSIS ODBC Connection to PostgreS - how to avoid Unable to cast COM object of type error using SSIS ODBC Connection to PostgreSQL I want load data from postgres to sql server using ssis package . In ssis solution I have 50 plus dft for loading data from postgres to sql server . source is postgre connecting using odbc connection and […]
Certification
Gaining knowledge - All, I would appreciate some opinions on a few questions. I appreciate that some of it's subjective and I'm not looking for definitive answers, just some advice or opinions. I've had a bit of experience of reading CV's and recruiting staff but not much. I'm currently unemployed looking for a new job. I have several […]
 

 

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

 

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