| A community of more than 1,600,000 database professionals and growing |
| | Unlimited PTO Today we have a guest editorial as Steve is on vacation. 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 from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| ADVERTISEMENT | | How do you manage sensitive data? Redgate's Foundry team are researching data discovery and classification. Fill out this short survey if you think you can help, and at the end you'll be entered into a prize draw. Fill out survey |
| | 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 |
|
|
|
| | | Bill Pearson from SQLServerCentral.com As a part of his “Function / Iterator Pairs” mini-series, Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX COUNT() and COUNTX() functions, discussing similarities and differences. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating counts to meet differing needs within our PowerPivot model designs. More » |
| Press Release from Redgate Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan? More » |
| Additional Articles from MSSQLTips.com How can we be sure that the new DBAs are productive a soon as possible? How can we use highly qualified contractors in the most effective way from day one? More » |
| matthew.mcgiffen 73574 from SQLServerCentral Blogs I was discussing Cardinality Estimation with a colleague recently and the question came up, what cardinality does SQL Server use... More » |
| SqlBarbarian from SQLServerCentral Blogs With how many updates are coming out I threw together a script to parse the latest version from the webpage,... More » |
|
|
| | Today's Question (by Steve Jones): I write this in R: Exclamation <- c('SQL', 'Server', 'is', 'great!') If I want to return "SQL" and "Server", what should I do? |
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. |
|
|
| |
ADVERTISEMENT | The company's new IT initiative, code named Phoenix Project, is critical to the future of Parts Unlimited, but the project is massively over budget and very late. The CEO wants Bill to report directly to him and fix the mess in ninety days or else Bill's entire department will be outsourced. Get your copy from Amazon today. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have a table with a PK that is also the clustered index. I added this PK with the following code: ALTER TABLE dbo.Mycosts ADD CONSTRAINT MyCostsPK PRIMARY KEY (MyCostKey) I drop the PK constraint. What happens? ALTER TABLE dbo.Mycosts DROP CONSTRAINT MyCostsPK Answer: Both the PK and the clustered index are dropped Explanation: The answer is that both the constraint and the index that implements the constraint are dropped. Ref: ALTER TABLE - 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. Index-Filegroup (how many Files) - Hi, I have created an index filegroup (NonClustered) on a separate device. How many files do you recommend for this index... SQL 2016 SP1 CU2 - sudden and unexplained shutdowns - Hi there, Anyone had problems with unplanned instance shut-downs on SQL 2016 SP1 CU2? We patched our Data Warehouse to CU2 in... Upgraded to sql 2016 but I am still able to query and create tables with "text" data types. - I thought the text data type was deprecated in sql 2016? Anybody know why this occurs? Running balance - Hi guys, I need some help on running balance. I already got the ending balance. But I want also to... BULK Insert + create temperory table at the time of insert - How to Create temp table at the time of insert? DECLARE @sql AS NVARCHAR(1000) SET @sql = 'BULK INSERT ' + #tableName + ' FROM ''' + @filename + ''' WITH... Memory Needed More - We have server with 16 core 64GB RAM in Active\Passive Cluster,out of which 56GB is assigned to SQL Server. We... Correspond Row Data - Hello: I have this query: SELECT F.DocumentID, F., V.VariableID, V.RevisionNo, V.ValueText FROM MultipleApproval.dbo.Documents F INNER JOIN (SELECT DocumentID, VariableID, ValueText, RevisionNo ... Error : Connection failure. SQL Native Client is not installed correctly. To correct this, run SQL Server Setup. - Hi I am running Sql scripts through jenkins job. The jenkins job contains sql scripts like 1.Sql1 2.Sql2 3.Sql3 4.Sql4 5.Sql5 ..................................................... n.Sqln Database stuck in single user mode while restoring - Hi, We have a test database server instance with multiple databases on it. We restore a few of these databases on a... Replicate process from excel to sql - Hi All, I have a script that outputs data to a txt file which is then manipulated in excel to get yet... Long running insert - Hi Guys I have the following query which was taking a long time to complete 30 minutes or so. After creating... How to find the root cause of database growth – DATA FILE ? - Hi All , How much memory does SQL server Really need? - Hi All, How do we know how much memory does Moving from Simple to Full Recovery Mode - Hi I'm moving some of our busy production databases from Simple to Full recovery mode. Ideally I'd make the switch to... Monitoring Azure SQL DB - Does anyone have a good solution for monitoring Azure SQL DB databases? There are all kinds of good monitoring and... Fast Query - Slow Report Generation - Why? - I have a stored procedure (sp) that returns six to ten rows of data with ten columns, displaying five of... Why is my Package Connecton throughput dropping? - Hello, I'm using a 32bit Attunity provider and 32 bit Teradata Driver to connect to Teradata and execute a query... Designing and Architecture - Hi guys, I am new to architectural field and have some very common queries. I am moving my db servers... "syspolicy_purge_history" "PowerShell subsystem failed to load" - Anyone seen this error logged on a SQL 2008 Cluster? "syspolicy_purge_history" "PowerShell subsystem failed to load" Message The job failed. The Job was... delete rows from excel file in SSIS - Hello, Does any body has idea how to delete records (rows) from the excel file using SSIS. I have an Excel file... |
|
| 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 |
|
|