| A community of more than 1,600,000 database professionals and growing |
| | Getting Fired This editorial was originally published no Mar 27, 2014. It is being republished as Steve is on holiday. Have you ever been fired from a job? I hope most of you never have as it's a somewhat traumatizing experience. I've been let go from one (and asked to leave another), and even though I didn't like the job and wasn't sorry to be gone, I didn't like getting fired. Awhile back I saw Brent Ozar ask the question on Twitter: "when do you fire a DBA?". There were a number of answers, and he ended up writing a post that summarized some of the reasons as responses. You can read the post, and the various reasons. I think for most of them, I'd disagree if any incident were the first occurrence of the situation. I know people will make mistakes, and if I don't forgive accidents, I'll never have anyone trust me as a manager. I also don't think you let someone go for ignorance. They might never have had to deal with a situation. I don't think you let them go if they don't dig deep into systems and find problems. It's always possible they haven't gotten to the one item that causes a disaster. To me there are two certain places where I'd let someone go. The first is willfully taking part in any illegal activity. I don't think an officer of an organization can allow that to take place. The second is more subjective. I would have to let you go when you've repeatedly shown that you're not becoming a better employee and making the same mistakes over and over again. Failure to learn is not an option. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| ADVERTISEMENT | | SQL Clone: Now supporting databases up to 64TB Create copies of production databases and SQL backups in seconds and save up to 99% of disk space using SQL Clone. Redgate’s new tool removes much of the time and resource needed to create and manage database copies, allowing teams to work on local environments to develop, test and diagnose issues faster. Try it free |
| | The industry standard for comparing and deploying SQL Server database schemas Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial |
|
|
|
| | | Erin Stellato from SQLServerCentral.com In this Level, we'll walk through the basics of using the New Session dialog in the UI to create a new event session, define its events, actions and predicates, and establish a target for the session in which to collect the event data. More » |
| Press Release from Redgate Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks". More » |
| Additional Articles from SimpleTalk As the final entry in this series, Robert Sheldon leads you through a group of forgotten features that have been removed from recent versions of SQL Server. In some cases, the features were widely used and often loved, while others had lost their usefulness over the years or were replaced with something much better. In this article, he remembers Data Transformation Services (DTS), a handful of DBCC commands, a few utilities, Active Directory Helper Service, English Query, Web Assistant, SQL Mail, Native XML Web Services, Notification Services, SQL Distributed Management Objects, Surface Area Configuration Tool, and the Pubs and Northwind databases. More » |
| Steve Jones from SQLServerCentral Blogs I should write about my first one, but I just copied Rob’s test, so that’s not so exciting. Instead, I... More » |
| david.fowler 42596 from SQLServerCentral Blogs From time to time we need to make changes to Always on Availability group Synchronization mode settings , this also includes... More » |
|
|
| | Today's Question (by Steve Jones): I've got this function in R: FindingTheMean <- function(first, second, third) { return((first + second + third )/ 3) } I decide to call it like this. FindingTheMean(f=25, t = 100, 200) What happens? |
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: r language. 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've got this query: SELECT SalesYear = YEAR(soh.orderdate) , SalesMonth = MONTH(soh.OrderDate) , SUM(soh.TotalDue) , AggGroup = GROUPING(YEar(soh.OrderDate)) FROM Sales.SalesOrderHeader AS soh WHERE YEAR(soh.OrderDate) = 2014 GROUP BY GROUPING SETS ( YEAR(soh.OrderDate), (YEAR(soh.OrderDate), MONTH(soh.OrderDate)) ) What values are returned for the AggGroup column? Answer: 0 for all rows Explanation: The GROUPING function is useful to show those rows that have aggregated in the result set. In this case, none of these rows are aggregated with a NULL value for the group. Ref: GROUPING - 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. How many workers can I use and how many are active? - Hi folks, we are trying to troubleshoot a problem that seems to be the result of too many threads being allocated to... Help with aggregate function - have table: col1 col2 col3 A B 10 B A 5 C D 8 Want to get: A B 15 C D 8 Issue with agent job while taking backup - EXEC msdb.dbo.sp_send_dbmail @profile_name ='DBA', @recipients ='arvindinfa2014@gmail.com', @subject = 'Differential Backup Report', @execute_query_database = 'master', @query='EXECUTE .', @body_format='html', @body='Differential Backup of USER Databases taken successfully on Server1', @exclude_query_output=1, @append_query_erro FCI + Always On - Hi, I want to setup a 3 nodes solutions. NODE_A, NODE_B and NODE_C are part of the same WSFC. Node_A -> Contains... C# String treatment - Hello, I have a line of code like: Filenameonly2 = line I get a result like: When I do messagebox.show ( Filenameonly2 ) I get: 16 DIVIDENDS... Creating databse backups automatically in specific period of time - Hi Guys, I am creating back ups of my database using code: USE QlikView; GO BACKUP DATABASE QlikView TO DISK = 'C:\Program... Access as FE and MS SQL Server as BE - Hi Guys, I moved Access back-end (split database with FE and BE in Access) into MS SQL Server database using Sql... Coffee sales for just 7am to 8am but for the entire year? - select * from TicketItem where s_item IN('Coffee', 'Espresso', 'Double Espresso', 'Decaf Espresso', 'Cappucino', 'Latte', 'Iced Coffee', 'sm coffee pot', 'lg coffee... Distinct of two columns? - Hello all, Hoping someone out there can help with this because I'm just not seeing the answer for some reason, and... To Index a Computed Column... - Hi All, So in an effort to optimize a larger query (which I've posted about here before), I'm trying to utilize computed... Row count differences with CTE vs Temp table Vs view - Hi All, Just for curiosity to see if anyone else has come across an issue like this - SQL 2014 - not sure... SQL 2012 - Interview Questions (Sample) - Hi Guyz, Warm greetings ! I'm very happy to post some interview questions today which I'd faced recently via a Skype. Could you please... Dynamic SQL not executing - Wow I can not believe the number of questions I have had. I am way over tired but that only... Find nth position in a pipe delimited string - Here's my string, I need to determine if there is a value between the 30th and 31st pipe. Any thoughts?{MED|10|MG|RC|ONCE|PRN|||||||||||||||||||||||||CONSTIPA|Constipation||||||||||1||Med|BISR|||||||||||} bcp changing high ascii values - bcp appears to be changing some high ascii values on import (eg 249 to 168). How can I control/prevent this... How to calculate finacial year in mssql 2000 - Hi Friends, i have a table like below i want to display financial year count Create table test (M1 vacrhar(20), M2... Is there any obvious performance difference between updating 1 column in a 4 column wide table vs 1 columns in a 1000 column wide table ? - I have a table with 4 columns and 10 million rows in which I want to update 1 column I have... Defining keys as sets that must not intersect instead of scalar values that must not be equal - I have been doing a lot of thinking about data models for the last couple of weeks. I have, just... Please get rid of this constant, useless job alert!!!!!!! - I've been getting this email from the SQL Server Central website's daily for at least 2 months, notifying me of... HOw to get Automatic Email notification for High CPU Utilization >80 % with the query which is causing the high CPU usage - hi all, Do any one have any script by which i can get a automatic email notification when a HIGH CPU... |
|
| 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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com |
|
|