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

Daily Coping Tip

Notice when someone is down and try to brighten their day

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.

Microservices

Recently I wrote about software trends from 2019 and how applicable they might be today. One of those was microservices, which I don't see implemented that often with relational databases. I do see developers wanting to use them, but I don't see them often with a RDBMS backend.

I did see a piece on microservices, which mirrors that view. Lots of talk about the architecture, but not a lot of implementation. O'Reilly did a survey in Feb 2020, just before the world changed, and the found that only 10% reported complete success, but 54% felt mostly successful, and 92% some success. That's better than I thought.

The respondents are self-selecting, so it's not surprising that there might be some success. It's not surprising that a third of these people are moving over half of their legacy systems to this architecture. That doesn't mean they'll be successful in the move, or that they'll continue.

They also note that containers are important, and I think this might be more the nature that containers lend themselves to microservices. The companies I've know that heavily use containers tend to use microservices, almost as if the two technologies reinforce each other.

I think culture plays an important part in any success, and if I were in an organization, I'd focus on this. Perhaps just like DevOps, with a small team proving some success and using that as evidence to start convincing others to move. However, I'd also need to have a good argument about why we should rewrite applications, or even bet heavily on a new architecture. I've yet to see a good reason why microservices work well with an RDBMS, but I'm open to someone convincing me.

Steve Jones - SSC Editor

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

 
 Featured Contents

Basic Git for DBAs: Managing PowerShell Scripts

Steve Jones - SSC Editor from SQLServerCentral

This next article in the git series looks at managing powershell code in Git.

Date Tables are Great for Users, but Not So Great for Performance

Additional Articles from Brent Ozar Unlimited Blog

If you haven’t used a date table before, here are a couple of primers on how to create one and use it.

From the SQL Server Central Blogs - A Quick SQL Change Automation Build

Steve Jones - SSC Editor from The Voice of the DBA

I was going through a few of the Redgate products with a customer recently and they wanted to perform some validation of the build and release process with SQL...

From the SQL Server Central Blogs - Azure SQL Database Automatic Tuning

Grant Fritchey from The Scary DBA

I really like the automatic tuning aspect of Azure SQL Database. This post is not a full explanation and demo. Instead, I want to point out a small point...

 

 Question of the Day

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

 

Getting File System Volume Info

What is the supported way to get the size of your C: drive on a SQL Server 2019 instance from T-SQL?

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)

Connecting to SQL Server from Python

I want to connect to SQL Server from my Python script. How can I do this?

Answer: import the pyodbc module and use the pyodbc.connect() method

Explanation: pyodbc is the module that Microsoft recommends and supports. Both pyodbc and pymssql include the connect() method. Ref: Python Driver for SQL Server - https://docs.microsoft.com/en-us/sql/connect/python/python-driver-for-sql-server?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
Editions and supported features in SQL 2017 - I am trying to do some research in terms of keeping cost to see if we can go with standard edition instead of Enterprise edition. Based on my research i found that standard edition has some limitation like 24 cores ,128 GB memory, online index create and rebuild, resumable online index rebuilds, Hot add memory […]
When updating INT to BIGINT do rows with nulls matter - Table has 30 million rows, 11 GB in size, I need to alter one column from INT into BIGINT. I need to keep downtime to 10 min max. Presently there are some values in that column, mostly zeroes, these values are no longer needed. If I update the column to be all nulls before altering […]
SQL Server 2017 - Development
Fill in missing Dates for Shift - Hi, I have two tables DimCalendar and DimPersonShift, I want a SQL query which will fill in the missing dates that are not in the DimPersonShift table.   SQL Script to Create Tables DimCalendar and DimPersonShift CREATE TABLE [dbo].[DimCalendar]( [ISOdateKey] [int] NOT NULL, [DateKey] [smalldatetime] NULL, [DayNum] [int] NULL, [WeekDayNum] [int] NULL, [Day] [varchar](9) NULL, […]
Administration - SQL Server 2014
Backup Availability Group Database - I am new to Availability Group, but not new to SQL Server and I want to set up a good FULL and DIFF backup of my SQL Databases Currently we are using the Ola Hallengren SQL Database Backup script\process and I am finding it is not working well for us. I want to create a […]
SQL 2012 - General
How to get all parts from temp table in case it return nothing ? - I work on SQL server 2012 I face issue I can't return data not have relation with function create table #TempPC ( PartNumber NVARCHAR(300), CompanyId INT, Status nvarchar(200) ) insert into #TempPC (PartNumber,CompanyId) values ('9C06031A2R43FKHFT',1233345), ('VJ0805AIR5CXAMT',8433324)   when make select as below : Select t.PartNumber,t.CompanyName,pc.FamilyName,t.Status FROM #TempPC t cross apply [PC].FN_PartCheck_Test( t.[PartNumber],0,1,1,t.CompanyId) pc Where pc.GroupID>-2 […]
Write to sparse file error and ndf files - Hi, We have ABC.mdf and ABC2.ndf and a relatively newly created ABC3.ndf We created ABC3.ndf because ABC2.ndf  was on a 2TB drive and was running out of diskspace. The drive ABC2.ndf  is on is pretty much full now. We are seeing Write a sparse file errors (17053 and 5128) saying there is a lack of […]
SQL Server 2019 - Administration
Always on AG - I was planing to configure AG between 3 servers. So Primary and Secondary Replica 1 on the same location and then Secondary Replica 2 on DR location. Primary Replica - Full, Diff and Log backups & Maintenance Jobs etc. Secondary Replica 1 (same location Sync mode for fail over) -  Reporting purposes and data transfer(with […]
SQL Server 2019 - Development
getdate () brings me a different time than my operating system - Hello, I have SQL Server 2019 installed on a server with windows server 2019, in the operating system the time is 11:10 am but in SQL Server when I give it SELECT GETDATE () it brings 10:10, I don't know what else to check. many of the stored procedures use getdate () and obviously this […]
Duplicate rows when selecting from multiple Phone numbers - I have a query that is intended to select a single alternate phone number from a record (There can be as many as 10 additional numbers for each client). It works fine if there is 1 default phone number and 1 alternate phone (Defined by default = 1 and 0). If there is more than […]
Update many records to a date next week based on a Numeric Day Value - I need to run a stored procedure that will update all records date field (meetingDate) to the following week. For Example: DECLARE @myDate DATETIME DECLARE @dayValue int SET @dayValue = 7 /* If any records @dayValue = 7 (Monday) then update meetingDate value to next Mondays Date If any records @dayValue = 8 (Tuesday) then […]
SQL Server 2008 - General
getdate () brings me a different time than my operating system - Hello, I have SQL Server 2019 installed on a server with windows server 2019, in the operating system the time is 11:10 am but in SQL Server when I give it SELECT GETDATE () it brings 10:10, I don't know what else to check. many of the stored procedures use getdate () and obviously this […]
Sum query 12 month in year - Hello guys, i have table like blue area, how to query get result like green area
Sum query 12 month in year - Hello guys, i have table like blue area, how to query get result like green area
create trigger on view - Hi, is it possible to create Trigger on View ? Version:Microsoft SQL Server 2008 R2 (SP3) - 10.50.6220.0 (Intel X86) Mar 19 2015 13:34:46 Copyright (c) Microsoft Corporation Express Edition with Advanced Services on Windows NT 6.1 (Build 7601: ) (WOW64)   Thank.
Powershell
Remove-Item quirks - I am trying to write a script in Powerhsell to run in SQL Agent to maintain a backup archive.  We want to keep all backups for a month, then delete them, except for those created on the 1st & 15th of the month to keep for a year. Due to a known issue in Remove-Item, […]
 

 

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

 

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