| A community of more than 1,600,000 database professionals and growing |
| | | A Good Benefit? I'm wondering what you think. Is the idea of trading some paid time off (PTO) for student loan debt relief a good idea? That's what Unum, an insurance company, is offering. They give their employees 28 days off, which is quite generous. I don't know many people that get than many days off. If employees wish, they can trade up to 5 days for the equivalent salary, which is used to give them money for their student loans, or their children's. It's a creative offer, and one that doesn't force people to forego vacation, as they'd still have more than four weeks of time to take off. In the US, most people don't take their entire vacation allowance when it's over two weeks. This gives them a chance to pay down some debt with minimal impact on their work life balance. At least, minimal for me. I struggle to take my 25 days, so this is a trade I'd make. The downside, to me, is that there may be plenty of employees that don't have student loan debt. They don't get a choice here, which feels unfair. I'd much rather the company offer employees the chance to sell back up to five days and use that payment for anything. After all, plenty of people have debt that isn't related to education. Why not give them a chance to reduce other obligations? I am not quite sure of what I think of companies becoming more involved in employee's personal lives. We are in a more freelance, gig economy where people change jobs regularly and often may work remotely. For me, I tend to favor the approach from Basecamp where the company treats people fairly and create an environment where employees are respected and want to work for a long time. While I know this is hard for many companies, and certainly hard to change, I do think more organizations could improve their culture and treatment of employees. I'm very lucky in that I work for a company that's amazing. Redgate Software is the kind of company I'd want to create if I built another organization, and I have a fantastic set of co-workers, managers, and benefits. We are growing and hire here and there, and if you're interested, I can't recommend this organization enough. Can you say the same thing about your employer? Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| | The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.4MB) podcast or subscribe to the feed at iTunes and Libsyn. The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT | | | | CI/CD for your SQL Server database Feeling the pain of managing and deploying database changes manually? Redgate SQL Change Automation completes your database delivery process by building, testing, and deploying the database changes you and your team check into version control.
Try it free |
| |
|
|
| | | | | Using dynamic SQL is unavoidable at times, but it is reckless to execute dynamic SQL that is created directly from strings that include values that change at execution time. It can allow SQL Injection and it is also inefficient. More » |
| | Additional Articles from Brent Ozar Unlimited Blog Distributed source control is really intimidating: branches, pull requests, merges – will somebody just take my code, for crying out loud? Why does it have to be so complicated and involved? More » |
| | Steve Jones from SQLServerCentral Blogs I’m not writing a post here on how to manage your money, but I will point you to Troy Hunt’s... More » |
| | MarlonRibunal from SQLServerCentral Blogs Note: I’ve been meaning to start a series on the basics of SQL Server Reporting Services (SSRS). The last time... More » |
|
|
| | | Today's Question (by Steve Jones): On SQL Server 2017, I have a brand new database with no objects. I run this code: CREATE PROCEDURE dbo.GetOne AS SELECT 1 GO CREATE PROCEDURE dbo.GetOne;2 AS SELECT 2 GO How do I execute a stored procedure and get a result of 2? |
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: Stored Procedures. 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 | Design and configure SQL Server instances and databases in support of high-throughput applications that are mission-critical and provide consistent response times in the face of variations in user numbers and query volumes. Learn to configure SQL Server and design your databases to support a given instance and workload. Pick up your copy of this great book today at Amazon today. |
|
|
|
|
|
| | ADVERTISEMENT | | Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server helps you bring the productivity and user-satisfaction of flexible and responsive applications to your organization safely and securely. Your organization’s increased ability to respond to rapidly changing business scenarios will build competitive advantage in an increasingly crowded and competitive global marketplace. With a focus on new applications and modern database architecture, this edition illustrates that dynamic SQL continues to evolve and be a valuable tool for administration, performance optimization, and analytics. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have created this table in SQL Server 2017. CREATE TABLE dbo.SalesOrderHeader ( OrderKey TINYINT IDENTITY(1, 1) , CustomerName VARCHAR(30) ) GO INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Andy') INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Brian') INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Steve') GO I now have completed testing, so I do this: DBCC CHECKIDENT('dbo.SalesOrderHeader', RESEED, 0) GO If I run this code, what value is returned for IDENT_CURRENT() and what value is added for the OrderKey for the row with Azure? SELECT IDENT_CURRENT('dbo.SalesOrderHeader') GO INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Azure') SELECT * FROM dbo.SalesOrderHeader AS soh GO
Answer: IDENT_CURRENT = 0 and OrderKey = 1 Explanation: In this case, when the RESEED takes place, the current value is set to 0. However, when the row is inserted, the SEED is used + the INCREMENT for the identity value. Ref: IDENT_CURRENT() - click here DBCC CHECKIDENT() - click here Identity Property - 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 Database Administrator Interview Questions - As a beginner DBA I am really interested what kind of question do employers ask while interviewing for a position... Memory consumption is > 90% - I was working today with the internal infrastructure admin and their alarms started ringing as the memory was spiking >... Purging Data - Hello All, Please let me know how to purge data in production. Security roles - All, Firstly I'm not necessarily asking for a complete answer. I'm happy to be pointed in the right direction to solve... Clustering Vs Always on - For 2 node cluster setup, my understanding is the i need to configure two different servers as part of one... Generate SQL-script that creates all logins with appropriate permissions - Hi, colleges. How can I create a script that contains information for creation all SQL-logins including database users with all permissions? It'll... Index on #tmp without PK - Hello! If I create a index on a #temp table, without create a Primary Key, the index will work ? It´s necessary... Group by companyid with Latest date - Hi Team, Can you please help me on this below query. create table #test ( companyid int, companyname varchar(100), actiondate datetime ) insert into... SSIS packages slow BCP processing - We are using SSIS packages to just do a data transform and map from one table to another. Within SQL Profiler... Easy way to replicate SSRS Multi-Select Parameter from SSRS in TSQL? - When attempting to diagnose issues with SSRS Reports, I often run into an issue where there is a multi-select parameter... Trying to export data into csv file using bcp stored procedure - Can someone please help me with explaining why I am getting the error shown in the attached file? Thank You in... heat map as sql function or proc - Does anyone have a good heat map function or proc that takes three params. TheValue, MinOfAllValues, and MaxOfAllValues. It return... How to connect to git in SQL Server 2016/2017 without using any third party tool - I was curious to know if we can connect to Git in SQL Server Management Studio without using any third... Optimizing a dynamic sorting SQL query - This query (I've simulated it to show you. Otherwise, it is longer with many more lists of columns, some more... Tuning Query In Stored Procedure - Below table contains five millions of records. My Table Structure CREATE TABLE .( (50) NOT NULL, (2) NOT NULL, ... Run job from server after completion of first job from different server. - Hello, We have two snapshot replication job running from two different server (domain). UAT - Snapshot 1 DEV - Snapshot 2. We need to run Snapshot... Split Date into From and ToDate - Hi friends, I would like to split the date into from and to date range based up on Quantity change and... Window Function - Hello, Good evening. I am trying to find the latest checking lot no based on each receiving which matches with available with... xlsx error: “Removed Records: Named range from /xl/workbook.xml part” when tried to resolve errors - I have an xlsx file that I generate using SSIS. The data to this file is written through a data... Cannot attach a database that was being restored. - I am trying to restore a database from copies of data file and log file from a database thats in... |
|
| This email has been sent to [email protected]. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the [email protected]. | 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: [email protected] |
|
|
