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

Daily Coping Tip

Plan a fun or relaxing activity and make time for 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.

New Old Architectures

Many years ago I was starting in a software development role using dBase and Clipper/ I needed to upgrade a DOS based dBase program to Clipper to take advantage of some graphical libraries. Around this time, we were also moving many clients machines from DOS to Windows 3.1, giving them a GUI experience. Also, to the dismay of the management, access to Solitaire. One of our early jobs was to remove that game and Minesweeper from installs.

In any case, I started to experiment with compilers that would allow Clipper programs to run in Windows as native apps. This meant moving to a more event-driven style of programming instead of the procedural way that DOS programs worked. This change was a paradigm shift for me and I spent many hours at home experimenting and trying to understand event-driven programming.

It's much easier to build a Windows app now, with many frameworks and libraries that handle the low-level events. However, the idea of using event-driven programming can be important in many distributed applications. When we work on the request-response model, it's easy for a failure or problem to create a poor experience for the user, especially if there's an intermediate layer between the client and the data. Certainly, there are retry and error handling techniques, but far too few developers implement them in a comprehensive way.

I saw an article that introduces the idea of event-driven architectures as something you would want for microservices applications. It's a good read that helps you gain an understanding of how this architecture would work. I'd recommend this to data professionals, as I expect more of us will encounter developers wanting to implement microservices as a way of magically making your software better. They might even want to implement a broker and queue system in SQL Server.

There are many ways in which you might implement this type of system, and many technology choices, but an understanding of the overall concepts might help you guide developers to choosing an architecture that makes your life easier rather than harder. Event-driven architecture and microservices aren't magically going to make your application run better. They could easily create bottlenecks that cause your phone to ring and ticket queue to grow.

It's helpful to learn about the things developers want to try and build. They get enamored by new technologies, some of which are amazing. Some aren't, however, and some knowledge can help you point out potential problems and influence decisions. We all want better software, and as data professionals, we want to have intelligent conversations about how to get better software built.

Steve Jones - SSC Editor

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

 
 Featured Contents

Array and Custom Data Types in PostgreSQL

sabyda from SQLServerCentral

Introduction Just like every other database, PostgreSQL has its own set of basic datatypes, like Boolean, Varchar, Text, Date, Time, etc. We can easily store data like numbers, characters, date, time, etc. using these supported datatypes, but what if we need to store multiple data elements in a single column? Suppose we are storing the […]

Oracle sequences – 12c features including “identity”

Additional Articles from SimpleTalk

Oracle added several enhancements to the sequence object in version 12c, including an “identity” column feature. Jonathan Lewis explains how to work with these new features.

Register Now For PASS Data Community Summit 2021

Additional Articles from Redgate

Registration is now open for our free and online data platform conference. Join 1000s of your data peers at PASS Data Community Summit and get access to up to 5 days of training, sessions, networking activities, and events. This year's program has been carefully designed to help you achieve your goals, wherever you are in your data career.

From the SQL Server Central Blogs - The sysname datatype defaults to not NULL.

Kenneth.Fisher from SQLStudies

The other day I was creating a table to store some metadata. Since the metadata I was collecting (sys.databases.name for ... Continue reading

From the SQL Server Central Blogs - AWS BYOC – Bring your own SQL Server cluster with AWS EC2 and SIOS

david.bermingham from Clustering for Mere Mortals

Originally posted on DataSteve: Introduction They are multiple options to implement HADR solution for SQL Server in AWS public cloud. The easiest way to do that is to use...

 

 Question of the Day

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

 

Row and Page Compression Facts

Which two of these are not true about Row and Page Data Compression in SQL Server 2019?

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by Evgeny Garaev)

Migrate databases from SQL Server to SQL Managed Instance

I want to migrate my multi-terabyte database from on premises SQL Server to SQL Managed Instance in Azure. Which technology will help me to achieve this?

Answer: Log Replay Service

Explanation: The Log Replay Service (LRS) is a cloud service that's enabled for SQL Managed Instance and is based on SQL Server log-shipping technology. The Azure Database Migration Service and LRS use the same underlying migration technology and the same APIs. Ref: Log Replay Service - https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/log-replay-service-migrate

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
What other useful DBA reports do you suggest? - What other useful DBA reports do you suggest? Maybe something we would run every month or so to check that our environment is configured/running optimally. We have these so far: see screenshot. I also already have (adding soon)  certain reports on block leaders and Waits report based on sp_whoisactive,  report on 'Worst of the Worst […]
SQL Server 2017 - Development
SSIS - Write table to multiple files - Hi there, everyone. I have an SSIS package where I have to write a large table to smaller csv files. I have created a stored procedure as below that is called by an OleDb Source inside a workflow task. This then needs to write each result to a file. I'm very confused as to how […]
Speeding up Query - Hello, I am new to sql and learning my way around writing views for our company. Any tips and tricks to make this query a little faster or streamlined? SELECT TOP (100) PERCENT ord.orderid, ord.lt_orderid AS LTOrderID, ord.datetimecreated, ord.BookedByDT AS DateTimeBooked, us.firstname + ' ' + us.lastname AS BookedByStaffer, ord.VoidDT AS DateTimeVoided, ord.CancelledByWho, ord.voidreason AS […]
Need help sorting based on 2 different column DateTime - I've this table and data as following, CreatedDate CANNOT NULL. LatestRepliedDate can NULL CREATE TABLE [dbo].[IncidentMasterSimulation]( [Id] [int] NOT NULL, [IncidentDate] [datetime] NOT NULL, [IncidentDateDisplay] [nvarchar](100) NOT NULL, [HowLong] [nvarchar](100) NOT NULL, [IncidentNo] [nvarchar](100) NOT NULL, [ProjectName] [nvarchar](100) NOT NULL, [Categories] [nvarchar](100) NOT NULL, [PriorityLevel] [nvarchar](100) NOT NULL, [IncidentDescription] [nvarchar](100) NOT NULL, [CreatedBy] [nvarchar](100) NOT […]
SQL Server 2016 - Administration
Resource Monitor - Performance Issues - Hi. Last Weekend I have migrate a server with SQL Server 2016 ENT to another machine, and since then, I have facing frequently slow performance issues, the server become unresponsive sometimes. And always I see this message on Windows Event Viewer when peformance degrades. Resource Monitor (0x2290) Worker 0x0000031D8EE88160 appears to be non-yielding on Node […]
How to get a SQL/CSV list of SCOM alerts and rules - Hello experts, I've been tasked with tuning SCOM alerts for our database environment. Getting the alerts in emails is a little overwhelming and hard to manage. I don't see a way to export a list from the SCOM console, where I have to click through alerts one by one. Does anyone know how I can […]
SQL Server 2016 - Development and T-SQL
Dictionary Lookup - Hi I have hundred million ID, NAME pairs stored in SQL Server as a table that is accessed by C# code, which has a responsibility to lookup NAMEs corresponding to million IDs at a time.    C# code has these million IDs stored in an array, before invoking SQL module. Columns of the SQL table: […]
Administration - SQL Server 2014
Reclaim disk space after truncate - Hello, We have truncated a huge table (50+ million) rows in sql server which was created for testing purpose. However the disk space is not released back. Any pointers on how to reclaim the disk space after truncating without shrinking database?
Development - SQL Server 2014
how to get quantity from yesterday 6pm till today 6pm - Hi, I am looking to create a case statement that gets different quantities. For example, I would like to see how many orders were created between 6pm yesterday till 6pm today, how much created between 3pm yesterday till 3pm today, and how much was dispatched between 3pm yesterday till 3pm today. I created this case […]
SQL 2012 - General
SQL 2012 Service Pack 4 - Cant get TLS 1.2 to work - Hi all, I'm pulling my hair out here trying to get tls 1.2 connections to work from our webserver to the database server. Our 2012 server is patched to service pack 4 so it should be 1.2 enabled. The SQL server native client which is used for the connection is at version 11.0.7462.06 (I don't […]
Database Integrity Issues - To avoid a lot of contention during peak business hours we separated our integrity checks into weekday and a weekend run.  During the week we do a PHYSICAL only and on weekends when activity is lesser, we run a full blown integrity check.  While it appears to be inconsistent, sometimes we get errors for a […]
Rounding problem (?) using DATEDIFF (minutes) - I have a query that is using DATEDIFF to calculate the number of minutes, of course as an integer, but I may need the extra precision of showing this as a decimal (?). Also I'm looking for a way of summing the time based on "EmpID" (using CTE?): SELECT T1.[EmpID], Convert(Datetime,T1.[Time]) AS [Time], MIN(Convert(Datetime,T2.[Time])) AS […]
SQL Server 2019 - Administration
SQL Server 2019 Distributed Availability Groups - Hello, I am attempting to create a SQL Server Distributed Availability Group in my Azure EC3 environment.  When I attempt to alter my Distributed AG on AG2 using the below command, I get an error as shown below the command. ALTER AVAILABILITY GROUP [WOASQLDISTAG]JOINAVAILABILITY GROUP ON'WAOAG1Hfv96xWgv' WITH(LISTENER_URL = 'TCP://WAOAG121jAavqBc.WAOAG1.com:5022',AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT,FAILOVER_MODE = MANUAL,SEEDING_MODE = MANUAL),'WAOAG2cJ22S7mQO' […]
SQL Server 2019 - Development
How to split Xml columns or Json into records - I have to import every days from 1000 to 100000 records. Bulk insert create one record with the complete xml file. its great an very quick. Can we create directly with a bulk insert one record per order, and one column for the xml ot he order. Or how can we do after bulkinsert, to […]
Reporting Services
Toggle Item Showing First Row of each group and not collapsing all - If I don't use the Toggle Item and just set detail to Hidden = True, all detail rows are hidden.  If I then add a Toggle Item of Textbox that's in the group header, it works, however, it always now shows the first row in each group and the + sign then will show all […]
 

 

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

 

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