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

Daily Coping Tip

Learn a new skill from a friend or share one of yours with them

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.

Taking Stock of Your Career

Yesterday was Thanksgiving in the US, a day where families typically celebrate together and many people give thanks for what is going well in their lives. It's also one of the days when more businesses and services are closed than any other day of the year.

This is the time of year when most businesses look forward and plan the future. It's also a time when lots of individuals may do the same thing, getting ready to make resolutions or attempt to change their lives in the new year.

Today, I want to do something a little different. Rather than taking stock of your career and looking forward, let's look back and find gratitude.

Is there a situation, a person, a job that you were grateful for that helped your career for the better? Who would you thank? What helped you become the person you are today? It doesn't matter if you are an older professional like me or someone starting your career. What are you grateful for in your past to put you where you are today?

For me, there are lots of things to choose from. I've been very blessed and lucky. I've worked hard to take advantage of opportunities, but things have worked out well. There are a few things that stand out in my mind.

First, I got a job interning at a nuclear power plant while in graduate school. That job changed my life. Someone recognized my value and gave me a chance to program, to learn how to run a network, and helped me learn SQL Server (on OS/2). I also met my wife there, so perhaps that's the situation I'm most grateful for in my life.

The other situation was the job that moved me to Denver. It allowed my family to change locations and my kids to grow up in a wonderful place. The job wasn't great, long hours, and I slept in my office far too many nights, but I learned how not to do a lot of things. From poor management, poor software processes, and bad operations practices. It was a tough period of growth that I still value today.

What are you thankful for in your career? Let us know in the discussion today.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

CData AWS Glue Connector for Salesforce Deployment Guide

JerodJ from SQLServerCentral

AWS Glue is an ETL service from Amazon that enables you to prepare and load your data for storage and analytics. With Glue Studio, you can create no-code and low-code ETL jobs that work with data through CData Glue Connectors. In this article, we walk through configuring the CData Glue Connector for Salesforce to create and […]

SQLServerCentral Article

How to filter non-existing records in SQL

aveek22 from SQLServerCentral

Introduction Developing predefined reports in addition to all the ad-hoc queries have been a part of my daily activities. Often I find my stakeholders asking me to prepare reports in which they want to know something that has never happened. It might sound strange, but yeah, that's what their point of concern is all about. […]

External Article

A Q&A with Troy Hunt: What will you learn?

Additional Articles from Redgate

We really enjoyed the insightful, intelligent answers Troy gave to Steve Jones’s questions and invite you to enjoy the fascinating conversation in the webinar which is now available on-demand.

Technical Article

Power BI CONCATENATE Function: How and When to Use it

Additional Articles from mssqlserver.com

In this article we cover various ways join and concatenate data in Power BI by using the DAX CONCATENATE function.

From the SQL Server Central Blogs - SQL Server linked server to .xlsx Excel files

Will Assaf from SQL Tact

A question came up recently concerning whether it was still possible to connect to .xlsx Excel files as  SQL Server linked servers.
Short answer: Yes, it's possible as recently as...

Blog Post

From the SQL Server Central Blogs - Skirmishes with automated deployment of Azure Data Factory

KamilN78 from SQL Player Blog

When it comes to Azure Data Factory deployment, I always have a few words to say. You might be aware that there are two approaches in this terms. I...

 

 Question of the Day

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

 

The Dynamic Data Masking Email Function

If I add the email function to a column like this:
ALTER COLUMN Email ADD MASKED WITH (FUNCTION = 'email()')
If I have an email of "adam.smith@capitalism.org", what is returned by the masking function for users that do not have the UNMASK permission?

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)

System Variables in ADF

How do I access a system variable, say the Pipeline variable, in Azure Data Factory (ADF)?

Answer: @pipeline().Pipeline

Explanation: The @pipeline() prefix is used with variables, separated by a period. Ref: System Variables - https://docs.microsoft.com/en-us/azure/data-factory/control-flow-system-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 - Development
Calculate HR - Please assist me? I would like to calculate:my code: SELECT * from [dbo]. where LeaveTypeName Not In ('paid time off') BETWEEN date(DateApprovedSupervisor) AND date(2001-08-01) Number of team members who have not used a PTO in the last 30, 60, 90 days (include % per 30-day period) - Number of team members who used more than […]
Extract/export embedded files from binary in SQL 2017 Standard - Hi Everyone ! If I run SELECT * FROM [QPulse5Training].[dbo].[RevisionAttachmentItem] I get a generated list of 218 records with a small number of NULL in mixed formats, including PDF, Word, Excel and image files. If I run the following (taken from this web page https://www.c-sharpcorner.com/blogs/export-blobbinary-or-varbinary-from-sql-table-and-save-it-as-a-file - credit where it is due), I get 102 documents […]
Distinct Count - I am using the following code for distinct count, seem to give me the same number for count and distinct count. Please assist? Attached is the file i imported into sql server.
SQL Server 2016 - Development and T-SQL
Error handling/notification with a sql agent job - I have a stored procedure that is returning a set of data from a table and then is populating a summary table with that data. if sussful I am deleting all the data from the first table. if there is an error I do not want to delete the data and notify me if it […]
SQL 2012 - General
How to use group by instead of distinct when execute dynamic SQL query @SQL ? - I work on SQL server 2012 i need to use group by instead of distinct so how to do that please query working without any problem and give me result i need but I need to use group by instead of distinct on last statement executed in exec @SQL and if there are advice about […]
what i do to enhance this statement select into ? - I Work on sql server i have slow transfer data when make select into small number of rows it take too much time my execution plan https://www.brentozar.com/pastetheplan/?id=r1o3p8NOt my query as below : SELECT d.PartID , d.Code , d.CodeTypeID , tr.RevisionID , tr.ZPLID, tr.partlevel, d.FeatureName, d.FeatureValue INTO ExtractReports.dbo.TEqualCodes from ExtractReports.dbo.TAllData d with(nolock) inner join parts.tradecodes tr […]
SQL Server 2012 - T-SQL
problem with UNION ALL query - I have a query that uses 'union all' and returns all the records (including the field 'BillingRateA') from the top query but not the 'BillingRateB' bottom (that field is just blank). If I run the bottom part alone 'BillingRateB' appears. Any clues?: SELECT c.clientname as 'Client', c.BillingRateA as 'Rate', b.billingtypeA as 'Unit', m.SegmentName as 'Business […]
SQL Server 2019 - Administration
Copying database backups to two different locations in Standard Edition - I have a need to write to two different Azure Blob Storage Folders for backups. I know that Mirror To Option is not possible since I'm in standard edition. I don't know if there is a workaround, short of writing to disk and then copying the backups to Azure Blob Storage Folders. Not sure I […]
SQL Server 2019 - Development
Replace text in a string but only if it falls between double-quotes - Hi Guys, It's Friday afternoon and my brain hurts.... TLDR: Given the string: strStmt = "SELECT * FROM " & strView & " WHERE MainLKUPID = #REM " & strAccounts(lngCount) & "#REM " #REM This is a comment How would you replace the #REM with single quotes so that you end up with a string […]
multiple queries - Hello. Is there anyway i can simplify the writing of this queries where the only thing that changes is the date on the three tables and the "datepart" on second table and third table? --table 1-- Create table Report_Es1 (ola1 int) declare @h int set @h = (select Sum(case when [DATA] = CAST(GETDATE() AS DATE) […]
SQL Server 2008 Administration
one job most of time runs successfully, but somtimes failed - My OS is Windows server 2008 R2 enterprise, and SQL Server is 2008 R2 standard edition,  I created more than half year, It ran without any error before this week, but it failed to run sometime since this week. even if I start SQL Server Agent service using NT SERVICE\MSSQLSERVER or NT SERVICE\SQLSERVERAGENT  account, the […]
General Cloud Computing Questions
What's your opinion about Google Cloud SQL? - I wonder what your opinion about Google Cloud SQL is! We are a small company running our MySQL server on one of our vServer and everything runs fine. But we have a few concerns about our project in the future: Backups - we did not implement them yet and I don't want to keep them […]
Reporting Services
Report Viewer Paging Problem - Hiya, I'm using PowerBI on Premise Report Server and Visual Studio 2019. In development I can create reports that preview fine on separate pages. When they are promoted to live,  the Report Viewer gets stuck on 0 pages and I cannot navigate them. After a while (several minutes) the Report Viewer sometimes comes to life […]
Is it possible to assign a random color to a font? - Hello, I am working on a report for which one of its requirements is that at the beginning of each year, the font color in one of its sections changes automatically. I am not sure if this is possible, I have search, found and read a few examples and they all have the colors to […]
General
Recommendations for making a custom image and video filter. - For my CSCI class we made some custom filters in C++ using the stb_image library. I made a filter that doubled the individual RGB values of each pixel, which resulted in a cool/glitched out output image. I wanted to apply this filter to a video, but I don't believe the stb library supports that. Any […]
 

 

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

 

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