SQLServerCentral.com Community Update for {date}

Problems displaying this newsletter? View online.

Featured Contents

The Voice of the DBA

What Limits Do You Want in 2019?

SQL Server 2019 is in development, and likely getting close to being released. I mean, it is named 2019, so I assume we're down less than 6 months of time before we start deploying it. One of the decisions that Microsoft will need to make before release is what the costs for each edition will be, as well as the hardware limits involved. I assume other items like OS support and feature mix will also be decided, but those are less important to me after SQL Server 2016 SP1. Most features just work on all editions.

Recently Glenn Berry proposed some new limits. He requests that 2019 Standard edition raise it's core limit to 64 and the RAM limit to 256GB. These would be raises from 2016, where we were limited to the lessor of 24 cores or 4 sockets and 128GB of RAM. We do get 32GB of RAM for In-Memory objects and 32GB for columnstore as well. There were no changes for SQL Server 2017.

What do you think? Are these limits that make sense in a world where hardware advances and a "small" system is much larger than anything we used at the turn of the millennium? Since data sizes continue to grow and most of us want (and need) more hardware, is 128GB of RAM crippling to a small database server? Do you think that more cores are needed to run a Standard Edition server?

I might also point out that raising limits might keep some people on Standard Edition, but it might also get more people to move from SQL Server 2008 to SQL Server 2019, Standard to Standard. At lower limits, when you might be limited to processor and not core licensing, why not stay on 2008 if you can't get a much faster system?

Personally, I think that Microsoft ought to raise limits somewhat. I do think 256GB of RAM makes sense, even if that includes the In-Memory and Columnstore usage. For cores, 24 to 64 seems like a lot, but what about 40 cores? Who cares on sockets, let's make this simple. Cores. These days, no one is going to get 8 sockets at 4 cores each, but if they do, what does it matter? Let them use all of them on Standard Edition.

Steve Jones - SSC Editor

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

Featured Contents

Creating Aliases for Docker Commands in Linux

carlos10robles from SQLServerCentral

In this article you will learn how to create and use alias commands for Docker, to make Docker's command line experience easier and more productive.

SQL in the City Summits – US & Down Under

Press Release from Redgate

Redgate are inviting senior data professionals to attend one of the upcoming SQL in the City Summit events taking place in May and June. If you’re interested in learning how your business can benefit from implementing Compliant Database DevOps this event is for you. Find out who’s presenting and register for a Summit near you today.

From the SQL Server Central Blogs - SQL Server Large Memory Pages

kleegeek from SQLServerCentral

SQL Server Enterprise Edition can leverage large memory pages to reduce the amount of memory pointers required for larger SQL Server deployments. Reducing the number of pointers makes the...

From the SQL Server Central Blogs - Error -2068643839 / 1602 Installing msoledbsql.msi and msodbcsql.msi for SQL Server 2019 CTP 2.5

Solomon Rutzky from SQLServerCentral

(last updated: 2019-05-05 @ 11:55 EST / 2019-05-05 @ 15:55 UTC ) I had gone through the process of uninstalling the now obsolete SQL Server 2019 CTP, and then...

Question of the Day

Today's question (by Steve Jones - SSC Editor):
	Preventing Access
I have created a role for my junior DBAs with this code: CREATE ROLE JuniorDBA ALTER ROLE JuniorDBA ADD MEMBER SallyDev ALTER ROLE JuniorDBA ADD MEMBER JoeDBA ALTER ROLE JuniorDBA ADD MEMBER SarahDBA -- ... I have granted a number of rights to this role: GRANT SELECT ON dbo.UserAccessRoles TO JuniorDBA GRANT SELECT ON dbo.ETLJobHistory TO JuniorDBA GRANT SELECT ON dbo.DBALogger TO JuniorDBA -- ... We are having some issues with a developer and want to prevent SallyDev from accessing the dbo.DatabaseSizeInfo table. What is the best way to do this?
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)

Service Broker Sending Directions

If I create a contract in Service Broken, what are my options for sending directions of my message types?

Answer: SENT BY INITIATOR or SENT BY TARGET or SENT BY ANY

Explanation: There are three options:

SENT BY INTIATOR
SENT BY TARGET
SENT BY ANY

Ref:

Service Broker Basics Part 1 - https://www.sqlservercentral.com/articles/service-broker-part-1-service-broker-basics
CREATE CONTRACT - https://docs.microsoft.com/en-us/sql/t-sql/statements/create-contract-transact-sql?view=sql-server-2017

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

SAN backups vs SQL Server native - Hi, I'm an accidental DBA at a very small company, and I'm sure I'm doing all sorts of things wrong. But I am running transaction log backups on our full recovery databases every 1/2 hour and full backups after hours. Not big databases, full backups take 1/2 hour for all. We're switching servers and SAN […]

Renaming Default Instance (2017) - Hi, We have a scenario whereby a cloud server is provisioned by a hosting company with SQL Server 2017 Web, and set to the default instance. We have an application to make use, but it requires a specifically named instance. At the moment, the hosting company aren't really getting it. We don;t get access […]

SQL Server 2017 - Development

Query hash - Is there any way to calculate the hash for the query which will the same as calculated by the engine?

SQL Server 2016 - Administration

Availabiltiy datases on Always on - Hello! We have setup Always on Availability Group. All the databases are not added for availability, would it still work while building Tertiary AG? Thanks.

SQL Server 2016 - Development and T-SQL

Delete is very slow - I have a table Mytable1 with 735507 rows and this table has 16 columns with about 6 columns with datatype varchar. I am trying to delete about 48,000 rows from this table but it is taking very long ( about 10 minutes ) to delete even 200 rows. Here are the things I have tried- […]

Weekly (Course) Schedule for Students - I have a table that includes student's registered courses with day (1-6), start and end hours (9-21). Basic query is like that: SELECT courseName, courseDay, courseStartHour, coursEndHour FROM courses WHERE studentId = 1 I want to show weekly schedule for a student like that: This is enough hard for me but there is a harder part. […]

Development - SQL Server 2014

SQL Installation problem *URGENT* - Hi I have old PC but all worked fine until few days ago. I use on Win 7 Visual Studio 2013 and SQL Server 2014, and all work just fine. Then I decide to install VS 2015 and all my problem starts. After installation I noticed that SQL server don't work, I try all but […]

SQL 2012 - General

User notices on SSMS - Hi, I manage a server and would like to know is there a way of placing a small message that sits in view of all users connected to a server on the SSMS screen. I'm 99.999% sure there isn't but I just thought I'd ask. Yes, I can find out who is logged on but my […]

how to find which persion have all colorcodes using color table in sql server - Hi I have one doubt in sql server , how to find which persion have all colorcode using colors table. table1: persioncolors table2: personcolors CREATE TABLE [dbo].[colors]( [colorcode] [varchar](50) NULL ) CREATE TABLE [dbo].[PersionColors]( [Name] [varchar](50) NULL, [ColorCode] [varchar](50) NULL ) INSERT [dbo].[colors] ([colorcode]) VALUES (N'Red') GO INSERT [dbo].[colors] ([colorcode]) VALUES (N'Blue') GO INSERT [dbo].[colors] […]

SQL Server 2012 - T-SQL

General SQL Development Question. - Hello Folks, We do have one source system (Read Only) where member information is hosted - contains around 100 fields and volume won't be more than 10,000 rows. We would like to build a logic to accomplish below ones. i just need idea on this (best way to design). I can able to write logic. […]

SQL Server 2008 - General

SQL - Turn Multiple Row values into a String/col by ID - Hi, I am looking for help to understand how I can turn multiple rows, into 1 row as a sting. In hopes to better articulate what I am trying to accomplish, I have provided the following sample code. Any help is sincerely appreciated and thank you in advance! CREATE TABLE #t (CID int, qGroup char(2), […]

Import Large Text File Keep Exact Row Order SSIS - I have a daily file that I need to consume that has 10,000,000+ rows; it is a human readable report. The reason it needs to stay in order is there are multiple rows for each record. I have the code written that parses the file; as a work around during testing I used Ultra Edit […]

SQL Server Newbies

insert trigger - help - Helllo I need whenever a record is inserted on a table it duplicates on the same table, nust changes data on fields This o my table REFER | REF | DESIGN when i insert for ex. 1, 2, teste it shoud insert another line with 2,1,teste I´ve tried with this trigger but no […]

General Cloud Computing Questions

Query Azure AD from OnPrem SQL Server - Hi There, I know it's possible to query an on prem Active Directory from SQL, however is it possible to query Azure AD from an on prem SQL Server. I want to read user information and populate an on prem table. Many thanks

SQLServerCentral.com Announcements

Status Update 10 May 2019 - We're starting to make some progress as the developers are up to speed and focused. Fixes across the last two days: Payment report finished (well, one item I asked about, but it's usable as of now) Scheduler bug fixed - we had some articles that failed to publish, resulting in 404 from newsletter links. Categories/tags […]

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.