SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

The Voice of the DBA

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:

  1. 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.
  2. She did sometimes go out of her way to help someone, even though she didn’t have to.
  3. Though she helped a lot of people, no one ever felt that she was stepping on one’s toes.
  4. 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.com

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

ADVERTISEMENT
Webinar

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

RGUni

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

Featured Contents

 

The SQL Server LAG Function

Mike Byrd from SQLServerCentral.com

The LAG function can really improve performance over the old double JOIN. More »


 

Creating Measures Using DAX

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 4 capabilities you need to introduce true database DevOps

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 »


 

From the SQLServerCentral Blogs - Data Warehousing Tip #4 – Trust your instinct

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 »


 

From the SQLServerCentral Blogs - Quick Permissions Audit

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 »

Question of the Day

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

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2017 : SQL Server 2017 - Development

Bulk Insert how to skip column using format file - I have a scenario were in a table has 5 columns, but data (CSV) file has 2 columns of data....

Understanding the datetime2 data type and precision - I am testing out the datetime2 data type so I can understand how the precision works.  I have defined a...


SQL Server 2016 : SQL Server 2016 - Development and T-SQL

Update a table column from a join with another table - I would like a query to update Table:DutyA Action column with word "create" if when joined to Table:DutyB on columns EmpID,...


SQL Server 2014 : Administration - SQL Server 2014

Databses with >40,000 Users - Hello. Has anybody come across any issues with large numbers of Users in a database - i.e. >40,000. We hit 32767 Users some...

Database refresh from Production DB to Test DB in Sql server 2014 - Hello, I would like to know the what's the best way i can do Database refresh from Production DB to Test DB...


SQL Server 2014 : Development - SQL Server 2014

very slow select - Team, I have this query that runs quite a long time, actually the result is not been displayed at all.

Performance Issue with Simple Query /Big Tables - This query (attached estimated query plan) returns Exception of type 'System.OutOfMemoryException' was thrown.  Are queried tables just too huge or can query performance...

Update trigger - I have insert trigger for inserting records from T_PDF table into T_WV_RESULT Table. The below trigger is fired when new records are inserted...


SQL Server 2012 : SQL Server 2012 - T-SQL

after add field to query grouping is damage and show extra lines problem - problem after add field dbo.trxtypeConfig.TrxArbName to query grouping is damage problem . this query below is grouping meaning it must show one line...

Why BIT value Returned from a function doesn't work in IF statement - I created a simple function that checks a given string and return a value of BIT type.  The script of...


SQL Server 2008 : SQL Server 2008 - General

Migrate all user logins - Hi Guys I need to migrate all user logins ( under security folder in SSMS )  from 1 server to another but...

View timeout problem - I have a fairly complex sql view that times out most of the time. I run it from SSMS to...

Date functions.. - i was trying to solve an online test... and i stopped here... i tried looking at the newly introduced functions...


SQL Server 2005 : T-SQL (SS2K5)

Remove DATE ONLY from datetime column - Hello, I need to remove DATE from a date time column in SQL 2005? All I keep finding on Google is...

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