Using SQL Server and R Services for analyzing DBA Tasks (SQLServerCentral 2/22/2019)

[SQLServerCentral - www.sqlservercentral.com]( A community of more than 1,600,000 database professionals and growing Featured Contents - [Using SQL Server and R Services for analyzing DBA Tasks]( - [The risks of using EXECUTE (‘SQL Script’)]( - [An Introduction to GitHub for DBAs]( - [Financial Advice for Techies]( (From the SQLServerCentral Blogs) - [SQL Server 2017 Reporting Services: The Basics Part 2]( (From the SQLServerCentral Blogs) The Voice of the DBA 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.com]( Join 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](. [feed]( 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 [SQL Change Automation]( 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]( [GDPR](www.red-gate.com/gdpr?utm_source=ssc&utm_medium=pubemailad&utm_content=gdpr-ready&utm_campaign=GDPR&utm_term=20190222-slot2) How to make your SQL Server development GDPR ready Redgate’s SQL Data Privacy Suite helps you to build a data catalog of your SQL Server estate, and put in processes to protect and monitor personal information. [Find out more about how our tools help with GDPR compliance](www.red-gate.com/gdpr?utm_source=ssc&utm_medium=pubemailad&utm_content=gdpr-ready&utm_campaign=GDPR&utm_term=20190222-slot2) Featured Contents  [] [Using SQL Server and R Services for analyzing DBA Tasks]( Tomaž KaÅ¡trun from [SQLServerCentral.com]() Article shows how R Services can help database administrators with their daily work [More »](Language/151405/) ---------------------------------------------------------------  [] [The risks of using EXECUTE (‘SQL Script’)]( 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 »]( ---------------------------------------------------------------  [] [An Introduction to GitHub for DBAs]( 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 »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Financial Advice for Techies]( 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 »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [SQL Server 2017 Reporting Services: The Basics Part 2]( 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 »]( Question of the Day 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 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 2017]( : [SQL Server 2017 - Administration]( [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... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Administration]( [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... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Development and T-SQL]( [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... --------------------------------------------------------------- [SQL Server 2014]( : [Development - SQL Server 2014]( [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,  ... --------------------------------------------------------------- [SQL Server 2012]( : [SQL 2012 - General]( [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... --------------------------------------------------------------- [SQL Server 2012]( : [SQL Server 2012 - T-SQL]( [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... --------------------------------------------------------------- [Data Warehousing]( : [Integration Services]( [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... --------------------------------------------------------------- [SQL Server 2005]( : [Administering]( [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}. 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