Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
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:

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 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

 

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