An Overview of STRING_SPLIT() (SQLServerCentral 12/10/2018)

[SQLServerCentral - www.sqlservercentral.com]( A community of more than 1,600,000 database professionals and growing Featured Contents - [An Overview of STRING_SPLIT()]( - [Building Better Test Data with SQL Provision]( - [SQL Server Logical Reads – What do they really tell us?]( - [Ghosts in your Database]( (From the SQLServerCentral Blogs) - [My backup script (where, how, how big, etc.)]( (From the SQLServerCentral Blogs) The Voice of the DBA Microservices for Databases This editorial was originally published on April 2, 2015. It is being republished as Steve heads to the UK today for SQL in the City. I ran into a talented developer last year that was talking about microservices. It's an interesting concept, one the [Netflix has adopted with success](. I was excited about the possibilities of using microservices until this guy said that everything could be a microservice and the day of the RDBMS was over. That was silly, and I'll admit I struggled to remain polite in the discussion. Eventually I had to walk away because the idea of no RDBMS for any application is a ludicrous as the concept of using an RDBMS for every single system dealing with data. It's frustrating to talk with someone that views our industry as too black and white. There are many ways to solve any problem and many problems can be handled by a variety of techniques. However I am intrigued by microservices. It's an area that I want to continue to research, as I suspect that the idea of small, loosely coupled applications, working in a service-oriented architecture, is a great way to scale systems. From scratch. I'm not sure that many of the monolithic, large applications we have in banking, in retail, in supply chain, in a variety of industries are worth rewriting to use SOA concepts. The return just isn't there, as many of these systems can be served with bigger, faster hardware as they upgrade. Microservices are interesting, and I suspect we'll see more of them in the future. I also think that SOA, using messaging services like Service Broker, are a very robust way to build applications. I hope that more developers out there learn about SOA and find ways to start building system that can work well together, but aren't so highly dependent that changes are difficult or stressful on everyone. Steve Jones from [SQLServerCentral.com]( Join the debate, and [respond to today's editorial on the forums]( ADVERTISEMENT [SQL In The City]( SQL in the City Streamed The theme for December 2018's SQL in the City Streamed is Your Journey to Compliant Database DevOps. The schedule includes sessions designed to broaden your skillset, support your ongoing learning, and keep you up-to-date with what’s new in the industry and at Redgate. [Find out more and register for free]( [SQL Change Automation]( CI/CD for your SQL Server database Feeling the pain of managing and deploying database changes manually? Redgate SQL Change Automation completes your database delivery process by building, testing, and deploying the database changes you and your team check into version control. [Try it free]( Featured Contents  [] [An Overview of STRING_SPLIT()]( Steve Jones from [SQLServerCentral.com]() Learn how to use the STRING_SPLIT() function in T-SQL.[More »]()/174123/) ---------------------------------------------------------------  [] [Building Better Test Data with SQL Provision]( In this article, Microsoft MVP Steve Jones shows how SQL Provision can help create test data that complies with regulations that prohibit the sharing of sensitive or personal data, but still looks and behaves like the real deal. [More »]( ---------------------------------------------------------------  [] [SQL Server Logical Reads – What do they really tell us?]( Additional Articles from [SQL Server Performance]() In this article, we will examine this counter’s true meaning and provide examples that prove it can sometimes be quite misleading[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Ghosts in your Database]( Jason Brimhall from [SQLServerCentral Blogs]( Yes Virginia, there are ghosts in your database.  More specifically, there are ghosts in your SQL Server database.  They are...[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [My backup script (where, how, how big, etc.)]( Kenneth Fisher from [SQLServerCentral Blogs]( A while back I wrote about how to find where your backups are. And I’ve also written about I use...[More »]( Question of the Day Today's Question (by Steve Jones): I have this code: DECLARE @s sysname = 'audit.OrderLineItem'; SELECT OBJECT_ID(@s); SELECT PARSENAME(@s, 2); The first SELECT returns NULL in my database. What does the second one return? Think you know the answer? [Click here](, and find out if you are right. --------------------------------------------------------------- We keep track of your score to give you bragging rights against your peers. This question is worth 1 point in this category: PARSENAME(). We'd love to give you credit for your own question and answer. To submit a QOTD, simply log in to the [Contribution Center](. ADVERTISEMENT [Pro Power BI Desktop]( This book shows how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience’s attention. Slice and dice the data with remarkable ease then add metrics and KPIs to project the insights that create your competitive advantage. Yesterday's Question of the Day Yesterday's Question (by Kendra.Little): How can you start perfmon.exe in a way that it remembers the counters that you select, and will display them the next time you open perfmon.exe in the same way? Answer: Just run "perfmon.exe /sys" Explanation: Starting perfmon.exe with the /sys command line option will open it in "stand-alone mode" -- and that's the mode that will remember the counters you use. Ref: Customizing the Default Counters for Performance Monitor - [click here]( --------------------------------------------------------------- [» 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]( : [SQL Server 2017 - Administration]( [Unable to switch SSRS service account to local]( - Hi, I need to switch the ssrs account from domain to local account. Now, sql server configuration manager does not let me... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Administration]( [Logical Drives on a Solid State Platter]( - In the olden days we meticulously separated the system files from data files from log files and from tempdb. So... [AG Listener Names Unavailable for 10-15 Minutes After a Failover]( - I inherited a two node AG on SQL Server 2016 Standard Edition. There are 5 AGs on it, one for... --------------------------------------------------------------- [SQL Server 2014]( : [Administration - SQL Server 2014]( [Issues with SQL backups due to Nodes returning multiple IPs]( - We have a four node cluster (SQL Server 2014 on windows 12) and we recently setup heart beat network on... [Is Mirror upto date]( - Hi there, Is there a script that will tell you how up to date (or not) a Mirror is with the... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 - General]( [Does actual occur?]( - Hi, I am researching about prefetching in Nested loops and can find some articles talk about that. Most of them mentions... --------------------------------------------------------------- [Data Warehousing]( : [Integration Services]( [Flat File with double quotes as text qualifire, comma delimiter and doube quotes in data]( - Dear All, I have flat file that I need to load to SQL. This file is having a text qualifie double... 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](. Feel free to forward this to any colleagues that you think might be interested. If you have received this email from a colleague, you can register to receive it [here](. --------------------------------------------------------------- This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com