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

Technology Flows Downstream

A few years ago, I was listening a session on Azure SQL Data Warehouse at an event. At the time, one of the features I found fascinating was the separation of the storage from the compute portions of the service. We could load a lot of data in the system and pay for the storage, but we could spin up and down compute nodes to essentially scale out query processing to match our workloads. Azure Data Lake has something similar, and I was excited.

I wasn't excited about ASDW or ASDL because I don't really use those platforms in my work, and I don't have customers to talk to about those. I think they are useful, just not for me. I was, however, impressed with the technology, hoping that it would be coming in the next few years to SQL Server in the box and Azure SQL Database.

It's coming in SQL Server 2019, or at least, the start of it. We will get compute nodes, managed by Kubernetes, that will query other storage nodes that scale out I/O access. We also get this with Azure SQL Database in the Hyperscale edition, where there will be query servers and cache servers, designed to scale to infinite, or at least multi-petabyte, ranges

I wasn't always sure that the investments in Azure would pay off for the database side of things. It felt like Azure Stack was a natural place to help us manage and deploy SQL databases, and that the contained database work started in 2012 would get pushed by the needs of the Azure cloud, evolving and growing in future versions. We haven't seen those pieces of technology grow, but I do think technology in other parts of the data platform has flowed to the "regular" OLTP database space.

The separation of compute and storage really begins with the SQL Server 2019 era release, and I suspect that's just the first step of how our SQL Server database systems will evolve in the future.

Steve Jones - SSC Editor

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

 
Redgate SQL Provision
  Featured Contents

Using VMware VMDKs for SQL Server Database Cloning

pauls 72822 from SQLServerCentral

Learn how you can clone a database with a VMDK virtual disk to store your data.

How to provision realistic and compliant data to dev – free whitepaper

Site Owners from Redgate

Compare common approaches to provisioning test data to database development teams, and assess how they stack up in terms of delivering realistic test data, managing bottlenecks, and meeting data privacy regulations.

Creating Your First SQL Server Docker Container in macOS

Additional Articles from SimpleTalk

The use of macOS by developers and IT professionals has gained popularity the past few years. Running a sandboxed SQL Server, however, has been difficult. That changed when Microsoft made SQL Server images on Docker available. In this article, Carlos Robles explains how to get started with Docker when running macOS.

From the SQL Server Central Blogs - Benchmarking the VMware LSI Logic SAS Controller against the PVSCSI Controller

Klaus Aschenbrenner from Klaus Aschenbrenner

(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...

From the SQL Server Central Blogs - Common Data Model

James Serra from James Serra's Blog

The Common Data Model (CDM) is a shared data model that is a place to keep all common data to be shared between applications and data sources.  Another way...

 

  Question of the Day

Today's question (by mkdm):

 

Service Broker Disconnected Conversations

I created a simple Service Broker implementation in which the initiating procedure does no further processing after sending the message. Learning that this is an example of the "fire-and-forget" anti-pattern, I query sys.conversation_endpoints and find a very large number of conversations in DI (Disconnected Inbound) state. What two simple changes could I make to correct this?

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

 

Redgate SQL Provision
 

 

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

Basic Functions

I run this code in my R session:

myfunc <- function(x, n) {
        x^3
}

At the R prompt, I now run this:

i <- 5
myfunc(i)

What is returned?

Answer: 125

Explanation: Once I define a function, I can then call this as I would any other function in R. In this case, this function will raise the parameter to the power of 3. Ref: Functions - https://www.statmethods.net/management/userfunctions.html

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
credentials running powershell monitoring scripts - I have about 5 or 6 powershell scripts I use to monitor 300 SQL Servers. I run the scripts as scheduled SQL agent jobs. I just realized I was not successfully auditing some servers because the domain account running the SQL Agent service on my "monitoring" server does NOT have access to ALL servers. What […]
SQL Server 2017 - Development
SQL pivot /unpivot - I have table something like below. Need the table with status1 and status2. How can i achieve that?
How to use Tally Table to allocate quantity? - I have read many great helpful articles on Tally Tables by Jeff Moden, Lynn Pettis, and many others; however I haven't seen one on how to allocate quantities using Tally Tables. Here is how I would do it using Loop (RBAR) logic.  Please give insight into how to turn it into set logic or point […]
SQL Server 2016 - Administration
sp_updatestats permissions issue - Hi All,   while running sp_updatestats we are receiving permissions denied error. But as per below article, if we have db owner access on the database we can run this stored procedure. https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-updatestats-transact-sql?view=sql-server-2017 But even we have db owner privileges on user databases we are getting permissions denied error. please let me know what is […]
Migrating Cubes from SQL 2008 to SQL 2016 issues - I have started this new Topic under SQL Analysis forum. Thought of putting the topic reference here as not many people look under Analysis forum. #3654878 Many Thanks, Vinay
SQL Server 2016 - Development and T-SQL
Split values after semi colon to rows - Hi, I need to split column values after ; to new rows . However receiving Create table #TestSplit ( ID INT, Stops VARCHAR(1000)) INSERT INTO #TestSplit (ID,Stops) SELECT 1,'Procure to Pay x Manage Purchase Orders' UNION ALL SELECT 1,'Procure to Pay x Manage Purchase Orders;Procure to Pay x Manage Account Payable' UNION ALL SELECT 1,'Procure […]
Query web API and return JSON data - Hello, We use a service that provides an API for pulling our real-time data. I'm trying to retrieve that data into a table so I can build some functionality in-house consuming that data. I found a few script examples but I can't find complete documentation on the stored procedures that are referenced. The first call […]
Administration - SQL Server 2014
Distribution List in SSIS - Dear All,   Is it possible to send mail to a Distribution list from SSIS 'Send Mail Task'?   Please advise.
Development - SQL Server 2014
Optimize a stored procedure - I have a stored procedure that is called multiple times to get all the elements necessary to display the page. Sample data: CREATE TABLE #temp (plan_id INT, parentid INT, label VARCHAR(20), color VARCHAR(10), comp_id INT, start_date DATETIME) INSERT INTO #temp VALUES (607, NULL,'abc', 'CDC', 432, '2018-05-22 00:00:00'), (607,NULL,'abc', 'CDC', 432, '2018-05-22 00:00:00'), (607,NULL,'abc', 'CDC', 433, […]
Calling same stored procedure - Hello, I have a web application which assigns a case to a user by clicking on the button "Get Case". On clicking of this button, a stored procedure is called. An existing table containing the CaseIDs is read and one ID from this table is assigned to the user who clicked on "Get Case" Now […]
sqlcmd to export to txt file - not working - First time exporting contents of tables to a txt file.  Need to keep NULLs instead of empty blanks that are generated by export wizard.  So, want to use sqlcmd. Tried: sqlcmd -s servername -d dbname -E -Q "SELECT * FROM [Schema].[dbo].[Inventory]" -s "," -o "\\address.org\vdifolders$\polkadot\Documents\US570333\Inventory.txt" get error: Msg 102, Level 15, State 1, Line 1 […]
SQL Server 2012 - T-SQL
Determine if DB name has numerics - I am writing a script to move through specific databases in our server and if the name ends in 2 digits then I run a select statement  in it. The following returns a 1 if the ISNUMERIC returns true select sd.name, ISNUMERIC(RIGHT(sd.name,2) from sys.sysdatabases sd Where sd.name not in ('master','tempdb','model','msdb') However when I run that […]
SQL Azure - Administration
Cluster-Aware Updating - Is it possible to use Cluster-Aware Updating in Azure? By In Azure I mean on two VMs as IaaS, with always on availability groups between the two providing HA.  
SSRS 2014
SSRS Report Parameters Interactive - Hi, I have a table that has a dept_id, sect_id, div_id, item_id, and description.  The data will be reported on base on the users entry on dept_id, sect_id, div_id and item_id. For some reason I cannot work out the parameter entries in such a way that it is interactive depending on the user input. I […]
SQLServerCentral.com Announcements
Status Update 19 Jun 2019 - My apologies. I have completely slacked off here, but since the 17th of May, I've had 3 trips and 8 events to attend with prep for the site and events, including 3 weeks out of the country. I've been hoping that the site would work and someone kept an eye on things. Lots of work […]
 

 

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

 

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