Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

Daily Coping Tip

Give your time, energy, or attention to help someone in need

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.

Unlimited PTO

This editorial was originally published on 12 Jul 2017. It is being republished as Steve is on holiday.

It’s still not what I would call mainstream, but many companies offer unlimited vacation as part of the benefit package. It sounds intriguing, but I bet you’re already thinking “too good to be true” or “read the fine print”. You’re right to think that there are limits - common sense prevails! But the limits are less restrictive than you might think, and that makes it worth considering.

Until last year every time I’ve been an employee vacation (paid time off, PTO) was a benefit that was well defined. Vacation was requested, approved, and tracked. Sometimes you could accrue it, sometimes it had to be spent by the end of the year, but overall there wasn’t much difference across employers. It’s a workable system, but the best one?

Last year I accepted a position that includes unlimited PTO. I was definitely cautious and a little cynical as I tried to understand what it meant at this company. One of my early questions was “what is the average number of days employees take off?”. The answer  was “we don’t know”. How can they not know?!

In this case it was because they made some deliberate choices. There is no approval process for vacations under three weeks - just book the time on a shared calendar. We also have flex time and location. I can work at home, the office, my favorite coffee spot, or wherever else. As long as you’re meeting your goals (which are reasonable) then use the plan to figure out a work life balance that works for you. It approaches the flexibility I’ve had when I was self employed.

Looking back at the first year I think I took three weeks off. This year I’m on track for one week a quarter, plus holidays. I work at home two days most weeks. I try for about 40 hours a week. Some weeks it’s more, some it’s less, and that’s nice - at most jobs it’s 40 or more, rarely less.

It won’t be a perfect fit for every team or every person. Some teams will need more structure, some people will want to be able to accrue time or not have to worry about someone thinking they are taking advantage. For me, it’s no contest - I much prefer the autonomy of taking time as I need it, whether it’s an hour or a week versus requesting and explaining that I want to leave at 2 pm to take my kids to Disney.

In closing, I’ll say this - don’t let the ambitious branding (unlimited!) throw you off. Definitely ask how it works and what the norms are, but if you want the flexibility, realize it requires both sides to trust each other.

Andy Warren

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

 
 Featured Contents
SQLServerCentral Article

T-SQL Language Changes in SQL Server 2022

Frank Dolan from SQLServerCentral

SQL Server 2022 is in preview in August 2022. I assume this version will be released later this year, and I have been testing it with the idea that I will be looking at an upgrade sometime in the next year for a few servers. There are a lot of changes in the database platform, […]

External Article

Estimated and Actual Plans Can Have Different Shapes.

Additional Articles from Brent Ozar Unlimited Blog

Hi Brent, What is your take on Hugo Kornelis’s explanation of execution plan naming. As her his explanation, estimated exec plan is simply an execution plan whereas actual execution plan = execution plan+run-time stats. Do you agree that the naming is flawed and confusing? – Yourbiggestfan

External Article

How to use fn_builtin_permissions SQL Server Security Function

Additional Articles from MSSQLTips.com

Learn how to find all securable objects in SQL Server and the permissions for each securable object using the system function fn_builtin_permissions.

Blog Post

From the SQL Server Central Blogs - pandas.DataFrame.drop_duplicates and SQL Server unique constraints

Meagan Longoria from Data Savvy

I’ve now helped people with this issue a few times, so I thought I should blog it for anyone else that runs into the “mystery”. Here’s the scenario: You...

Blog Post

From the SQL Server Central Blogs - New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo

Kenneth.Fisher from SQLStudies

I’ve added a new parameter to my permissions scripts (well, just the main two for now). Fair warning, it’s in ... Continue reading

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

The Migration Tool to Use

Which migration tool is suited to assess my SQL Server data estate and lift and shift my estate to SQL Server on Azure VMs?

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)

EXCEPT Details

What is the proper description for the EXCEPT operator?

Answer: returns distinct rows from the left input query that aren't output by the right input query.

Explanation: From BOL: EXCEPT returns distinct rows from the left input query that aren't output by the right input query. Ref: EXCEPT - https://docs.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-except-and-intersect-transact-sql?view=sql-server-ver16

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 - Administration
Unable to Communicate to SQL 2005 via Linked Server - Hi all, I'm having issues communicating via a linked server from a Windows 2019 Standard server running SQL 2017 Standard to a Windows 2003 R2 Enterprise server running SQL 2005 Standard. The operating system on the source server was just upgraded from Windows 2012 R2. Error: OLE DB provider "SQLNCLI11" for linked server "server" returned […]
SQL Server 2016 - Administration
Extended Events: using ATTENTION Event to log external apps timeouts. - The purpose I created the attached Session and one of the queries to view data and periodically reload it to the table WAS BECAUSE once in a couple of weeks we have had this nasty bottleneck in our environment when instead of an average of 40 or 50 timeouts (from ASP web pages/IIS) per day […]
Is it possible to purge Extended Events file (target) contents? - Is it possible to purge the Extended Events file's (target) contents WITHOUT deleting the file or dropping and recreating the session?
SQL Server 2016 - Development and T-SQL
SQL convert Rows to columns - I have seen several posts on this many of which suggest Pivot. I am trying to mimic a MS Access report that used VBA to format the columns. I have been working on this for awhile and I am still no closer to solving it, here is the Problem. Some of my attempts have involved […]
Administration - SQL Server 2014
Upgrade 2014 Web Edition to Standard - Hello. I'm working with a client who currently has a SQL 2014 Web Instance which I am considering upgrading to SQL 2014 Stanard. Can this be achieved by installing a Standard edition SKU or will a reinstall or full upgrade be needed? I have no real knowledge of Web edition so am looking for some […]
SQL 2012 - General
Implementing TLS In sql server 2012 - Hi Experts, In my project we have 2 servers Webserver and one is database server . We are planning to Implement the TLS in the database server and our DBA can handle the the step to implement TLS on the database server. My query is what all changes we have to do on the Webserver […]
SQL Server 2012 Stored procedure question - In the program I'm working with, I need to build a stored procedure just to create a field in the cms editor drop down. It is very basic, or so I thought. I just want to test the field for a value and if it is there, print a line of text. That's it. It […]
SQL Server 2019 - Administration
Azure SQL Server - consideration - There are a few options for Azure SQL Server Vanilla Azure SQL Server (SaaS) Azure SQL Server using VM image (IaaS) Azure SQL Server Alwayson I'm trying to understand what option replaces the best an on-premises SQL server accessed by multiple servers, that will become multiple "callers" in Azure.
SQL Server 2019 - Development
Flow Control Problem with multiple statements - I am creating a function that should retrieve a numerical value from notes. This can be represented a few different ways and I used a number of IF Statements to accomplish this. For some reason, it seems to be executing code in the Final IF Statement. The simplified code at the top works and produces […]
SQL Azure - Administration
Azure Data Studio - SQL Profiler - save or export results to table - I can launch SQL profiler (Alt P) using Azure Data Studio and can see the system logs on the screen. However, when I stop the trace session on the screen, and change the [Select View] option on the top right, all the data that was collected initially gets lost. How to save the results of […]
General Cloud Computing Questions
Gaining Practical Experience in Cloud - Hi All, I have worked in IT for a little over 10 years, starting in helpdesk, and working my way up to an enterprise systems administrator role, and finally ending up in Internal Audit as an IT Auditor. In my current role as an auditor I get to see a lot of different technology, but […]
Reporting Services
Ratio from Metrix - Hello Calculating ratio from metrix - or if you have other way of doing it please ratio is SUM of A for 2018 divided by SUM of B for 2018 multiplied by 100 for percentage purpose Please see attached file to see whats given and required 75 = ( 300/400)*100 Thanks
ssrs calculation not working - I have a SSRS report that i need to calculate the Variance percent totals which the math logic goes Occupied Variance % - Vacant Potiental percent - Damaged Potiential percent Occupied Variance = 5% Cacant Potiental = -5% Damaged Potiential = -3% so it 5% -(-5%) -(-3%) How do i write this in a SSRS […]
Continuous Integration, Deployment, and Delivery
CI/CD to deploy database using Gitlab - Hello, I want to do CI/CD do deploy database (sql server) and ssis package using Gitlab , but the problem i don't know how can i start and also i didn't fount any tuto on the internet. Can someone help me how can i start to do that ? and also if possible to do […]
Integration Services
Transfer SQL Table Data into Excel - Hi everyone, I have designed a SSIS package that transfers SQL table data into an excel file. I am fetching data via this query: /****** Script for SelectTopNRows command from SSMS ******/ SELECT CONVERT(NVARCHAR(4000),[LIST_TYPE]) AS LIST_TYPE ,CONVERT(NVARCHAR(4000),[LIST_CATEGORY]) AS LIST_CATEGORY ,CONVERT(NVARCHAR(4000),[LIST_SUBCATEGORY]) AS LIST_SUBCATEGORY ,CONVERT(NVARCHAR(4000),[LIST_DESCRIPTION]) AS LIST_DESCRIPTION ,CONVERT(NVARCHAR(4000),[LIST_VERSION]) AS LIST_VERSION ,CONVERT(NVARCHAR(4000),[T2_CODE]) AS T2_CODE ,CONVERT(NVARCHAR(4000),[T2_TYPE]) AS T2_TYPE ,CONVERT(NVARCHAR(4000),[T2_NAME]) […]
 

 

RSS FeedTwitter

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.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -