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

Daily Coping Tip

Take an action to be kind to nature and care for our planet

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 New Community Summit

The PASS Summit has been an annual event for a lot of my career. I attended the first one in 1999 and most of the rest through the years. After last year's virtual Summit, I was concerned that we wouldn't have an annual event where the most, brightest, and friendliest data platform people came together. Redgate purchased the assets out of the PASS bankruptcy and has committed to future Summits. This year's Summit is virtual, and more importantly...

It's free, and you can register today

Free to attend the main conference, which means you have the opportunity to go to the largest Data Platform focused conference for no charge. Just ask your boss for a little time to learn, get inspired, and interact with your colleagues around the world.. There are still pre-cons that cost money (US$200), but all the proceeds go to the speakers. A great opportunity to learn from experts and support them at a cost you likely won't see at a major event.

I don't love virtual events, and I do hope that we get back to live conferences, but I do like that everyone can come to the Summit this year without asking their employer, or their household, to fund the effort. Microsoft is a major sponsor and will keynote at the event, likely with some exciting SQL Server and data platform news coming. Lots of other sponsors will be there as well, which I'm pleased about because sponsors are an important part of events and user groups in our community.

If you want to know what types of sessions are coming, the best of Summit 2020 is available for you to watch, again for no cost. This year there are three themes, Back to Basics, Reach for the Clouds, and Level Up. I'm glad for the cloud track as the cloud has continued to grow faster than I expected, with so many friends, customers, and clients looking to move portions of their data workloads into a cloud situation. I'm also glad to see the career advancement Level Up track becoming a place of focus, as actively managing your career is something I feel strongly about. Hopefully, I'll get to deliver a session in that track. As of the time I'm writing this, I know I have one session, but not sure if the program is complete.

While Kathi and Grant are managing the process, community volunteers are reviewing, rating, and making choices about sessions. That's one thing I'm glad to see. There is a strong community effort in helping to program the conference. While I know paid professional staff organizes things and configures the platform (we contracted with a few people that have helped run the conference in the past), it's the community that should really help decide which speakers and sessions they want to see. I'm hoping that some of the fun things like networking, the photo walk, and more are a part of the event.

There's no good reason to not attend the Summit this year. Unless you're buried with a deadline the week of Nov 8, 2021, ask your boss for some time, register, and come join me in watching some sessions, chatting with old friends, making new ones, and getting excited about what you can do with data in 2021.

Steve Jones - SSC Editor

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

 
 Featured Contents

Working with Get Metadata Activity in Azure Data Factory

arindamxs from SQLServerCentral

Learn how to gather metadata information about the files being processed in your ADF pipeline.

Testing SQL Server Databases Using SQL Test

Additional Articles from Redgate

During database development, as well as writing SQL, you must also write the tests that prove your SQL code meets all the requirements. The article will help you get started with database testing for your SQL Server databases, by creating and running unit tests against them, as well as static code analysis tests.

SQL Compilations/sec is not what you think it is

Additional Articles from SimpleTalk

SQL Server perfmon counters provide a wealth of information about performance. In this article, Fabiano Amorim shows how current wisdom about one counter, SQL Compilations/sec, can sometimes be misleading.

From the SQL Server Central Blogs - Interview Tip: Know your resume

Kenneth.Fisher from SQLStudies

Seriously. Make a point of reading your resume before submitting it, and again before an interview. I’ve been helping with ... Continue reading

From the SQL Server Central Blogs - SQL Server on Kubernetes Book Published!

aen from Anthony Nocentino's Blog

I’m super proud to announce that Ben E. Weissman and I have published SQL Server on Kubernetes – Designing and Building a Modern Data Platform available now at Apress...

 

 Question of the Day

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

 

The Engine Edition

What does this return?
SELECT SERVERPROPERTY('EngineEdition')

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)

Training a Random Forest Model

I have a data set, m, in R Studio. This is my complete data set, both for training and testing. I want to train this using a random forest algorithm. What is the first thing I should do?

Answer: Split the dataset with m.split()

Explanation: When working with a model in machine learning the first thing to do is split the data set into a training and test data set. Ref: Split data - https://docs.microsoft.com/en-us/azure/machine-learning/algorithm-module-reference/split-data

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
Suppress Backup Messages In Logs - I'm trying to get rid of all backup messages in my SQL logs and I was able to successfully suppress completed notifications by enabling trace flag 3266. However, I'm still dealing with "backup passed" and "backup skipped" entries which quickly clutters the log when performing log backups every 10 minutes on dozens of databases. The […]
SQL Server 2016 - Development and T-SQL
Gap in dates query - Hello All, I need your help in building this query. create table #memb (ID int, eff_dt date, term_dt date, prod varchar(5)); insert into #memb select 1111 , '01/01/2016' , '12/31/2016', 'AAA' union all select 1111, '01/01/2017', '12/31/2017', 'AAA' union all select 1111, '01/01/2018', '03/31/2021',  'AAA' union all select 1112, '01/01/2017', '12/31/2017', 'AAA' union all select […]
Development - SQL Server 2014
Incorrect Syntax near End - Hi if Month(@frDate) < 4 begin SET @ytdfrDate = (SELECT CONVERT(DATE, dateadd(y,-1,@frdate + '-04-01')) end Thanks
YTD Date calculation - Hi I have @frdate parameter. In below condition i want to Set date as '01/04' and subtract 1 year from @frdate if Month(@frDate) < 4 begin SET @ytdfrDate = "01/04/" + dateadd(y,-1,@frdate) end Thanks  
YTD Sale - Hi I have below Stored Procedure . I want YTd column value also. If user enters @frDate = 01/01/2021 and @toDate = 31/01/2021 then YTD value should be from 01/04/2020 to 31/01/2021 If user enters @frDate = 01/12/2020 and @toDate = 31/12/2020 then YTD value should be from 01/04/2020 to 31/12/2020 Create PROCEDURE [dbo].[SpBpGroupWiseSalePurchase] @frDate […]
SQL 2012 - General
Function for converting hh:mm:ss time to decimal equivalent - I have a user defined function that just needs a little tweaking. The first block of code used in a query returns 7 decimal places and when I wrap the code in a function it only returns 2 decimal places. Any clue would help... Thanks! ,CONVERT(DECIMAL(10,2),LEFT([LOGIN TIME],2) ) + CONVERT(DECIMAL(10,2),SUBSTRING(CONVERT(VARCHAR(8),[LOGIN TIME]),4,2))/60 + CONVERT(DECIMAL(10,2),RIGHT([LOGIN TIME],2))/3600 AS […]
SQL Server 2012 - T-SQL
How to get the detailed record and summary value at the same time - there are LineNo, itemNo and qty fields in one table, I want to the accumulative qty (totalQty) for each item and want to the totalqty shown as below picture, I just know one way to get the the result , could you please help me how many ways to get the result, it seems that […]
SQL Server 2019 - Administration
Complete permissions script - Hi Everyone Is there a script that can output a FULL audit of my SQL instance. As in script out: Logins Server roles Server securables Database Users Database Roles Database securables   I have bits and pieces of this but cannot find a complete solution.   Any help is appreciated   Thanks
Is that a reason DBA should Install SQL Server - Hello: I got a question from upper manager and he wanted to know why DBA should install SQL Server? Should Window Server Team install SQL Server? I tried to explain and clarify to him. Would you please give me a good reason why DBA should install SQL Server?   Thank you in advance. Edwin
Returning Database Properties related to "Change Tracking" - The SSMS Database Properties screen has a page "Change Tracking". How can I get those properties via regular SQL? The normal way to return database properties is to use sys.databases or DATABASEPROPERTYEX, but I could not find those properties via either approach. The SQL instance is 2019 - Microsoft SQL Server 2019 (RTM-GDR) (KB4583458) - […]
SQL Server 2019 - Development
T-SQL Unique Index - classification of unique - advice needed - I have inherited a data warehouse with Type II SCD tables. Each row has an entity_identifier (not null), StartDate (not null), EndDate (nullable) and then the entity attributes. When an attribute changes, the EndDate is completed and a new record added with the new StartDate. So far - So good Each table also has a […]
SQL Server 2008 - General
Service Broker limit in SQL - As mentioned in the link below, https://www.codemag.com/article/0605061/SQL-Server-2005-Query-Notifications-Tell-.NET-2.0-Apps-When-Critical-Data-Changes For client-side applications, query notification users should not exceed ten concurrent users , in SQL Server 2005. What is the maximum number of concurrent users allowed while using query notification in  SQL 2008 and above?
General Cloud Computing Questions
Questions about Cloud Computing - I am currently a second year Information Technology student and I aspire to be a Data Analyst or be a DBA and I have currently learned SQL through MySQL Workbench and have created personal projects and I was just wondering as it pertains to cloud computing (Azure SQL or AWS SQL) is it best I […]
SSRS 2012
SSRS 2012 Email Relay question - Hi All, I am trying to figure out if it is possible to send SSRS subscriptions via email directly through our office 365 environment, and I am having issues. I can't seem to find documentation of if this is possible in SSRS 2012 (I know they added it in 2016)., and what settings I need […]
Analysis Services
SSAS Referenced Dimension - Ahoi, i have been looking at the different relationship options the Multidimensional Model offers, because i only have the Regular and the M:N ones in actual use. The one that confuses me is the Referenced Dimension type. From my understand it allows connecting a  Dimension and Facts by using an intermediate Dimension which has a […]
 

 

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

 

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