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

Cloud Native

The cloud is an amorphous thing that isn’t well defined, but we do know that there are various types of services (IaaS, PaaS, Saas) that many of the cloud vendors offer. While IaaS is the easiest platform on which to move our software applications, it is fundamentally limited and lacks the scalability of the other services.
 
PaaS systems offer the largest opportunity for systems that scale up and down, allowing the ability to meet workloads while ensuring cost savings by reducing resources when times are slower. To use PaaS, we often need to rewrite code to be cloud native as most on-premises applications do not run smoothly in the cloud. This often entails different code structure, connection handling, and other technical details in the software development.
 
There is continued pressure to move both application code and databases to the cloud, often because of financial advantages. There can be a cost savings by reducing resource loads, as well as changing from capital to operational costs. Today I’m curious how many of you are moving to the cloud, whether wholesale or in a limited fashion.
 
If you are moving any systems to the cloud, are you rewriting software to be cloud native? Or are you trying to lift and shift systems into an IaaS infrastructure? Do your teams think there is an advantage in rewriting code to take advantage of the cloud or is it too much work and effort? If you are moving to the cloud, are you doing any work to change and improve your database code. After all, a more efficient database will matter in the pay-for-use model.
 

Steve Jones - SSC Editor

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

 
Redgate Database Devops
  Featured Contents

Sorting Months By Number (SQL Spackle)

Jeff Moden from SQLServerCentral.com

Fill in another bit of your T-SQL knowledge by learning how to sort a result set by the proper month order, but use the month name instead.

Avoid running out of Disk Space ever again using SQL Monitor

Additional Articles from Redgate

SQL Monitor not only collects all the disk and database growth tracking data you need, automatically, but also analyses trends in this data to predict accurately when either a disk volume will run out of free space, or a database file will need to grow.

Manage SQL Server Agent History More Effectively

Additional Articles from MSSQLTips.com

In this tip we look at how to build a custom approach to managing SQL Server Agent history data.

From the SQL Server Central Blogs - PASS Community And Mentorship

taboggiano@gmail.com from SQLServerCentral

Mentorship is the influence, guidance, or direction given by a mentor as defined by Webster’s dictionary.  I believe it involved a little more than that.  It also involves investing…

From the SQL Server Central Blogs - Upgrading SQL Server on Linux

Klaus Aschenbrenner from SQLServerCentral

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance…

 

  Question of the Day

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

 

Loading the Thesaurus

If I edit the thesaurus file used in my full-text search process, how do I get the new file to be used by SQL Server?

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

 

Redgate Webinars
 

 

  Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Default Memory on Linux

What is the default memory limit that SQL Server on Linux will use?

Answer: 80% of physical memory

Explanation: The default usage of memory for SQL Server on Linux is 80% of physical memory. Ref: Set the memory limit - https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-mssql-conf?view=sql-server-2017#memorylimit

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.


Cross Joining Queries, Left Joining Queries - I’m trying to add the elapsed time  column to a query, but I’m getting several errors regardless if it’s a cte with the declare before the with statement or a subquery join.  How should the @Time variable be included? DECLARE @Time1 DATETIME   DECLARE @Time2 DATETIME SET @Time1 = GETDATE() SET @Time2 = GETDATE() select […]
Status Update 10 Apr 2019 - I wanted to make a status update, and I’ll try to do more of these, as much for my own mental health as to disclose where we are. As of today, there are 104 issues open in Github. A slice of these (6-10) are infrastructure items related to hardware and tuning settings. Most are minor, […]
Intra-site links (at least to other forum posts)render incorrectly in the forums - When posting a URL to a forum post from this site, the site reformats the link to be the name of the topic. Great. BUT, the reformatted URL has two problems: the anchor to the specific post is stripped off (i.e. the pound sign and the post_id) any BBCode is processed as if it were […]
Blog issues: not syncing changes & missing links for original post and comments - Over the past two days I have updated 2 of my 3 most recent posts (“SSMS Tip #3” and “Differences Between Various Binary Collations”), but the changes aren’t coming though. For the old site I was told that it could take up to 48 hours to sync, but prior to the sync breaking it never […]
Using PIVOT - I need to know how can I use PIVOT , my query SELECT A.HIS_STD_OID, B.HIM_SERIES_ID FROM il_cps_conversion.dbo.HEALTH_IMMUNIZATION_SERIES A INNER JOIN il_cps_conversion.dbo.HEALTH_IMMUNIZATION_DEFINITION B ON A.HIS_HIM_OID = B.HIM_OID WHERE 1=1 --AND STDNT.STD_OID = A.HIS_STD_OID AND A.HIS_FIELDB_001 = '0' AND A.HIS_STD_OID = 'std01000001256' AND B.HIM_SERIES_ID <> 'TD' returns following data set with six rows and I need one […]
Small Rant MSDB.DBO.Sysschedules - WHY IN THE WORLD IS THE ACTIVE START AND END TIME STORED AS AN INT?!   I wanted to create some tlog backups using a script to say make the tlog schedule 15 minutes earlier than the diffs If it was stored as a Time(0) I could simply do a dateadd(minutes,@difftime,-15) but NOOOOOOOOOO I had […]
No markdown? - Pity the new forum uses BCC code instead of Markdown formatting.  the latter is so pervasive these days.
Weird issue with 2012 package and Visual Studio 2017 - In one of the projects I work on, we have several packages that pull from Oracle and write to a SQL Server 2012 database.  They’ve been working for years.  Recently we got new laptops and we’re running VS 2017 with all the usual plugins and extensions for SSDT-BI projects.  While working on one package, we […]
A single query to display the result of multiple date selection in month columns - Hi, If I run the following query it gives me a column with the customer prefix and a column with the sum of all the widgets sold for a particular month (in this case January 2019). SELECT customer.prefix, Count(z.id) as ‘Jan19’ FROM (SELECT ID, customer FROM dbo.widgets WHERE timestamp> ‘2019-01-01 00:00:01’ AND timestamp< ‘2019-01-31 23:59:59’ […]
Replace a NIC on secondary replica in AlwaysOn - Hi all Hoping I can get some assistance from the AlwaysOn/clustering gurus out there! We have a SQL 2016 availability group (asynchronous) which consists of a primary and secondary replica. The secondary replica has some hardware problems which we are trying to resolve. The hardware support people have recommended replacing one of the NICs. First […]
Date to record zero balance for an account version - Hi All, I’m trying to create the last column on the table below which tracks the latest date for a version of an account where the amount is zero, so the date should remain the same as the first time it went to zero until a new version is greater than zero. It the amount […]
SSIS Error: "Please Specify Server Password" - ProtectLevel = EncryptSensitiveWithPassword And I entered the password in the properties box, but get the error when running the scheduled job. In the scheduled job, the @COMMAND value is:   @command=N'/FILE "\"C:\SSIS_Packages\MyPackageName.dtsx\"" /DECRYPT "\"MyPassword\"" /CHECKPOINTING OFF /REPORTING E',   I would really prefer to not have passwords at all, but can’t seem to get around […]
How can I null out all but the most recent records in this table? - I have an old table that contains a sort of history tracking of clients & their info that we’ve imported.  I now need to null out a field named “RecordType” of all prior records for each client EXCEPT the most recent record for that client, but I’m not sure how to do this. In the […]
Trying to avoid granting Sysadmin to SSIS Proxy account - We have an ETL process involves a couple of packages – one that receives a Database backup from and external organisation and restores it to a staging server (this database obviously doesn’t contain any users mapped to logins or accounts in our organisation) – and a second package that queries that tables on that restored […]
Software dev best practices test? - Years ago I remember reading this manifesto almost about how a company should approach software dev and it was originally on this guy’s blog then it became well known and people referred to it as his first name. It was a list of things that healthy dev shops did and you could count up how […]
 

 

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

 

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