| A community of more than 1,600,000 database professionals and growing |
| | Who's Responsible? In college and for a short time afterwards, I worked at restaurants in various capacities. I've held most of the jobs available and enjoyed my experiences. I had good and bad bosses and sometimes had to endure questionable practices from management. Often I needed money, so I couldn't take a moral stand and was at the mercy of some manager. I think a bad restaurant manager at a part-time bartending position eventually caused me to choose to leave that industry. With a fulltime day job in technology, I could forgo the extra weekend money to avoid additional stress. Bad managers and practices still exist, and I was reminded of this in an article recently. The practice of forcing employees to pay for mistakes is blatantly illegal, and I hope someone gets a few days in jail as a result of the case. However, I started to wonder if this trend might ever make it to our industry. Especially with the changes in services as more systems move to cloud environments. I've worked in companies that debated my expense reports, and refused payment for some charges. Some of your might have had the same experiences, which often cause you to be very cautious about future expenditures. That could be good or bad for business, but it certainly is a problem for the employee. These days I find plenty of employees that will setup or provision some cloud service using their own credit card, expecting to be reimbursed at the end of the month. What happens if the company doesn't want to pay? A manager decides the service wasn't necessary. What would you do? What if you provision the wrong service, or forget to terminate something. These are common mistakes in business, but would you pay for the mistake? What if you didn't pay for the service, but the company wants to deduct the charges made by mistakes from your paycheck. Do you fight this? Bring a lawsuit? Plenty of possible actions might ensure you aren't financially penalized but could cost you your job. I'd like to think that this wouldn't be an issue for salaried, technology workers, but I wonder. Is there any reason to worry? Let me know what you think. 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.9MB) 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 | | Write, format, and refactor SQL effortlessly with SQL Prompt Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with tab coloring you’ll never deploy to the wrong environment again. Download your free trial |
| | How to track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more |
|
|
|
| | | Shubhankar Thatte from SQLServerCentral.com This article provides step by step instructions to deploy individual SSIS packages in a project deployment model. More » |
| Additional Articles from SimpleTalk One of the most glib generalisations you can make about development work is to say that code should be liberally commented, or conversely that it should never be commented. As always, the truth is more complicated. There are many different types of comment and some types are best treated firmly with the delete key, where others are to be cherished and maintained assiduously. Even though it is hard to find two developers who agree on the topic of commenting, Michael Sorens warily sketches out the issues and the battleground. More » |
| Wish you could get through your daily tasks and responsibilities a little quicker? Redgate are asking SQL Server professionals what would be most desirable about gaining an extra hour in the working day. Add your vote now. More » |
| Devin Knight from SQLServerCentral Blogs In this module you will learn how to use the Dot Plot Custom Visual by MAQ Software. The Dot Plot... More » |
| meaganl from SQLServerCentral Blogs Back in January 2016, I wrote a blog post explaining a DAX workaround that allows you to put measures on... More » |
|
|
| | Today's Question (by Steve Jones): If I run this code on the right SQL Server platform, what is returned? EXPLAIN SELECT CAST (AVG(YearlyIncome) AS int) AS AverageIncome, CAST(AVG(FIS.SalesAmount) AS int) AS AverageSales, G.StateProvinceName, T.SalesTerritoryGroup FROM dbo.DimGeography AS G JOIN dbo.DimSalesTerritory AS T ON G.SalesTerritoryKey = T.SalesTerritoryKey JOIN dbo.DimCustomer AS C ON G.GeographyKey = C.GeographyKey JOIN dbo.FactInternetSales AS FIS ON C.CustomerKey = FIS.CustomerKey WHERE T.SalesTerritoryGroup IN ('North America', 'Pacific') AND Gender = 'F' GROUP BY G.StateProvinceName, T.SalesTerritoryGroup ORDER BY AVG(YearlyIncome) DESC; GO |
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: Azure. We'd love to give you credit for your own question and answer. To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
ADVERTISEMENT | Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy, performing threat analysis, and encrypting sensitive data as a last line of defense against compromise. The multi-layered approach in this book helps ensure that a single breach doesn't lead to loss or compromise of your data that is confidential and important to the business. Get your copy from Amazon today. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| |
| Database Pros Who Need Your Help |
| Here's a few of the new posts today on the forums. To see more, visit the forums. Installed SS 2016, unable to find default instance or create one - I have just installed SQL Server 2016 and SSMS 2016 on a virtual machine/server. I'm not sure how to find... Job reported: Unable to terminate process (reason: Access is denied) - Using SQL Server 2016 SP1 running on VM a SQLAgent job is hanging on one step that executes an SSIS... Error on Backup - I am getting a backup failure on a TDE database (SQL Server 2016 SP1 EE) in an AG Msg 33111, Level... Unable to connect to SQL 2008 Servers from SSMS 2017 - Servers are running on SQL 2008 on Windows 2003. Client from where I am trying to connect to those servers... solved - Row Level Security based on membership in AD Group or ServerRole - Hi, I'd like to implement row LevelSecurity. Users are mapped to one (or more!!!) Groups (either AD Groups or ServerRoles, does not... Script or Ways to check if SSRS encryption key backed up - Hi Experts, Can anybody help me finding out how to check if the SSRS encryption key have been backup up... Corruption of the file format .mdf - I had a problem. While working in MS SQL Server was made to emergency restart the computer. After reboot tried... Finding Consecutive Values For a Record - I have a table that shows if a record has a value for each month. A zero is given for... Does HIPAA require that test data not have any real data? - This is a question that I'd ask in a free form forum, but I couldn't find one. If I've missed... Delete Extended Events file - Is there any way to delete the xel file once I no longer need it without having to use something... Left outer join make duplicate column name - I used code below to select 10 temp tables as one row table. All 10 tables has the same column . How... Columns to rows and rows to column conversion without pivot/unpivot - All I need is convert Column(A1/A2) into rows and rows(1 into Jan) into columns.????Input: Here A1/A2 belongs to say A and... Time increments - Hi, I want to have a calculated field "TimeIncrements' that will increment 20 minutes starting at 8:00 and ending at 5:00... PLE - Hi All, Appreciate if anybody can help understand why the physical memory is divided by 4 to determine ideal Page Life... Right Size for LDF physical disk - Dear friends, Please, help me to take action, the facts are: Big database 1.5 terabyte database size, recovery model simple, 12 % Pct... Migrate Oracle database to SQL Server 2008 - Hi, We are planning to Migrate Oracle database to SQL Server 2008 and want to use SSIS to complete the migration. Could... Lookup values similar to VLookUp in Excel - Hi, I am struggling to write a procedure which looks up a value in a lookup table. See desired results below. Any suggestions? Cheers, Julian [code... ssis loads slower than sql server - I have a view which uses a select query(with lot of transformation) from a huge table. when I use ssis... Data flow concept - Thoughts wanted - Looking for thoughts on this. I have an application where we receive data from customers via text file. Unfortunately, we... need sample resume for MS SQL DBA - Hiii All I need sample resume for SQL DBA, can any body guide me, where will i find the sample resumes. |
|
| This email has been sent to [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. | 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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: [email protected] |
|
|