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

Daily Coping Tip

Choose a different route and see what you notice on the way

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.

Building for Scale

This year's pandemic has moved a lot of business to the digital world. We see that with increased ecommerce from many companies, including lots of local business, like restaurants, that have embraced online ordering, pickup, and delivery. In many cases, the companies providing these services were able to scale and meet the additional load, which arguably wasn't that high for any individual organization.

However, some services aren't able to handle the loads, especially government services. Recently the Florida voting registration website crashed under a larger than expected load. We've seen unemployment sites crash in the US, the contact tracking website in the UK, and plenty more.

I can understand the challenges of government sites, many of which were built on older technology and rarely upgraded with budget restrictions. Investing in new technology is not only expensive, but it can be a huge challenge to ensure systems work through a transition, especially when many users are counting on services to be available.

I do think that the future of much software development needs to be with a hybrid cloud architecture. There are great government secure options from AWS, Azure, and other providers. However, even if you build software that is intended to be in your data center (or a rented one), you ought to be thinking about how to scale it beyond the machines on which it exists, especially if you provide public facing access.

Whether in government or private enterprises, we see the demand for systems grow and shrink rapidly. You can have incredible success, or face shrinking demand quickly. This isn't like an investment in a large physical plant. The digital world allows us to easily scale up and down, using the cloud concepts and architectures developed over the last decade. Learn about the patterns, and ensure your systems can scale as needed.

Steve Jones - SSC Editor

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

 
  Featured Contents

Generate QR Code® barcodes in an SSRS report with the QRCoder library

Stan Kulp-439977 from SQLServerCentral.com

QRCoder is an open source implementation of standards specification ISO/IEC 18004, which defines the requirements for two-dimensional QR Code symbols. It is a more complete implementation of the standard than the open source QRCode4CS library that was used in a previous article.

Managing Cross-Database Object References

Additional Articles from Redgate

Phil Factor explains cross database and cross-server references, how to find them in your code, and when it's better to avoid hard-coding these references and use synonyms instead.

SQL Server

Additional Articles from MSSQLTips.com

I am new to SQL Server and I have heard the term used in a number of different capacities and in different contexts. So what exactly is it? What are the common components? How does it work? How do people use it? I am brand new to the technology, where do I get started?

From the SQL Server Central Blogs - Consider the Benefits of Powershell for Developer Workflows

Sheldon Hull from Sheldon Hull

Who Am I Talking To

You use bash or python.
PowerShell seems wordy, extra verbose, and annoying.
It’s a windows thing, you say… why would I even look at it.
Pry bash out...

From the SQL Server Central Blogs - Pro Microsoft Power Platform: Solution Building for the Citizen Developer

Devin Knight from Devin Knight

Over the last several months a team of excellent authors, including myself, have been writing a very exciting new book about Microsoft’s Power Platform. We

 

  Question of the Day

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

 

sp_query_store_flush_db

What does sp_query_store_flush_db do?

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)

Valid Languages

What valid languages are allowed in SQL Server 2019 for sp_execute_external_script?

Answer: R, Python, or any language defined with CREATE EXTERNAL LANGUAGE

Explanation: R and Python are available directly, but if you define another language with CREATE EXTERNAL LANGUAGE, you can use that. Ref: sp_execute_external_script - https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-execute-external-script-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 - Development
Create DB List of latest Cumulative Updates - Hi. How can i webcrawl the internet to get the latest CU details and store them in a database. Instead of me tediously manually doing this, i want to automate it, is this possible? I can use either .net, jquery or can it be done in
Stored procedure that runs quickly in SSMS hangs up in SSRS - I'm attaching a WORD document that lists the T-SQL code in the stored procedure that runs in SSMS, but gets "stuck" in SSRS.  I don't see the problem.  Most of the stored procedures I write for my reports are similarly written with 1 or more #temp tables and I don't have problems with them.  Any […]
How do you convert a timestamp into a date - Hi all Can anyone help me turn a timestamp that looks like this: "1994-10-07 00:00:00.0000000" into "10-07-1994",  then into 10-94? I tried cast(DOB as date) and it came back as 1994-10-07.   Any assistance would be appreciated.  
SQL Server 2016 - Administration
Replication sending same change over and again when doing a batch update - Good morning, I recently set up replication on my sql server - Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64) Mar 18 2018 09:11:49 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: ) (Hypervisor) going via AWS DMS, which is then sending the data to a […]
Fragmentation & Statistics - Hi All Was approached with a slow running query. First thing I did was update statistics on the entire DB which improved the performance drastically. The problem is that the performance starts to degrade after about an hour or so at which point I update stats again - I've set up a job to update […]
Sql error log - We have job which is configured to recycle the sql error log on daily basis and its failing with the error DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) SQLServerAgent Error: 32. [SQLSTATE 42000] (Error 22022). The step failed. we renamed the sql error log out file […]
Development - SQL Server 2014
Can I use UNPIVOT - Hi I have a table which I would like to turn columns into rows. create table Customer ( CID int not null, WholeSaler bit not null, ReSaler bit not null, Retail bit not null ) insert into Customer values (1, 0,0,1), (2, 1,1,1), (3, 1,0,0) I would like to get this output CID CustType 1 […]
Table Alerts - I would like to build something as described below. An Insurancetable which has InsurerName, PhoneNumber, InsureAmount and InsureRenewalDateTime I would like to send reminder text messages to Insurer phones everytime they are due on their Insurance at EXACTLY the datetime they are due. What is the best possible way to achieve this from the database […]
How to reduce lock or avoid lock while encoding SQL statement - under active monitor, I found there was very amount of cumulative wait time(sec) for Lock,  now I want to know how many ways to reduce lock or avoid lock while encoding SQL statement, and if there is any way to reduce lock for the database or SQL server setting. many thanks!
Docusign API different UI - We have Apttus via which we use docusign and they use the classic UI of docusign. Now we have enabled embedded signing for certain users and when we invoke the docusign URL, the UI is of the new docusign which is not a consistent User experience. We are using the same account so wanted to […]
Addition of values from two fields - I have an inventory usage table that holds values for different locations and periods. The values are calculated by the ERP so I cannot change the SQL values, but in certain instances, I want to combine the values for two locations into one location and zero the usage for the original location. This would be […]
Azure Data Factory
Data masking using Azure Data Factory Data flows in Pipeline - Does any one have any good videos articles links to on how to do  Data masking of PII information while using ADF V2 though Data flow
Reporting Services
LookUp function weird issue - I AM experiencing a weird issue with the LookUp function. I have a list grouped by certain field. For example employees grouped by city. For each employee i have a columna of the list where i use the LookUp function yo retrieve more info from another dataset. So far everything works as expected. But i […]
? on Setting default value to Year of previous month - Hi, I know =Year(Today) will get me the current 4 digit year. What I need is the Year of the previous month. So if the report is run in January 2021, then the default value is 2020, if it is run in December of 2020, then its 2020   Thanks  
Suggestions
Adjust Canonical url to point to original article - I post on here via my RSS feed. In reviewing the source for the page I noticed the canonical URL is set to the SQLserverCentral website. The canonical URL pointing to my original post is how Google analytics lets me know how many views I've had. Only recently learned about this because Dev.to allows that […]
 

 

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

 

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