Getting started with SQL 2019 Big Data Clusters in Azure (2020-06-26)

 SQLServerCentral Newsletter for June 26, 2020 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Getting started with SQL 2019 big data cluster in Azure]( - [Cloud adoption rates see increase in 2020]( - [Using SQL Server Profiler to Capture Stored Procedures Executions]( - [From the SQL Server Central Blogs - Non-SQL Tips and tricks – #tsql2sday 127 Rollup]( - [From the SQL Server Central Blogs - My Thoughts on PASS Virtual Summit – An Editorial]( Question of the Day - [Heap Order]( The Voice of the DBA  Daily Coping Tip Be kind to yourself. Treat yourself the way you would treat a friend 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. Annoyances This editorial was originally published on Mar 27, 2009. It is being re-run as Steve is on vacation. Humans are social animals. We like to interact and deal with each other, though that presents its own challenges. Personalities conflict, we have different likes and dislikes, different methods of working, different habits, it's amazing that so many of us do get along well. This is one of the reasons that I hire for a fit with the team first and technical skill second. It's only natural that over time, even those of us that get along well, will get into arguments and disagreements. Often over little things that don't even matter. So for this Friday's poll What are the little annoyances in the office? Do you hate finding the empty coffee pot or having to make the next one? Do you hate the guy in the next cube that loves garlic for lunch? Is it the way that your manager arranges everything on his desk at right angles? I know that there are all types of things that are truly offensive, even illegal or inappropriate, but please keep it clean and professional. Give us those things that are small, things that you can laugh at a little. Or that bug you for no reason. And let us know if you have a way to deal with them. I don't have any great complaints now. Despite [The Best Job in the World]( contest, I think I have one that's competitive for that title. And I have a great environment, working at home. The annoyances I have now are mainly noise-related, kids, dogs, or airplanes while shooting podcasts. When I was in an office, there were a few things that bugged me for no reason. I worked with one guy that liked to come talk to me in my office, but he wouldn't talk. He'd come stand in the doorway and wait for me to initiate a conversation. It was maddening that he'd just come stand there while I was trying to cut code, not have anything really to say or ask, but want to talk. He was a nice guy, and I couldn't tell him to go away every time, and I would try to start a conversation, but that bugged me for quite awhile. Other than that, I don't have anything that really stands out to me. I'm sure there were things that bothered me, but none have stuck with me over the years. So open up a bit, commiserate with others, and hopefully you'll learn to let go of a few things. Steve Jones Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [Getting started with SQL 2019 big data cluster in Azure]( blessonblessons from SQLServerCentral.com Installing and connecting to SQL 2019 big data cluster [Cloud adoption rates see increase in 2020]( Additional Articles from Redgate Usage of Microsoft Azure is up by 15 percentage points compared to 2019 and it remains the most-used cloud platform. This is possibly as a result of increased remote working and the need to no longer rely on physical machines. For more insights into 2020 trends and challenges, download the State of Database Monitoring report here. [Using SQL Server Profiler to Capture Stored Procedures Executions]( Additional Articles from MSSQLTips.com In this article we look at how to capture stored procedure executions using Profiler to help with troubleshooting issues that are occurring from your application making procedure calls. From the SQL Server Central Blogs - [Non-SQL Tips and tricks – #tsql2sday 127 Rollup]( Kenneth.Fisher from SQLStudies I was thrilled to host TSQL Tuesday this month (#127) and I my prompt was non-SQL tips and tricks. Now ... Continue reading From the SQL Server Central Blogs - [My Thoughts on PASS Virtual Summit – An Editorial]( SQLEspresso from SQLEspresso On June 3rd PASS announced their annual Summit for Data Professionals was moved to a virtual format. This is not surprising to those of us in the SQL Server...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Heap Order How is data stored the the rows in a heap? 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) Getting the default language How do you programmatically get the default language for a SQL Server instance? Answer: sp_configure 'default language' Explanation: The default language is available from the sp_configure stored procedure. You can also get this from sys.configurations. Ref: sp_configure - [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 [SSMS: How to save multiple resultsets from same query into 1 result or 1 file?]( - I am submitting an official request for DBA of certain servers to run a script on those servers and give me back the resultset. However the script (the actual script is 3 times larger than the attached and returns 20 more results) returns multiple results, so a DBA will not be copy/pasting each resultset into […] [Availability Groups for failover AND mirror]( - I've got a 2-node failover AG setup. I want to add a 3rd node to be used as a reporting server. That could be read-only, but has to be available all the time. For reasons beyond my control, I can't use replication. The database has no primary keys indexes (3rd-party software design). So, it all […] SQL Server 2017 - Development [SQL Server Fragmentation- Defragment]( - The table consist of around 2 billion record on an average there are 1000K inserts happening daily , we see some slowness in recent days , so while checking the table we saw some fragmentation information. Above is the query i used against my dataware database and observed some fragmentation in the index for some […] SQL Server 2016 - Administration [Creating DB diagram]( - Hi, I was planning to create a DB diagram of a user DB to better understand the relationship however when I right-click on database diagram (please expand the user DB to see this option) I see an alert window saying 'This database does not have one or more of the support objects required to use […] [SQL server 2016 SP2 error]( - Hi All,  am trying to update my 2016 SQL server instance to the SP2. the current version is Microsoft SQL Server 2016 (SP1-GDR) (KB4505219) - 13.0.4259.0 (X64) Jun 15 2019 19:20:12 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows 10 Enterprise 6.3 (Build 18363: ) SP2 setup file : SQLServer2016-KB4549825-x64.exe for some […] [SQL Trace Not Capturing Database Events....EXEC, INSERT, UPDATE...]( - I want to see what Stored Procedures are run when users enter data in a 3rd party product we use. I would also like to see INSERTS & UPDATES to tables. I set up a trace that I have used elsewhere with success, but in this case, it's not capturing any of the events I […] SQL Server 2016 - Development and T-SQL [Help with T-SQL]( - I have a web interface for managing tool rentals for our chapter members. I have a display page that will list all of the tools we have and to flag those tools that are currently being rented out to include the expected return date. The important thing is to know which are available and which […] [How to optimise the table performanace (90 lacs records)]( - Hi, I have a table with 5000 users along with 6 years of attendance data. If I want to retrieve user data from the table it takes time to load. Table Structure Usercode, Rosterdate, Shift code, AttendanceCode Case 1 If i want to retrieve the shift information from 1-jun-2020 to 10-jun-2020 for 5000 users, would […] [Help in Date spans for continuoes and regular dates spans]( - Hello all, I would like to take input scripts and generate output data as given below. output is expected as if member is continuously enrolled without any gap in enrollment get min and max and if there is enrollment gap leave as is. for any given member there are no multiple spans just leave as […] Administration - SQL Server 2014 [OPENQUERY giving wrong result on linked server]( - I have setup linked servers on my SQL Server and choose Oracle as a linked server. SOMETIMES, When I run the query below under the SA username, I get different result. However when I run under my own username I get correct result. I Can't understand this anomaly. The below query returns only one row. The difference occurs in […] [Sum of all Memory Clerks and Total Server Memory (KB)]( - I am trying to understand the memory management of SQL Server. I have a Windows Server 2019 on virtual environment with 64 GB of RAM. I also have SQL Server 2019 installed with Max Server Memory 59776 MB. By using the following query I found the list of all memory clerks: SELECT [type] AS [ClerkType], […] SQL Server 2012 - T-SQL [? ON Parsing an XML Field]( - Hi, I know I've asked this before and got a good link , but can't figure out how to parse this XML field. I would usually parse something like Data.Value('Data/.../..) But not sure how to parse out say "Case" from the field below(SqlParameters)? SQL Server 2019 - Administration [How do I count the objects (tables,views,indexes) for a database?]( - Is there any simple script which I can use to count the user objects in a database? Reason is, I'm planning to do an upgrade from SQL 2008R2 to SQL 2019 & my plan is to take a count of the objects on the old SQL and 2019 so I can compare and see if […] Anything that is NOT about SQL! [SSC Traffic Declining ?]( - Are there fewer posts & replies on SSC these days ? It seems like it. Or are they just spread over more sub forums of the various SQL versions ? COVID-19 Pandemic [Daily Coping 16 Jun 2020]( - Today’s tip is to find the joy in music today: sing, play, dance, or listen.   [RSS Feed]([Twitter]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -