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

Daily Coping Tip

Aim to be good enough, rather than perfect.

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.

Help Your Manager

Most of us have some sort of review with a manager on a regular basis. It might be once a year, once a quarter, or even monthly. Some of us like these, and some don't (me), but the review is often a way to assist your manager in evaluating how you are performing in your job. This is quite common, and I've gotten used to this, though I never really like the process.

I do know reviews are important. This is a time when you have an opportunity to shape your career. A good impression here can help you with a raise, a promotion, even the choice of a project or work you want to do in the future. I learned early on in my career that these reviews were important.

I also learned that my manager often wasn't up to date on what I'd done across the last time period. I used to have annual reviews, but even with quarterly reviews, managers have their own career (and review) to worry about, other employees to worry about, and they can lose track of your accomplishments.

I saw a link in the Brent Ozar newsletter listing things that your manager might not know. Not everything on the list would be things that I cover in a review, but these are things to think about as you look to tailor your job to suit you. If you want something fixed or are having issues, make sure you explicitly call these out to your manager. Not imply something is bothering you, but directly state what you want or what is wrong.

Read the list, but for me, the important things are to track the extra things I've done, the things that impact the company, or that help other people. If I save the company money, or better, increase revenue in some way, I want to make a note and bring those notes to my review. If I spend extra time to make someone else's job easier, bring that up.

Your manager often doesn't know the details of what you do across time. Usually, they do track the current tasks, but they often don't remember at review time what you did 3 or 6 months ago. Often I don't either.

That's why I keep notes about my successes. They help me drive my career forward in the direction I want it to move. It can help you as well but start keeping track of things today, as a way to prep for review time.

Steve Jones - SSC Editor

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

 
 Featured Contents

Prepare, Blend, and Analyze Salesforce Data in Alteryx Designer 

JerodJ from SQLServerCentral

The ODBC Driver for Salesforce from CData provides ODBC-based access to live Salesforce data, allowing you to interact with Salesforce data in a range of BI, reporting, and ETL tools — as well as directly using SQL queries. In this article, we demonstrate how to connect to Salesforce data using an ODBC connection in Alteryx Designer to conduct self-service BI, data preparation, data blending, and advanced […]

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 15: The DAX ALLSELECTED() Function

Bill Pearson from SQLServerCentral

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX ALLSELECTED() function, discussing its syntax, uses and operation. He then provides hands-on exposure to ALLSELECTED(), focusing largely upon its most popular use in supporting “visual totals” in Power BI.

Text Mining and Sentiment Analysis: Oracle Text

Additional Articles from SimpleTalk

Oracle has built-in functionality to analyze text. Sanil Mhatre demonstrates how to perform a sentiment analysis on data stored in a table using Oracle Text.

From the SQL Server Central Blogs - SQL Homework – September 2021 – How good is your recovery plan?

Kenneth.Fisher from SQLStudies

Last month I had you create a security standards document. This month we are going to document our recovery plan. ... Continue reading

From the SQL Server Central Blogs - Delaying Code Execution with Waitfor–#SQLNewBlogger

Steve Jones - SSC Editor from The Voice of the DBA

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the rarely used commands for me...

 

 Question of the Day

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

 

The Firewall Issue

What's the issue here? Firewall set errors

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)

Default Time

How long does this statement pause execution?

WAITFOR DELAY '0:1'

Answer: 1 minute

Explanation: The WAITFOR command takes a datetime formatted string as a parameter to use. The default interpretation is hh:mm, which in this case means 0 hours and 1 minute. Ref: WAITFOR - https://docs.microsoft.com/en-us/sql/t-sql/language-elements/waitfor-transact-sql?view=sql-server-ver15

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
Locking and Blocking - Had update query running and select query also running at the same time , but getting time out expired for select query after waiting 30 sec to lock. Update query having no lock and resource consumption 17% IO and CPU. query plan having cluster index seek. Please help out to avoid time out expiry for […]
CU25 cant install because of SSRS - I have a strange issue at a customer of mine that I have never seen before: on a SQL2017 there is a Reporting Services installed as well and it seems this one is blocking the patching of the DB service The version number 14.0.600.1669 is actually a version number coming from the Reporting Services that […]
SQL Server 2016 - Administration
Setting permissions for user to query DMVs without admin rights - What is a rightest way to grant such permissions to a non-admin user? User belongs to a group that has certain limited permissions on the server, with access to only several user databases. The user however needs to query DMVs in Master DB. Is it doable? and what is a good way to do it? […]
the owner of BAK files - Hi All, How do I find out the owner of bak files ? There are some old bak files in D:\ that I want to clean up but thinking it is best to get the permission first thank you    
SQL Server 2016 - Development and T-SQL
Exclude rows where value used in another row - I need to exclude data from a select query where the value of column A is used in other rows and the values of column B are different. Column A | ColumnB PhoneNumber | FirstName ------------|---------- 02038245161 | Jon 02038245161 | Henry 02038881121 | Jamie 02038881121 | Jamie From the above table I want to […]
Is it possible to display XML data in SSRS report tablix neatly and fully? - How can I display XML data in SSRS report from a XML col in table just like it displays in SSMS? Is it possible to see it in SSRS report same way as on the screenshot? Right now it displays only as on the second screenshot, with wrapping, and not clickable. One row takes pages... […]
hierarchy related query - Hello friends. I have a hierarchy table like this: Month empEntityID empID empName mgrID empEntityID1 empID1 empName1 empEntityID2 empID2 empName2 empEntityID3 empID3 empName3 empEntityID4 empID4 empName4 empEntityID5 empID5 empName5 empEntityID6 empID6 empName6 Month contains first calendar date of a month which shows which month a hierarchy set belongs to. Every employee is mentioned in first […]
Development - SQL Server 2014
Perpetual Total - calculate difference between first and last value - Hi, I'm having to calculate a daily total tons from a continually incrementing number  for a few products. I capture these increasing totals every 15 mins , I'm look at the best way to use a select query to achieve this, and  thinking I need to use the first entry for the day at Datetime […]
SQL Server 2012 - T-SQL
get lastname,firstname, middlename as first 3 pipe delimiter last data no need - NAZARE|DEV|T||Current~NAZARE|DEV|T||Previous The above data NAZARE =Lastname , Dev=Firstname T= lastname . Could you please help me to writ in select statement using substring and charindex Pipe delimiter
SQL Server 2019 - Administration
Cross domain authentication - 'The target principal name is incorrect..' - I have problem with windows authentication. I have two domains (Lets say A and B), and server which is at the domain A. It is an default instance on the server and it uses AD account as an service account. What is a little bit odd is that there is a small difference between DNS of that VM and […]
Entire Row to be Unique in the whole Table... - Hi Friends, I am having a need to implement a Business requirement where in each row in the whole table must be unique.Would be grateful if I can get any help from you in achieving this...Thank you in advance! Best Regards, Arshad  
SQL Server 2019 - Development
Assign multiple fields to one variable - Hi I need to write a query / procedure that will create the following string - Column1Name=Column1Value;Column2Name=Column2Value...etc I have no clue on how to do that with sql. In c# or vb.net is quite simple and straight forward. It seems to me that in sql I have to know the columns names in advance, so […]
FullText Search on PDF files - Hi We have an existing solution where we store documents in the database in FileStream tables. The users are allowed to search for content in these documents, using FullText and IFilters in combination we can do CONTAINS searches on document content. This has worked for years, and still do. Adobe has removed their download links for […]
sp_send_dbmail: Failed to initialize sqlcmd library with error number -214746725 - This one is bugging the daylights out of me. We've got a stored proc that does some error checking then sends an email if there is an error. I can get it to work as long as I don't use the @query switch for sp_send_dbmail. As soon as I uncomment that, the code fails. I've […]
Reporting Services
High Report Export Volume - Hi There, I have a requirement to develop a solution to generate approximately 6,500 reports within a 2 hour processing window, and then export the reports in either PDF or Excel format to a secure ftp site.  The source is SQL and the report data is from stored procedures.  Currently this is being handled with […]
 

 

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

 

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