Count the Number of Weekend Days between Two Dates (2020-10-16)

 SQLServerCentral Newsletter for October 16, 2020 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Count the Number of Weekend Days between Two Dates]( - [Dynamic Data Unmasking]( - [From the SQL Server Central Blogs - T-SQL Tuesday #131–An Analogy]( - [From the SQL Server Central Blogs - Publish Database Fails – Script File could not be found]( Question of the Day - [Stopping Compute in Azure VMs]( The Voice of the DBA  Daily Coping Tip Thank yourself for achieving things you often take for granted 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. Career Goals and Inspiration Many of us start working in technology because we enjoy programming or software or data or some other aspect of computing. We usually have some excitement that gets us motivated to start learning or apply for a job. Over time, we may move our area of focus, pick up new platforms, change jobs, and more. I'd like to think that most people actively make choices, rather than fall into the next situation, but I see the latter more often than the former. People take jobs quickly, when offered, even if the opportunity isn't one for they were aiming. This certainly isn't all bad, as there are times when we get opportunities we weren't expecting. We may not realize what possibilities are available. However, I do regularly see people not thinking about the next step in their career until they need a job or they hate the one they are in. With that in mind, asking you to think about where you might want to go or what to achieve, I have a question for you. What things that you've seen others do in their careers do you want to do? If you look at people you read about in the media, or see speak at an event, or hear about from friends, are there things that impress you? Are there jobs, roles, projects, or something else you'd like to accomplish? I think there are some neat goals that Brent has written about in [his Epic Life Quest](. These are bucket list items, and it's a mix of business, career, and personal goals. I've had a similar bucket list, but I let it go and only started to rebuild it this year, along with my partner as we think about our future together. I will say that one of my big goals was speaking at the Ignite (formerly TechEd) conference. That was one of the biggest events in my industry, and I wanted to get there. I did get accepted, but a surgery required me to cancel, which was disappointing. Still, it's a high point of my career. I still have a few private goals that I am aiming for in my career, but we'll see if I get them. If you don't have any, perhaps this weekend is a good time to stop and think of a few. You don't need to set them all, or even commit to them, but just start actively managing your career and make a few goals. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [Count the Number of Weekend Days between Two Dates]( Adam Aspin from SQLServerCentral.com Handling weekends can be tricky in SQL. This article shows you how to Count the Number of Weekend Days between Two Dates [Dynamic Data Unmasking]( Additional Articles from SimpleTalk The SQL Server 2016 dynamic data masking feature may seem like a great way to obfuscate data for downstream systems like dev and QA. Joe Obbish shows us that the data can be “unmasked” with T-SQL statements, so it’s not secure against anyone who can write their own queries. From the SQL Server Central Blogs - [T-SQL Tuesday #131–An Analogy]( Steve Jones - SSC Editor from The Voice of the DBA This month the T-SQL Tuesday invitation is from Rob Volk, the last of the crew that I pushed to host last year at a SQL Saturday. I managed to... From the SQL Server Central Blogs - [Publish Database Fails – Script File could not be found]( Koen Verbeeck from Koen Verbeeck A small blog post for anyone who stumbles across this issue (and for my future self, should I forget the solution). I was working on some tables in SSDT...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Stopping Compute in Azure VMs I have created an Azure VM, but I don't need to use it for the next two weeks while I am on vacation. What should I do to reduce the cost of my resource as much as possible, while making it easy to restart later? 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) Enabling Container Availability Groups I am running a couple of Linux containers with SQL Server. How do I enable the Availability Group option? Answer: Set the MSSQL_ENABLE_HADR value to 1 Explanation: There is an environment variable, MSSQL_ENABLE_HADR that you set to 1 to enable the feature. Ref: - Availability Groups with Docker Containers - - Linux Environment Variables - [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 [Set permisson user allow connect with application, don't allow connect with ssms]( - Hello, guys. I use .net to code, can i set permisson a sql user only can connect in connection string in .net code, and not allow that user login with ssms ? [Maint Plan Failing after 'sa' Disabled]( - I have 4 Maint Plans, 1 of which fails because 'sa' is disabled, but I don't see 'sa' specified in the plan. It rebuilds indexes, updates statistics, deletes old backups, then takes new backups. The other 3 Maint Plans just run DIFFS and T-Log backups. All 4 Scheduled Job Owners are a Windows account. On […] SQL Server 2016 - Administration [RING_BUFFER_RESOURCE_MONITOR - IndicatorsPool?]( - Hi all, i've been looking into an odd issue with possible plan cache memory starvation (SQL couldn't generate a query plan prior to timeout for unchanged procs that happily compliled previously) , and spotted quite frequent RESOURCE_MEMPHYSICAL_LOW events. IndicatorsProcess and IndicatorsSystem are both 0, but IndicatorsPool is 2, and I can't find any information around […] [Always On Availability Groups Issue]( - Hi, I see couple of below errors for 2 sql server instances i.e. primary and secondary. When I see the dashboard, it displayed the state as critical and after few minutes it turned green (I mean the databases we are online and synchronized). I do not see any databases on both the instances in recovery […] SQL Server 2016 - Development and T-SQL [A real challenge and I need suggestions on efficient ways to solve it]( - I have a need to determine the site of cancer given some complexities. Each cancer patient has up to 4 diagnosis codes with the first being the primary. I currently have a mapping table that is capable of mapping up to two values to a result value. Currently I only check the primary diagnosis to […] [Varchar to datetime]( - Hi, How can I convert SCHEDSTART varchar(25) '2020-06-07-12.30.00.00000'  to datetime '2020-06-07 12:30:00.000' SELECT convert(datetime,(left([SCHEDSTART],10) +' ' + left(Right([SCHEDSTART],14), 12) ), 127) didnt work. Any help ? Administration - SQL Server 2014 [PBM - result_detail column in syspolicy_policy_execution_history_details]( - Hello, we use PBM to monitor last full and last log backup. PBM created, nothing special so far. We created a stored procedure and a job querying syspolicy_policy_execution_history joining syspolicy_policy_execution_history_details to get the result of the PBM and send it as e-mail. So far so good. But we want to include the expected result in […] SQL Server 2012 - T-SQL [using parameter and not using parameter , the result is different]( - declare @YYMMDD DATETIME set @YYMMDD='2020-09-23 00:00:00.000' select CONVERT(VARCHAR(6), '2020-09-23 00:00:00.000', 112) , CONVERT(VARCHAR(6), @YYMMDD, 112) same value, when we use parameter to pass the value, and not using parameter, the result is not same, what is the reason ? thanks!      SQL Server 2019 - Administration [How does dns determine what ip to resolve to in an multisubnet AG?]( - When a SQL Listener is created on a Multi Subnet environment 2 x ip addresses are assigned. AG Name - SQLAG1 AG Listener Name - SQLAG1-LI 10.0.0.1 10.0.10.1 I have given the ip addresses above for example. In DNS there are 2 x entries for the SQLAG1-LI one for each of the IP addresses. A […] [SnapCenter Server Backup for SQL]( - Hello, do you have any experience with SnapCenter Server 4.3. Can we say that is a valid backup? can we use like a primary backup? I have some testing now, and I am afraid how is working with this web app. Thanks [I've lost the ability to connect to my SQL 2019 instance]( - On my home Windows 10 Professional desktop PC, I've got SQL Server 2019 Developer Edition installed. I thought I had mixed mode but am not so sure. A month or two ago I had problems with my Windows profile - it became corrupted. So, I disabled it and created a new Windows Profile. I thought […] SQL Server 2019 - Development [\'DBMS_DATA_MINING\' is not a recognized CURSOR option]( - Is DBMS_DATA_MINING available in SQL Server 2019? This is error: 'DBMS_DATA_MINING' is not a recognized CURSOR option Analysis Services [Where is the AdventureWorks 2008R2 Analysis Services project download?]( - I need the 2008R2 version because I want to climb the Stairway to MDX and in Level 1 it says: Consider working, therefore, with 2008R2, if at all possible: learning the basics of MDX is challenging enough for most that are new to it, without the additional distractions imposed by working with older releases. In […] Integration Services [SSIS Package that updates two databases on the same SQL Server instance]( - Hi, I have a large script that is querying and updating two databases on the same SQL Server instance (one client database and the MSDB). I'd like to publish this script in an SSIS package, but when I do so it complains that I don't have authorization to update the MSDB database. I have created […] [SSIS package error on remote database]( - hello everyone, so i have created a SSIS package that i want it to run on another server, so example below: Server A is running the SSIS package, and the destination is Server B, that i want it to run under a certain account, like either the network service or system service, which has the […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -