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

Daily Coping Tip

Get outside and notice 5 things.

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.

The Need for 256GB

I have seen a few people call for raising the RAM limit in the Standard Edition of SQL Server. In 2016, Aaron Bertrand voiced this, and for 2019, Glenn Berry asked that the limit be raised to 256GB. In the last newsletter of the year, Brent Ozar asked Santa for a 256GB limit.

I wonder how many of you would really take advantage of that. In the Azure SQL Database pricing table, to get beyond 128GB of RAM, you need to go to 32 cores. For Azure VMs, you need to purchase even more cores.  AWS EC2 VMs require 32 cores to get to 256GB.

How many of you use this many cores for your SQL Server Standard Edition instances? I'm sure some of you do, but is it many instances that require this many cores and RAM without Enterprise Edition? If you do run EE, then is it because you need more resources or because you need some other EE feature?

Certainly, the use of lots of resources is likely something Microsoft considers to be a feature. They want more for licensing when you have a large workload. I don't know if I think this is morally fair, after all the bits are really the same and there's an artificial limit that doesn't allow the use of them with more underlying resources.

As a side note, this has made it into other areas. My Tesla offers me the option for more acceleration if I pay them US$2000. The hardware will already support this, but it's a software unlock for a price. That feels strange.

Across all the instances you have, how many of them have the need for more RAM? Perhaps a better question is whether your organization would allocate more RAM given the cost involved. I still see too many organizations that underspend for hardware when it would make a difference for customers. Of course, many of you might also get better performance if you learned to write better code that efficiently solves query problems.

Steve Jones - SSC Editor

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

 
  Featured Contents
SQLServerCentral Article

Prevent Accidental Data Deletion in Azure Storage Container with Soft Delete Features

arindamxs from SQLServerCentral

Learn about enabling soft-delete for your Azure Storage containers.

External Article

Choosing Between SQL Server Integration Services and Azure Data Factory

Additional Articles from MSSQLTips.com

In this article we look at the similarities and differences of SSIS and Azure Data Factory and provide some insight as to when you would use one over the other.

External Article

The Redgate Advocates Predict… 3 Key Challenges to Overcome in 2022

Additional Articles from Redgate

Read what Grant, Steve and Kathi predict will be the biggest challenges for data professionals to overcome this year.

Blog Post

From the SQL Server Central Blogs - T-SQL Tuesday 146: Where should business logic reside?

Diligentdba 46159 from Mala's Data Blog

I am trying to get started on blogging again this year…T-SQL Tuesday came in handy with a great topic. This month’s host is Andy Yun(t |b). Andy’s challenge for...

Blog Post

From the SQL Server Central Blogs - Architecture – The Perfect Enemy

K. Brian Kelley from Databases – Infrastructure – Security

When I was younger, I always wanted the perfect solution to an IT problem. I remember getting into argument after argument trying to insist upon the perfect configuration, setup,...

 

  Question of the Day

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

 

Cosmos DB Request Units

How is a Cosmos DB Request Unit (RU) defined?

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)

Endpoint Authentication Order

If I want to specify that my database mirroring endpoint for an Availability Group uses Windows authentication first and then a certificate, how do I specify this in the CREATE ENDPOINT statement?

Answer: AUTHENTICATION = WINDOWS CERTIFICATE cert_name

Explanation: If I use WINDOWS option CERTIFICATE cert_name, I can have the endpoint try to authennticate with Windows, and if this doesn't work, try a certificate. Ref: CREATE ENDPOINT - https://docs.microsoft.com/en-us/sql/t-sql/statements/create-endpoint-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
How to reclaim space from a table - Hi All I have 1 TB database and i cant shrink it as it shows zero % free space .. when I checked into the report of disk usage by table .. there is 1 table which has unused space 700 GB . This table has no Clustered index and only has non clustered index […]
dirty select and snapshot isolation - Hello everyone Can anyone explain the difference to me please btewwen ALTER DATABASE test SET READ_COMMITTED_SNAPSHOT ON and ALTER DATABASE [test] SET [READ_UNCOMMITTED] ON GO because in both cases my select works well even if my update is still running thanks
SQL Server 2017 - Development
Need help to calculate Month in integer into Year and Month - Hi, I've this, declare @t1 table ( Id int primary key, HowManyMonth int); insert into @t1(Id, HowManyMonth) values(1, 17); insert into @t1(Id, HowManyMonth) values(2, 37); How to make it output like this? Id | PeriodDisplay ------------------------ 1 | 1 Year(s), 5 Month(s) 2 | 3 Year(s), 1 Month(s) Please help
SQL Server 2016 - Administration
Extended Events - how can I query the location of File Target of an XE Session? - If I know the XE Session name, is there a query to find out what file path is defined for File Target of the session?
SQL Server 2016 - Development and T-SQL
Linked Server UPDATE & DELETE fails . But INSERT & SELECTs work fine - Hello, I have a Windows 2019 machine. I have SQL Server 2016 and the v18.1 version of SQL Server Management Studio. I have created a linked server & I am trying to execute some queries on a remote Db2 server. I am using MSDASQL provider, i.e. 'Microsoft OLE DB Provider for ODBC Drivers'. The INSERT […]
Knowing ERD for Joins and Subquerries - Hi Experts, I am learning and when I want to practice Subqueries and Joins from the database say Adventureworks or T-SQL Information Schema, I am not able to know how to join and how to create an ERD. My challenge in any system is that I need to know the data model before I practice […]
SQL Server 2019 - Administration
Good t-sql script possibly to list partitions and used/free space on Linux - I have quite a few scripts to monitor space on Windows server, but I couldn't find a good t-sql script that can actually list out partition names and space details. Does anyone have one?
SSIS Error when trying to run a SQL Server Agent Job - SQL Server Integration Services was already installed on the target server when I backed up the SSISDB from the source server(ss2016) and restored it to the Target Server(ss2019). I then ran the related sql server agent job that executes one of these packages and I got the following error below. The only recommendation that I […]
SQL Server 2019 - Development
SSIS SFTP - Hi everyone I am trying to create an SSIS package that will access an SFTP site.  SSIS has an FTP task but no SFTP.  I read online that SSIS does not support SFTP directly.  Has anyone ever set up SFTP in SSIS? If yes how did you do it?  I am new to SSIS so […]
tricky query with patterns of consecutive rows - Hi! I'm having struggle with selecting rows, that match "dynamic" rules as described: if there are 10 or more rows containing a value greater than 1000 this is my START signal if there are 10 or more rows containing a value smaller than 1000 this is my STOP signal i want everything between a START […]
Power Query SSIS Error - Hi I am using SQL Server 2019 and Visual Studio 2019. There are two components - Power Query Source and OLE DB Database.  I went to the connection manager and tested each connection.  The system was able to connect successfully for both components.  These "look" ok. I am getting below error when I try to […]
General Cloud Computing Questions
Are all learning resources just rote memorization? - Title says it all, recently got frustrated prepping for GCP's ACE with Qwiklabs because that's all it felt I was doing, just following steps, and for example altho in their Coursera courses they do explain some of the background as to why some of the components exist, I find its still missing why they need […]
General
How to practice OOP in C++ effectively? - I am currently writing a desktop application with Qt and C++. While I have learned some things about OOP from working on this project, I do not feel I am really using the full potential of OOP. I am not creating a lot of my own classes. I generally don't have an idea of what […]
ASP.net C# - Dropdown List - I am working to get a drop down to work in a DetailsView with the intent to show the current value from a dataset, along with other additional values so that users can edit the data.  In this example, this is a for State drop down.  If my current state is DC, than I want […]
ASP.net C# - Dropdown List - I am working to get a drop down to work in a DetailsView with the intent to show the current value from a dataset, along with other additional values so that users can edit the data.  In this example, this is a for State drop down.  If my current state is DC, than I want […]
 

 

RSS FeedTwitter

This email has been sent to newsletter@newslettercollector.com. 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

 

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