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

Daily Coping Tip

Find the joy in music today: sing, play, dance, or listen

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.

Making a Donation to PASS

This year the PASS Summit will be virtual, though not free. Until June 19, the conference will cost $500 for the 3 day conference, $900 with precons, and $349 for a single pre-con. SQL Bits is still scheduled for September, and I wonder if they will move to virtual. Microsoft has moved all events to virtual for the next year, which puts pressure on others. The flip side is Microsoft events are mostly marketing and many other events are fundraisers for their organizations.

PASS reopened their call for speakers, which is interesting. I wouldn't expect any speakers to pull out from the event, but perhaps I'm wrong. Or maybe they're expanding the schedule, since I know time zones will be an issue and I suspect we'll see some broadcasting across the 24 hour clock. To do this isn't free, as the infrastructure and coordination of staff to make an event happen cost money. Microsoft can just lose money on staff, but for PASS, SQL Bits, and other events, they need help. Even with volunteers helping, you need some staff. Staff requires money.

The request from PASS this year is for a speaker to donate their time to create a presentation and deliver it for little to no monetary compensation. They can watch other talks for free, there will likely be some speaker gift, and there is some marketing and exposure from speaking at the Summit. I don't know how employers, clients, etc. view the Summit, but it's on my speaking CV multiple times and I'm proud that I've been able to speak there.

I didn't submit earlier this year when the call for speakers opened. The timing was bad for me, personally, and I decided to forego attending. When the call re-opened, I decided to submit. I am happy to support the community, and a virtual event means that travel and timing is less of a factor.

I have seen some speakers question whether being asked to deliver a talk for free that will be behind a paywall is a good idea. They question if this is a fair trade for their time and effort. I think each speaker can make their own decision. I don't mind if you speak, or if you decide this isn't for you. It is a fair question, and there are plenty others we can debate: the financial structure of PASS, the decisions about the Summit, and the future direction of the organization.

PASS already had a deficit in their budget this year. The Summit will likely generate less money and potentially the deficit will be larger. If I can donate a few tens of hours to build a session and deliver it, and help with the financials of PASS, I am happy to do so. I plan to support a few other events later this year as well, helping organizers where I can to weather this difficult time.

Steve Jones - SSC Editor

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

 
 Featured Contents

Do You Still Want Coping Tips?

Steve Jones - SSC Editor from SQLServerCentral

A simple question, and you can vote by leaving a comment for this article. Do you still want me to include the coping trips in the newsletter after June? When the pandemic shut down much of the world in March, our CEO at Redgate Software asked us to think about what we could do to […]

Basic Git for DBAs: the Basics of Branches

Steve Jones - SSC Editor from SQLServerCentral

Learn what a branch is in git and how you can create these, share them, and begin working with copies of your code.

Considerations for Deploying Azure SQL Database Managed Instances

Additional Articles from Database Journal

Microsoft provides a number of different deployment options for its Azure SQL Database offerings. While most of them share the same characteristics, one in particular warrants special attention from the standpoint of its infrastructure dependencies. That exception is Azure SQL Database Managed Instance, which will be the topic of this article.

Understanding the State of Database Monitoring report

Additional Articles from Redgate

From performance to recruitment, cloud adoption to estate growth, the findings from the 2020 State of Database Monitoring report offer us some key insights into the trends and challenges facing the industry this year. Redgate’s Jamie Wallis unpicks the findings in this latest blog.

From the SQL Server Central Blogs - SOLVED! Untrusted SAS certs after SQL startup

Will Assaf from SQL Tact

If you've tried doing Backup to URL with SQL Server using a Shared Access Signature (SAS) certificate and received this error: Error: 18204, Severity: 16, State: 1.BackupDiskFile::CreateMedia: Backup...

From the SQL Server Central Blogs - An Updated Version of the Power BI Enterprise Deployment Whitepaper is Available

Meagan Longoria from Data Savvy

A new version of the Microsoft whitepaper “Planning a Power BI Enterprise Deployment” is now available. Once again, Melissa Coates (b|t) and Chris Webb (b|t) are the authors. I...

 

 Question of the Day

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

 

The Last Sequence

I create a new sequence object.
CREATE SEQUENCE dbo.DecrmentByOne AS SMALLINT INCREMENT BY-1;
What does this code return?
SELECT NEXT VALUE FOR dbo.DecrmentByOne

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 Datefirst

Where can I find the default DATEFIRST setting for my instance?

Answer: in sys.syslanguages

Explanation: The default used for DATEFIRST is based on the language of your instance. While this can be overridden, the default is in sys.syslanguages. Ref: sys.syslanguages - https://docs.microsoft.com/en-us/sql/relational-databases/system-compatibility-views/sys-syslanguages-transact-sql?view=sql-server-ver15

Discuss this question and answer on the forums

 

Featured Script

Disk space used by the SQL Server instance

Evgeny Garaev from SQLServerCentral

I have found this query valuable. Sometimes you need to see just overall consumption without any detailed information. It is also useful in overall trend analysis and disk space planning.

select (8.0*sum(size))/1024/1024 TotalGB
from sys.master_files;

More »

 

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
Performance Tuning a SQL Server Database in Amazon RDS - Hi Team, Thanks in advance for simplifying the the people tasks by your valuable suggestions. I am being assigned a new task where in I have to analyze a SQL Server DB in Amazon RDS. I am struck with below issues. How to performance tune the Database. Can I just a take a backup and […]
SQL Server 2017 - Development
PIVOT query - Hi I have this query using PIVOT SELECT * FROM ( SELECT a.Mun, l.Name, a.NumberOfRooms FROM Acco as a INNER JOIN look as l ON a.AccoTypeId = l.id INNER JOIN reg as r ON r.AccoId = a.Id WHERE r.RegDate IS NOT NULL AND r.RegDate <> '' and a.Mun like 'CB%' ) as t PIVOT( SUM(NumberOfRooms) […]
Using a PARTITION BY JOIN to Fill In The Gaps in Sparse Data - Hello Trying to convert an Oracle SQL which uses "partition" in Left outer join into SQL server as shown below. select v.table_name , v.program_no , v.column_name , a.creation_timestamp , a.record_key , a.before_value , a.after_value from audit_010_v v left outer join audit_data a partition by (table_name, creation_timestamp, record_key) on a.table_name = v.table_name and a.column_name = v.column_name […]
SQL Server 2016 - Administration
SSRS "My Subscriptions" Fails to Load if TLSv1.0 Is Disabled on the Server - We have noticed in the past that if we disable TLSv1.0 in HKey_Local_Machine\System\CurrentControlSet\Control\SecurityProviders \SCHANNEL\Protocols\TLS 1.0\Server\Enabled (set to 0), most functionality still works in SSRS, but "My Subscriptions" fails to load, giving the not-very-descriptive error: "An error has occured. Something went wrong. Please try again later." Upon changing the setting to 1, "My Subsriptions" works as […]
SQL Server authentication - I see my sql server is NTLM authentication enabled. I am looking to connect using my mac pro laptop now and I am not able to connect to sql servers as they use windows authentication without kerberos so I can't connect from non windows machines. I am thinking to use sql account instead of enabling […]
adding a Select statement to an existing table - I have this table abc. when I script it out it contains Create table and Alter procedure commands. Now I want to add a Select statement to this table, so when I script out the next time it should consist of Create table, Alter procedure and the new Select statement Is there a way to […]
Is there anything in SQL Server that is analogous to Autonomous DB in Oracle? - Or is anything like that is planned to roll out in the SQL Server world?
SQL Server 2016 - Development and T-SQL
In general how do you know which fields to join on between 2 tables? - I know this is a broad question. I have 2 tables (no primary/foreign keys).  In general, with 2 tables, how do you know which fields to join on and who many fields do you use? From what I understand, the more fields you join on the more narrow you are making your data. But do […]
Comparing 2 large tables row by row and date comparision - We have a functionality where in we need to process a large file containing around 1.5 million rows. We insert the data from the file in a secondary table and once this insert is complete, we compare it with our parent table and only insert rows which have changed. The parent table contains around 2.5 […]
Project EVERYTHING is assigned to me. Can I measure Everything via T-SQL? How? - Is it reasonable to roll-up ALL metrics from Query Store to measure 'everything'? and then compare 1 sp  (input param, SP name) metrics with 'Everything else' on server (or should it be by db?)  one stored proc watch is easy via Query Store. But aggregating ALL THE REST ('Everything') for even just one day is […]
SQL Server 2019 - Development
Extracting a Date Properly from a String. - If i have a string of the following format master_20200613220000.bak Then How do i display the Date as 2020-06-13 22:00:00.000 Please Help.  
Hi all, just registered with SQLServerCentral. - Hi all, I am looking for some one to join me in learning and developing a small project.  I have some background on MS Sql Server 2012. If there is some one there with a project or we could find one and learn together,  please let. I  believe the best way to learn quickly is […]
Two Strings compare using t-sql - Declare @Intstr1 varchar(100) Declare @Intstr2 varchar(100) Set @Intstr1 = '1,2,3,4,5,6,7,8,9'   -- This will NOT contain duplicates Set @Intstr2 = '4,6,6,7,7'  -- This string may have duplicates but surely exists in str1 Need a t-sql for finding numbers from Str1 which are NOT in Str2 Please help. Expected output.. @output = '1,2,3,5,8,9'    
General
ISNULL clause with a condition - Hi, I've got the following code to select the period where I have active data: { FIXED : MAX(IF NOT (ISNULL([Qty in tn])) THEN [Period] END)} The problem I have is that the Qty in tn is only null when another column [Data Type] = ACT. How do I modify the above code to take […]
COVID-19 Pandemic
Daily Coping 15 Jun 2020 - Today’s tip is to find a joyful way of being physically active (indoors or out). http://voiceofthedba.com/2020/06/15/daily-coping-15-june-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

 

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