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

Daily Coping Tip

Show your appreciation to people who are helping others

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.

Returning To An Employer

I've had a number of jobs in my career. In many instances, I left on good terms, and I'd go back to the organization if there was a job that suited me. I'd like to think that many of these organizations would rehire me if I applied, as I did good work and had success. I've always been pleased when someone is disappointed at my resignation.

Intel had a large layoff in 2015/2016 where over 13,000 employees were dismissed. The CEO at the time implemented a no re-hire policy, meaning those who were laid off, or I'm guessing those that quit during that time, were no eligible for employment in the future.

That policy has been rescinded, quietly, as the company is struggling to find qualified and experienced staff. I think quite a few companies are in the same situation, and they all are competing for good employees. That's good for us workers, if we have a good reputation, brand, and skills, and likely will lead to higher salaries.

I see both sides here. Certainly the people that an organization decides to let go would likely be the lower performers, those that don't get along with others, or perhaps those that make too many mistakes. However, I've been through layoffs, and I know that those aren't the only people selected for termination.

Managers dislike some people and will let them go. Sometimes managers like someone and keep them, despite them not being as high a performer as others. Workers with other opportunities, sometimes the best workers, might lobby or volunteer to be laid off and get a severance package, knowing they can easily get another job.

I think most blanket HR policies that don't allow for flexibility are a poor idea.  There might be some hard rules, like we don't hire people with financial crimes to work with money, but there should be few of these. While most times there are valid reasons not to hire someone, we ought to review individual cases and make a decision about that person.

I resigned one job in anger because of an individual (who later quit themselves). I would, however, return to the company and work with many of the other people employed there if I found a good position. Actually, the people almost always matter to me, not the job itself. I value who I work with more than what I do.

My view is that technology is still one of the best jobs you can take, doing physically easy work for good compensation solving interesting problems. It can be stressful and a burden at times, but many other careers include those same challenges, often without a better compensation-to-effort ratio.

I am a big believer in finding a great job in your career field that suits you. Doing that takes work, and it takes regular effort to both improve your skills and your brand. Networking matters, whether looking for a new job or avoiding a layoff (or asking to be laid off). Showcasing who you are helps, especially when many other candidates might want the same position you do.

Whether we are in a labor market of high demand or high supply, you want to give yourself the best chance to land that dream job. Work on your skills, your brand, and actively manage your career. With a little luck, you'll wind up with an amazing job for you, just like I did.

Steve Jones - SSC Editor

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

 
 Featured Contents
Stairway to Columnstore Indexes

Stairway to Columnstore Indexes Level 2: Columnstore Storage

Hugo Kornelis from SQLServerCentral.com

To fully appreciate just how different columnstore indexes are, and why work so well in reporting and online analytical processing (OLAP) workloads, but not for online transaction processing (OLTP), we must first look at the traditional “rowstore” indexes.

External Article

SQL Monitor: On-demand demo [Watch now]

Additional Articles from Redgate

Haven't seen SQL Monitor in a while? If you'd like to see how it enables you to always have the answers to the health of your estate, and proactively find potential problems before they impact your users, here's a 30 minute demo for you to watch whenever it suits you.

External Article

How to tell what SQL Server versions you are running

Additional Articles from MSSQLTips.com

Check out this tip to easily find out what version of SQL Server you are running.

Blog Post

From the SQL Server Central Blogs - Azure Synapse Case Study

Joyful Craftsmen from Joyful Craftsmen Blog

Let’s introduce our customer and their product
Our client is working in telecommunications providing secure and reliable networks. They are an independent supplier of mobile, data and voice services in...

Blog Post

From the SQL Server Central Blogs - Power BI Datamarts

James Serra from James Serra's Blog

As mentioned in my previous blog about the Microsoft Build event announcements, the biggest news was Power BI Datamarts. This is a new self-service capability included with Power BI...

 

 Question of the Day

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

 

SQL Server Collation

Where can I set the collation for data in a SQL Server 2019 database?

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)

Azure Storage Policies

I want to set a policy for a container in Azure Storage where I am storing some data import files. I want to use a Shared Access Signature (SAS). What types of limits can I set for the Access Policy?

Answer: Start/End Times and Access rights (read/write/add/delete)

Explanation: You can set a shared access signature on Azure Storage resources that determine:

  • what permissions (read/write/delete/add)
  • when (start/end time)

You can then apply this policy to a resource. 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 2016 - Administration
Creating index for a very huge table - Hello, I would want to get some opinion on creating indexes on a very large table. My developer recently execute an index creation job and the job run for more than 30hrs until it ran out of transaction log space thus got terminated. I check the size of the intended table and it's super huge! […]
what minimum permission i should give to new login , new user and new schema. - Hi, I have made a new login, new user (as I have associated my database to login) and new schema. I need to know what minimum permission I should give to my new login, new user and new schema, so that the person should be able to create tables drop table and perform crud operations […]
SQL Server 2016 - Development and T-SQL
Importing XML into SQL Tables using SSIS package - Hi everyone, I have a XML file which consists of data like this: 1001 Ben
House no 280NYUS
street 100CaliforniaUS
  I have designed ssis package and Now I am able to move Individual data to Individual table. And Address data […]
Administration - SQL Server 2014
Unable to drop a user - I have a user 'Dev_User' in a new dev server which I am trying to drop and recreate. I generated a script using sp_help_revlogin proc from a an old dev server since SID doesn't match even though the password matches. This user has admin rights on the server and there are some applications which connect […]
Strange Write Statistics - Hi Experts, I ran the below query and for a table I am getting very high writes and its increasing every second. The table here is a master table which is having only 17 records?   TableName Reads Writes Supplier 13 13460167 SELECT TableName = object_name(s.object_id), Reads = SUM(user_seeks + user_scans + user_lookups), Writes = […]
Development - SQL Server 2014
How to get creole language - I need to update a report to show the month name in the specific language - creole. I use the function below which uses  sys.syslanguages  table. I need the month names for creole now but this table does not have Creole. Is it safe to update this system table and Creole? Any ideas? Thank you. […]
Looking for odbc connect parameters in msdb-database - hello, I want to monitor the odbc connections. In table sys.dm_exec_sessions I find all actually opened ODBC-Connections. But where I find the parameters of the ODBC-Connect-string? For example: An Access-Applications connects with the following parameters: "ODBC; Driver=SQL SERVER; Server= BlaBla; Database=ABC; UserID=Hans; Trusted_Connection=yes; Description=Wertet Summen aus; APP=Test.accdb" I am looking for this parameters. Have anyone […]
Select @XML.nodes with Name spaces Help Please error msg 2209 XQuery nodes - Hi All, I have spent a few hours after revisiting this serval times and have never come up with a working solution for Nodes which contain a space in name.  the node I want is called   Item param error Msg 2209, Level 16, State 1, Line 18 XQuery [nodes()]: Syntax error near 'Item'   This […]
SQL Server 2019 - Administration
TLS 1.2 - OK, I have been doing a lot of research, and I am continuing that research, into some issues we are having with out SQL Servers since the implementation of TLS 1.2.  We are under the gun to get all of these issues resolved very quickly.  As I have been researching, I have found that all […]
Working with field specifications - I was reading the book: "Database Design: For Mere Mortals" by Michael J.Hernandez. In it, he goes in to detail on field specifications. He writes: "Field specifications constitute the “data dictionary” of the database. Each field specification stores data on the characteristics of a particular field within the database." Here is an example of one […]
restore a specific table from a Full backup using Quest Litespeed - Hi, Is it possible to restore a specific table from a Full backup using Quest Litespeed without restoring the entire database? will it restore the tables with same schema without missing any keys and data.? will it overrides the table ? Any suggestions please. Thanks.
Read Only Routing Problem - Good morning All, I have a set up that consists of 3 servers (Srv1, Srv2 and Srv3) In this exmaple Srv1 is the pricinple. Read only routing is configured such that it should connec to Srv2, Srv3 and if they fail then back to the princple Srv1 The Read only Routing list looks like (Srv2, […]
Clarification on the database design process - I was reading the book: "Database Design: For Mere Mortals" by Michael J.Hernandez. In it, he goes into detail on the database design process. There is a section where he summarises it as best as he could: "Next we looked at an overview of the entire database design process. The process was consolidated into the […]
SQL Server 2019 - Development
Stats histogram comparison with data in table (Windows function) - Hi, I'm comparing the stats histogram with the actual data distribution from a table (for this example Person.LastName on AdventureWorks) like so: ;with e as ( select lastname, count(*) norows, ROW_NUMBER() OVER (order by (select 1)) rn from person.person group by lastname having count(*) >=1 ) select e.lastname , e.norows , e.rn , h.step_number step […]
General
Hey, I am trying to learning SQL on my own and I am stuck in an error. - I am trying to find a average from a column but all I am getting is an Unrecognised name error msg. This is the query. Select End_time - Start_time as time_duration, Avg(time_duration) as avg_time From table I am getting an error " Unrecognized name : time_duration" Where should i establish the column "time_duration" to perform […]
 

 

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

 

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