| A community of more than 1,600,000 database professionals and growing |
| | Versatile or Jack of all trades Today we have a guest editorial as Steve is traveling. Last year, I had the pleasure of working with a senior Business Analyst, who was not only very good at her job (i.e. quickly understanding thebBusiness requirements and translating them into clear specifications), but was also great at stepping up to lead the project when required and helping the technical team to resolve technical issues quickly. She was a lady who could juggle a lot of tasks when needed to get the project going. Last week, when we were discussing about recruiting a Business Analyst for a major project, I suggested hiring someone like her. One of the managers didn’t like it and said that she would rather have someone who is just a good Business Analyst than a “Jack of all trades”. After a bit of argument, I realised the previous Business Analyst was not appreciated by some for one main reason: her way of helping made the other teams too much dependent on her. My thoughts about her were: She was a creative person and used to come up with good out-of-the box suggestions, sometimes even when she wasn’t asked for. She did sometimes go out of her way to help someone, even though she didn’t have to. Though she helped a lot of people, no one ever felt that she was stepping on one’s toes. Her project work had never suffered because of her involvement in other non-allocated tasks. If her helping made others too much dependent on her, then that's not her problem.She only helped when needed. So, I would prefer to think of her as a versatile team member; rather than just a Jack-of-all-Trades. However, I could be prejudiced and so thought to share. Would you prefer to work with someone like her? Or rather, would you prefer to be someone like her? Nitin Bhojwani from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| ADVERTISEMENT | | DevOps: What, who, why and how? Wednesday January 23 16.00-17.00 GMT / 10.00-11.00 CST - More and more organizations are turning to DevOps as a way of working together to improve the efficiency and quality of software delivery and start adding more value to the business. But what exactly is DevOps and what does it mean for you and your organization? Register now |
| | Redgate University Self-paced online training courses with easy to follow classes on getting started, exploring advanced features, and making the most of Redgate products. Learn the fundamentals, best practices, and top tips from the experts - Redgate’s Microsoft Data Platform MVPs and engineers. Start Learning |
|
|
|
| | | Additional Articles from SimpleTalk In the first article in this series, Andy Brown demonstrated how to create calculated columns in Power BI using the DAX language. This second article in the series explains what measures are, and how you can use DAX to create measures within Power BI. The formulae in the article apply equally well to PowerPivot and Analysis Services Tabular Model. More » |
| The latest Accelerate State of DevOps Report from DORA concludes that successful software delivery unlocks competitive advantages, including “increased profitability, productivity, market share, customer satisfaction and the ability to achieve organizational and mission goals”. The result of over five years of research with over 30,000 data points, it shows a direct correlation between DevOps and better business performance. More » |
| ChrisJenkins from SQLServerCentral Blogs My fourth data warehousing tip is to trust your instinct when it comes to building solutions, and if to you... More » |
| Jason Brimhall from SQLServerCentral Blogs Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out... More » |
|
|
| | Today's Question (by Steve Jones): What does the MAXX() function do in DAX? |
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: MAXX(). 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 | Expert T-SQL Window Functions in SQL Server Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. Get your copy from Amazon today. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I want to get a list of supported collations on my SQL Server 2017 instance. What query should I run? Answer: SELECT Name from sys.fn_helpcollations() Explanation: The list of collations supported comes from the TVF sys.fn_helpcollations(). Ref: sys.fn_helpcollations - click here » Discuss this question and answer on the forums |
|
|
| Database Pros Who Need Your Help |
| |
| 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 |
|
|