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

Daily Coping Tip

Send a positive note to a friend that needs encouragement

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.

A Virtual Trip Down Under

I had a great holiday last week, getting away from my home for the first time in months. It's been an extra strange time for me as I usually have a number of personal and business trips I've taken by this time, but with the pandemic, I've been at home, like most of you. However, we managed to find a campground open, and we packed up the family, dogs, and horses for a week in the South Dakota hills.

I'm back, and while I won't be getting on an airplane, I am going to travel virtually to Australia this week for quite an action packed Redgate Streamed APAC Edition. I'm slightly disappointed that I won't be able to shake hands with Troy Hunt, but neither will Damian Brady, Greg Low, or Hamish Watson. I was on stage last summer with those three, and I immensely enjoyed the experience.

This year we're holding the event virtually in the Australia time zone, so I'll be working late afternoon and evening my time for the event on Thursday, July 2. Time zones certainly get strange when I do things in Australia, and it's the one place I've traveled where I feel really out of place when contacting this side of the world. The last time I was there, I watched my daughter's evening volleyball game as I was eating breakfast.

I get to deliver a talk, and then I'll settle in to watch everyone else and enjoy the other talks. All of these are expert software developers and data professionals, and I learn quite a bit from them on a regular basis. If you want to spend time later this week, register for the event and join me, wherever you are in the world. The one good thing with these virtual events is that we can attend them if they fit our schedule.

I'm excited to talk DevOps, software development, and, of course, security with the incredible Troy Hunt. This is an exciting week back for me, but also a busy one as I prep for a look at the software challenges down under.

Steve Jones - SSC Editor

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

 
 Featured Contents

Creating a Serverless Database in Azure

Emmitt Albright from SQLServerCentral

Learn how you can create a database in the serverless tier in Azure.

How to Create an Ubuntu PowerShell Development Environment – Part 3

Additional Articles from SimpleTalk

Running SQL Server in a container may seem daunting at first, but it’s easy once you understand the handful of commands needed. In this article, Robert Cain demonstrates how to run SQL Server in a Docker container on Ubuntu.

From the SQL Server Central Blogs - What is Batch Mode on Rowstore in SQL Server?

SQLEspresso from SQLEspresso

Under compatibility level 150, in both SQL Server 2019 and Azure SQL Database, you now can use batch mode for CPU-bound analytic type workloads without requiring columnstore indexes. There...

From the SQL Server Central Blogs - Power BI DAX Dynamic Measures

Steve Hughes from DataOnWheels

Dynamic measures are an effective way to avoid crowding your report with different versions of the same visual without using bookmarks. No disrespect to the versatility of bookmarks, but...

 

 Question of the Day

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

 

Azure Serverless Compute Cost

If my Azure Serverless database is paused from no activity, do I incur a compute cost?

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)

Heap Order

How is data stored the the rows in a heap?

Answer: In no guaranteed order

Explanation: A heap has no guaranteed storage. In general, as you add data, the data gets added in INSERT order, but an insert can be added to any page where there is space. Ref:

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 2016 - Administration
Create view by accessing tables from other server - Hi, Need to create a view in a database in server A by using the tables from other database in server B. Is it possible ? Any suggestions please.   Thank you.
Syntax to QRY XML Data - What is the syntax to Query this XML data to find a statement = "coalesce" or any other text string , within a date range ?? I created a  table EE_Table with Extended Events data in it. It has 1 column, defined as XML, called Event_Data. Something like this? select * from EE_Table where event_data.value('(/event/data/value)', […]
Query Store regressing queries Report: can I get its results without GUI? - The GUI is beautiful and all. Yet only Sr. Prod DBAs can access that, noone else, in our environment. Can I request them to send me that report in any other format than visual/direct access via GUI?  How? is there a ready script for something like that somewhere by any chance? Thank you.
SQL Server 2016 - Development and T-SQL
Efficient nested query to query on string and fetch corresponding PK - Hello, The search text (not exact match) is in excel column and will be passed to sql query to fetch the data from database. I am using vba for querying the database. My sql description column sample is attached herewith. Thanks
Administration - SQL Server 2014
creation of sql authentication login with a specific requirment - Hi All, As an admin we create sql authentication logins for application users. For those logins, we want to give the ability for the user to change the password and should never expire. To accomplish this requirement, what specific permissions we should give for the sql login? Thanks, Sam
SQL 2012 - General
How to add column columnunit dynamically when FlagAllow is 1? - How to add column column unit dynamically when Flag Allow is 1 on table #nonparametric table ? I work on SQL server 2012 I can't add column unit dynamically when Flag Allow=1 as example below I have two rows have Flag Allow=1 family 90AM will be family 90 and family unit AM on two column […]
How to do User Defined Function take input as text and output text and numbers ? - problem How to make UserDefinedFunction on sql server 2012 split column text to two columns . first column include text characters as unit measure only and second column include numbers only in case of integer or decimal etc..? create table #temp ( columnTextNumbers nvarchar(50) ) insert into #temp (columnTextNumbers) values ('3.5A'), ('5.50kg'), ('35.70kg'), ('9m') I need […]
SQL Server 2019 - Administration
SQL 2019 FCI in Azure - Unable to Connect on Secondary Node - Hi - I setup a new SQL FCI in Azure.  Two newly created VMs with SQL 2019 installed.  Cluster validates successfully and i configured the Load Balancer per the Microsoft recommendations. I am able to connect to the SQL FCI from the node it is currently running on (can connect via SSMS or even just […]
SQL Server 2019 - Development
Where to fit CREATE statement in script with MACROS? - Hi All, Not too familiar with Macros at all, but I have adjusted a pre-existing script and I am trying to create a Table from it. The query works fine but I just font know where to fit my CREATE OR REPLACE table statement (CREATE OR REPLACE TABLE Bookings_Monthly AS) Any advice? If its relevant, […]
Calculating Previous and Next Week - Hi ,I do have Year week as below as Integer and I would like to know if we have any best way to calculate the Previous Year Week and Next Year Week . Do we have any formula to calculate it . Thanks in Advance Year Week : 201952 , 201953 , 202001 , […]
General
Does anyone have the Microsoft Auto Index Tuning DB - I have left my old job but cannot find a copy of the Auto Tuning Index DB TSQL that I used to have on all my servers. It was written about 10 years ago I believe by Microsoft people and I took the code from their blog. However I cannot find the SQL to rebuild […]
Integration Services
SSIS XML Parsing Error with Parent/Child Elements with Same Name - I am having a problem parsing an XML file to MS SQL staging tables via SSIS due to the XSD file structure which I may not change.  Here is the XSD format: […]
SQL Saturday and User Group Organizers
Improving PASS - Debate on how to make PASS better. Please keep it civil and actionable. Suggestions needed on 1 Is PASS adding value to community, if not how can we do more? 2 How are user group affiliations working? 3 What are alternates to using an expensive management company, if that is a suggestion. 4 What can […]
COVID-19 Pandemic
Daily Coping 18 Jun 2020 - Today’s tip is to say positive things in your conversation with others today. http://voiceofthedba.com/2020/06/18/daily-coping-18-jun-2020/
Daily Coping 17 Jun 2020 - Today’s tip is to take a photo of something that brings you joy and share it. http://voiceofthedba.com/2020/06/17/daily-coping-17-jun-2020/
 

 

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

 

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