SQLServerCentral.com Community Update for {date}

Problems displaying this newsletter? View online.

Featured Contents

Question of the Day

Finding the Group

The Voice of the DBA

Daily Coping Tip

Send a positive note to a friend that needs encouragement

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.

For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

Work/Training Balance - The hidden balancing act

Today we have a guest editorial as Steve is out of the office. This editorial was originally published on 5 Dec, 2016.

Many discussions occur about work/life balance. It appears that most people are striving to achieve a good balance or, at least, are aware of it. I believe that this is exceptionally important and am critical of myself for doing so badly at it. I am improving but too slowly.

We can further break down the work aspect. What I am considering today is whether we, as a collective, are achieving a proper work/training balance. By this I am considering the work aspect of the classical work/life balance and asking how many of us put in enough time to maintain our own skill set at a high enough level required to perform our work duties. Some companies help out here by providing on the job training, some individuals help themselves by putting in effort in their own time, some people benefit from both and there are even those that apply neither.

Of course, doing neither may be a valid option. For example, if you are working on a technology that is not changing in your environment, your job appears safe and you are retiring soon, then you may feel that there no longer is any benefit to develop your work skills. Or maybe you are about to change careers.

I suspect for the majority of us we still need to maintain some work/training balance. Without the assistance of employers, either directly by supplying formal training or indirectly by allocating time, we may struggle to find this balance inside of an appropriate work/life balance.

Gary Varga

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

Featured Contents

PolyBase scale-out group in Azure for free

Pablo Echeverria from SQLServerCentral

create a sql server polybase scale out group in azure for free

Who is responsible for building tests?

Additional Articles from Redgate

When you begin to automate your deployments, you’re also going to start automating your testing. After all, a deployment, in and of itself, is a test. However, you'll pretty quickly come to the question: who is responsible for building tests?

Notify Users of Power BI Dataset Changes

Additional Articles from MSSQLTips.com

In this article we cover the steps on how to send notifications to business users when a change in a dataset used for Power BI has occurred.

From the SQL Server Central Blogs - Azure Function Drain mode

Rayis Imayev from Data Adventures

(2021-Jun-16) Recently, Google started to notify me that my blog website (http://datanrg.blogspot.com/) had been experiencing some ‘Server (5xx)’ errors. Nothing has been changed on my side, and I’m not sure how...

From the SQL Server Central Blogs - Find Queries Using a Key Lookup Operator

Grant Fritchey from The Scary DBA

While teaching about Extended Events and Execution Plans last week, Jason, one of the people in the class, asked: Is there a way in Extended Events to find queries...

Question of the Day

Today's question (by Steve Jones - SSC Editor):
	Finding the Group
A login in SQL Server 2019 is a member of an Active Directory group. I want to know which group, this user is a member of. How do I determine this?
Think you know the answer? Click here, and find out if you are right.

Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Granting Schema Permissions

What is the format for granting permissions on a schema, such as this:

GRANT SELECT ON xxxx TO MyUser

If the schema name is abc, what replaced the xxxx above?

Answer: schema::[abc]

Explanation: The format for granting permissions to a schema is "GRANT permission ON SCHEMA::schema_name TO user_or_role. Ref: GRANT SCHEMA PERMISSIONS - https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-schema-permissions-transact-sql?view=sql-server-ver15

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 - Development

deadlock prevention - Hi All, I' m looking for some help in interpreting and fixing the deadlock. Recently we started seeing some deadlocks and this is one among them. Attaching the xml deadlock graph and table info. SQL Server version ================ Microsoft SQL Server 2017 (RTM-CU23) Enterprise Edition: Core-based Licensing (64-bit) Regards, Bob

SQL Server 2016 - Administration

dm_exec_connections EE - Is there a mapping column in extended event for encrypt_option in sys.dm_exec_connections . my scenario is to capture sessions that are not encrypted.

Performance Counters Missing in SQL 2016 SP2 - Hi, I'm looking for a fix to an issue where performance counters are missing from SQL 2016 (SP2). All SQL related counters are available in the OS i.e. Perfmon but only and small amount related to XTP are available in SQL itself e.g. if I run the following SELECT * FROM sys.dm_os_performance_counters It returns 57 […]

SQL Server 2016 - Development and T-SQL

suggestions on making more efficient and faster - I have a piece of code that I would like some suggestions on how to make it faster\ more efficient. The Quality and Quality_Detail are properly Indexed, but are Large tables. Thanks. BEGIN TRY -- Revision 1 - Added SELECT @Total_Readings = SUM(CAST(QD.Value AS float)) FROM Quality Q INNER JOIN Quality_Detail QD ON (Q.Quality_ID […]

Rounding question - If i execute query 1, i get 0.00036369128107, but if i execute query 2, I get 0.00000000000000. What i want it is I want the results (i.e non zero) but with 6 decimal places. How can i accomplish this? So, I'm looking for something like 0.000363 or 0.000364. Any idea how to accomplish this? select […]

SQL Server 2012 - T-SQL

Pivot table syntax (?) issue - Please delete post, I was looking at the goal of the query totally wrong.

SQL Server 2019 - Administration

What's the difference with installs for Core vs Server/Cal? - Does anyone know why under MS vol licensing there are SQL 2019 Std installs for Core and different ones for Server/CAL. The filename and size is the same, what's different about these? We are converting Server/CAL to Core. Does it matter what install was used when the server was built?

SQL Server 2019 - Development

Looking for a way to change all objects at once? - Hi, I have a field in a table called prin_ball, upon doing a search for this, I would have to change it in about 158 different objects (that is jobs tables, procedures, views, and triggers). Is there anyway of doing a find and replace to change all at once. Or at least the views, tables […]

Mirror Database without Domain - Hello, I tried to make a mirror for my Demo database My Principal server is in the Domain by the name ‘server1’ (192.168.0.0/24) My Witness server is in the same domain and same network (192.168.0.0/24) with the server1 and the name is ‘server2’ My Mirror server is in another network (192.168.10.0/24), which is connected with […]

Reporting Services

Add On-Demand Subreport - This is so very easy to do in Crystal Reports. You add subreport hidden anywhere on a report, link it to the parameters on main report and you can just double-click on it to run. In Report Builder, I've added the subreport, linked the parameters but then it runs for every group. I then set […]

SSRS 2012

Total of the row - Hi all, I have 4 columns in the report: Customer, Price, Cost, Revenue. I would like to put in the end of the report total value of each column (Price, Cost, Revenue). I clicked the right button to the appropriate column and chose to "add a total". When I select all customer values ??in the […]

Powershell

PowerShell script help - Hi Guys, I am executing a PowerShell script from SSIS (Execute Process Task). Simple script, Calling PS script and returning a variable value. The process runs successfully when I am running on my local machine. However, when I run on the server, the "SSIS Package" hangs on "Execute Process Task". When I run on my […]

Design Ideas and Questions

Vendors Database - Dear all, We are looking for web based system through which we can administer a large number of vendors from all over the world. For each vendor, we want to add information such as - country of origin - rates - team members - previous projects -etc - some information in a memo field From […]

Anything that is NOT about SQL!

Forum bug with the "like" button - I was looking at a post, specifically this one: Performance Counters Missing in SQL 2016 SP2 I thought that the answer (the first reply) was a good one, so I clicked to "like". What I expected to happen was what I'd seen on other ones that I'd liked and that after a minute or so, […]

Events

EightKB... I'm presenting! Bring your water-cooled helmet! :D - EightKB... I'm presenting! If you've not seen this one before, it will totally blow your mind. To summarize, in one of the most heterodixic SQL presentations you're likely to ever see, I destroy the myth of Random GUID fragmentation, show how they can be used to actually prevent fragmentation, and lay waste to what people […]

This email has been sent to {email}. 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.