 | A community of more than 1,600,000 database professionals and growing |
| | | Horrible Bosses Horrible Bosses is a movie that makes me laugh. I've seen it a few times, and I'd likely watch it again if I stumbled on it during a flight or while flipping channels. I've had some bad bosses, even one I'd consider a horrible boss. I've worked in poor conditions for IT, though considering what some people go through, it wasn't that bad. I"ve been stressed, overworked, and abused by employers. Again, relatively. These are really #firstworldproblems, and not so much problems as annoyances. I've really had an easy life compared to many people, though it hasn't always been stress-free. The one thing that I've tried to do throughout my career is be a professional. Do the job I'm paid to do, and accept the good and bad. If I don't enjoy it, or don't agree with the demands, then I can leave and find another job. I've had to do that a few times, often because of the people that make the job a bad one. Fortunately I have a great boss now, which makes my work much more enjoyable. I've also tried to build software that I feel comfortable with from a moral standpoint. I've never been asked to work on anything illegal, and I hope I never am. I'd also hope that I would refuse to do so. I think it's hard to put yourself in a tough situation, as you can never know all the variables. Imagine that you're in debt, you need your salary to pay for medical care for your family and it's a recession. You might feel trapped in a position, worried about not only losing your job, but also your livelihood and potentially putting someone's life at risk. Making moral stands in tough situations is hard, and I hope I never have to do so. My best advice for my kids, and for others out there, is that you want to actively manage your career. I've told my son the best time to find the job you want is when you have a job, not when you are out of work and need a job. If you've got a horrible boss, start making steps to find a better one. It can take time, potentially months or years, so make a plan and start down the path of finding a dream job that you look forward to every day. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.1MB) podcast or subscribe to the feed at iTunes and Libsyn.  The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT |  | | CI/CD for your SQL Server database Feeling the pain of managing and deploying database changes manually? Redgate SQL Change Automation completes your database delivery process by building, testing, and deploying the database changes you and your team check into version control.
Try it free |
|  | | What’s the top challenge faced by SQL Server professionals in 2018? Learn how 626 SQL Server professionals monitor their estates in our new report on the State of SQL Server Monitoring. Discover the challenges currently facing the industry, and what is coming next. Download your free copy of the report |
|
|
|
| | |  | Kenneth Igiri from SQLServerCentral.com Sharing our experience using Data Compression as a space savings option in MS SQL Server 2008 More » |
 | In this new whitepaper, 5 SQL Server experts; Grant Fritchey, Rodney Landrum, Kathi Kellenberger, Phil Factor and Tony Davis, use their many years of experience working and maintaining data systems to explain the 4 key strategies required for a successful, estate-wide monitoring solution. More » |
 | David Postlethwaite from SQLServerCentral Blogs David has produced a talk all about Sharding. Or if you prefer horizontally scaling your Azure SQL database. You can view... More » |
| | Matthew McGiffen from SQLServerCentral Blogs For this month’s T-SQL Tuesday. Jeff Mlakar invites to talk about “a project you worked on or were impacted by... More » |
|
|
| | | Today's Question (by Steve Jones): I have a database of baseball statistics. In the entire history of batting, I want to find out what percentage of players have hit 40 or more home runs in a season. I'm using this query, but I keep getting a 0 back. SELECT COUNT( CASE WHEN hr >= 40 THEN 1 END ) / COUNT(*) * 100 FROM dbo.Batting AS b ; What should I do? |
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: T-SQL. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| | Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I am considering moving my on-premises SQL Server database to Azure SQL Database. I want to estimate what number of DTUs that I need to contract for. Which counters do I need to capture in order to estimate the DTUs I need?
Answer: % Processor Time, Disk Reads/sec, Disk Writes/sec, Log Bytes Flushed/sec Explanation: The counters needed are: - Processor - % Processor Time
- Logical Disk - Disk Reads/sec
- Logical Disk - Disk Writes/sec
- Database - Log Bytes Flushed/sec
Ref: Identifying the right Service tier for Azure Database - http://www.sqlservercentral.com/articles/Azure+SQL+database/176202/ Azure DTU Calculator - click here
» 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.
Compare of variables and handling nulls - Hi, I wanted to compare 3 variables and set a flag if any of the three differ .. i.e. including handling of... How do you handle SSIS package merging between two BI teams? - Hi!! Here's the thing - I have the following scenario: Base points - Multiple teams work on the same Data Warehouse (DW) - The SSIS... How to build an app with GUI that works with SQL Server? - I have to create a project which should have a GUI because people who gonna use it don't know TSQL....
Same Execution Plan different stats - Good day everyone: An interesting case just presented to my attention: Have the same INSTANCE of a SQL Server 2016...
Convert varchar date to dd/mm/yyyy format date - I want to convert data that is currently in a varchar column as "7/30/2016" to a new column as a... Audit Trial help - The new Trigger Table should hold new values and old values in the following way.   Use CTE/WITH to concatenate TWICE. - I have a table with 'words', each row contains a word, a position, a linenumber and a textnumber. I want to... Importing from XML to SQL 2014 - This is my 4th day on SQL so I am a newbie. I created a query to import from an...
MS SQL Server 2014 and TLS 1.2 settings - Dear Gurus, I have a situation here and need your kind help. 1) ONE DB SERVER with following details: OS : MS Windows 2012...
Casting one datetime as date converts other datetime fields - I have a table with two DateTime fields. When I select them and cast one of them as date, it... How to flip tables in sql server 2014 - Hello, I have a requirement wherein there are 2 tables (Staging & Target) in the same database. Everytime data is first loaded in...
HOW TO GET FIRST DATE - Dear all, I have data like: NAME SPONSOR_NAME DATE_OF_CALL A FI
Help pls: upgrading from sql 2005 to sql 2008 - Hey guys.. I have quick and urgent question.
I am wanting to upgrade our sql 2005 to 2008. In the sql 2005... Find and replace third occurrence of the string - I want to find the third occurrence of the 'o' and replace with 'A' create table store ( productid int, productdescription...
Table growing excessively when updating column - I have got an issue that is driving me nuts. There is table in an Azure database containing some 8.800.000 rows...
Cant Upload RDL File to SSRS 2016 - I've wasted half a day trying to figure out a solution for this issue. We just stood up a SSRS 2016...
2 sql tables with 1000 rows each - I have a 2 sql tables with 1000 rows each. Initially TableA - 1000 rows TableB - 1000 rows Every time a new row is added...
Feature request, please... - Not sure if the forum software will do this, but if it can, PLEASE add a "ignore topic" option. Yes, this...
DateAdd() - how to add 5 hours and 25 minutes to a date? - Hi there, This is actually a question re how to do this in SSRS's Report Designer 1.0, please forgive me if...
Help interpreting deadlock output - We're maintaining an inherited system with a complex (overly-complex in our opinioin) database. We've recently had reports from users of 'data... |
|
| This email has been sent to newsletter@newslettercollector.com. 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.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
| This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
