Analysing Sales Patterns: R + SQL Server (SQLServerCentral 8/18/2017)

[SQLServerCentral - www.sqlservercentral.com]( A community of more than 1,600,000 database professionals and growing Featured Contents - [Analysing Sales Patterns: R + SQL Server]( - [Database Code Analysis]( - [Learning through gaming a SQL Server tale]( (From the SQLServerCentral Blogs) - [Being a Positive Influencer]( (From the SQLServerCentral Blogs) The Voice of the DBA Failed Projects This editorial is from way back, published in 2005, but perhaps still a good one today. This is being re-run as Steve is at the Data Platform Summit. Friday is poll day, at least as long as I can be creative with them. And of course, remember to put them out on the right day [Smile]This week is more of a software development issue than a strictly SQL Server one, but take it how you will and get your post in here for everyone to see. Humility and responsibility are the keys this week. So without further ado... Have You Ever Failed In A Software Project? A simple yes or no would suffice for the poll question, but I'll set an example and give you my answer with an explanation. The short answer is yes. The longer one is abbreviated in the interests of space, but I have made an attempt to set things as I best remember them. When I came to Denver 7 years ago, it was with a startup company in the financial services market with a few simple software products, but some trouble getting them stable and focusing the IT group. I was excited at the opportunity, the dot com boom was, well, booming, and I was thinking I'd make a million with this company. Fast forward 2 years and I resigned, somewhat burned out, and thinking I'd done everything I could. Thinking back I think I had done lots and given a lot, but I still failed and part of it was me not taking a leadership role more than I did and part of it was getting burned out and part of it was not really forcing the company to stop and make good decisions regardless of the time involved. I instead put up a bit of a fight, but then went along with the constant "just patch it" and we ended up burning most of a year getting nowhere because the underlying base products were a mess. I resigned, the company lost about 30% of the development staff, floundered for a couple years and was sold. Not sure anyone made money on that deal. As I've looked back, I realize it was a dysfunctional company, but I think I could have made a difference, stepped up as CTO (it was offered to me) and driven things forward. Oh well, I learned quite a bit from the experience and grew from it. Steve Jones from [SQLServerCentral.com]( Join the debate, and [respond to today's editorial on the forums]( ADVERTISEMENT [SQL Clone]( 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]( [SQL Compare]( The industry standard for comparing and deploying SQL Server database schemas Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. [Download your free trial]( Featured Contents  [] [Analysing Sales Patterns: R + SQL Server]( Nick Burns from [SQLServerCentral.com]() We show how to use RevolutionR to analyse & visualise purchasing behaviours in AdventureWorksDW2012.[More »]( ---------------------------------------------------------------  [] [Database Code Analysis]( Additional Articles from [SimpleTalk]() Database code analysis will reduce the number of 'code smells' that creep into your database builds. It will alert the team to mistakes or omissions, such as missing indexes, that are likely to cause performance problems in production. It will allow the Governance and Operations team visibility into production readiness of the code, warning them of security loopholes and vulnerabilities. William Brewer describes the two technical approaches to database code analysis, static and dynamic, and suggests some tools that can help you get started.[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Learning through gaming a SQL Server tale]( Daniel Janik from [SQLServerCentral Blogs]( I’ve been teaching my 17 yr old SQL Server and other various topics. I have quite a bit of experience...[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Being a Positive Influencer]( Grant Fritchey from [SQLServerCentral Blogs]( I read a lot of self-help and improvement information. I’m always trying to hack my brain or my attitude to...[More »]( Question of the Day Today's Question (by Steve Jones): I want to change the name of the share used by my SQL Server Filestream share. Where do I change this? 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: Administration. 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 [Securing SQL Server: DBAs Defending the Database]( tag=redgatsof-20 linkCode=as2 camp=1789 creative=9325 creativeASIN=1484222644) Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy, performing threat analysis, and encrypting sensitive data as a last line of defense against compromise. The multi-layered approach in this book helps ensure that a single breach doesn't lead to loss or compromise of your data that is confidential and important to the business. [Get your copy from Amazon today](. Yesterday's Question of the Day Yesterday's Question (by Steve Jones): I've captured a trace on a SQL Server 2012 instance that I want to replay on a different instance for upgrade testing. What versions of SQL Server can I target to replay this trace on and be supported by Microsoft? Answer: SQL Server 2012 and SQL Server 2014 Explanation: An input trace from SQL SErver 2012 can only be replayed (in a supported way) on SQL Server 2012 and 2014. Ref; Distributed Replay Requirements - [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 2016]( : [SQL Server 2016 - Administration]( [How to enable SQL to connect with servername\instance with 2 node sql cluster?]( - Hello, How can I make it available to connect to sql using servername\instance name with a SQL 2 node cluster?  If... [reboot server configured with AlwaysOn setup]( - hi i have 3 node server with alwaysOn setup 1-primary 2 -secondary 3-secondary. wanted to reboot any of them, is there any... [SA Password Unknown]( - Hi to all. SQL 2016 was installed in mixed mode. I cannot recall specifying SA password for a particular instance... [how to deploy 10 T-SQL scripts across 200 databases]( - Hi , Can any one suggest an efficient way where we can apply about 10 T-SQL scripts on about 200 databases... [Error 0x80070057 when creating maintenance plan]( - Hi, I have just installed a new default instance SQL 2016 DEv CU2 Windows 2012R2 Standard Basic features: DB , search,... --------------------------------------------------------------- [SQL Server 2014]( : [Administration - SQL Server 2014]( [TDE Certificate backup]( - Hi Guys, I am trying to backup a certificate that I created for TDE but I am not successful. Please see... --------------------------------------------------------------- [SQL Server 2012]( : [SQL 2012 - General]( [Search a string in entire datababe]( - Is there a script to search a string stored in all cell of all tables? For example, I want to find... [SET NOCOUNT ON at instance level - not working.]( - Hello Members, I have configured nocount as default connection property using following command. EXEC sp_configure 'user options', 512. Unfortunately, when I connect... --------------------------------------------------------------- [SQL Server 2012]( : [SQL Server 2012 - T-SQL]( [Trying to determine what might be causing skipped values in an IDENTITY column]( - I've got a tough problem which comes back occasionally to plague me. I have to help maintain a legacy MS... [Query performance tuning - Slow execution time]( - I've been tasked with performance tuning the underlying query. I have attached all the necessary details but if there is... [Time increments]( - Hi, I want to have a calculated field "TimeIncrements' that will increment 20 minutes starting at 8:00 and ending at 5:00... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 - General]( [Update same row twice]( - I know this is illegal with a merge, but is there a way to update the same row twice with... --------------------------------------------------------------- [SQL Server 2008]( : [T-SQL (SS2K8)]( [pulling records from a table between date ranges in another table]( - This seems simple enough but for some reason, my brain isn't working. I have a lookup table: Table A: basically dates every... [Subroutines in TSQL]( - I am a heavy TSQL coder, I love the many aspects of TSQL but I always wonder why we should... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 Administration]( [Can I restore a single file .mdf to multiple files spread across disks]( - I am trying to create a 2nd copy of my database which is 200GB so that I can do Log... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 Performance Tuning]( [Enormous Page Life Expectancy (PLE)?]( - I've been running perfmon and analysing the results on a production Windows 2008 R2 server running SQL Server 2008 R2... --------------------------------------------------------------- [Data Warehousing]( : [Integration Services]( [Using dtexec to execute a file system package with project level connection managers]( - I'm new to SSIS. I'm trying not to be a help vampire ;-)  pdwyer/e/eoc/help_vampire.htm I've read --------------------------------------------------------------- [SQL Server 2005]( : [Administering]( [Problems querying a linked server from a SQL Agent job]( - First of all, where are the SQL Server 2008 forums? So here's my setup. I created a linked server to a... --------------------------------------------------------------- [SQL Server 2005]( : [SQL Server 2005 Integration Services]( [Error running SSIS package]( - Hi, We get an error running a SSIS package which calls another package. Both packages execute Ok independently. Error: "The LoadFromSQLServer... --------------------------------------------------------------- [SQL Server 7,2000]( : [T-SQL]( [Extract filename from fully qualified path]( - I have a varchar(255) column that contains the fully qualified path for a file. For example: C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyFile.txt I need to... 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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com