Author Archives: Merle

Cheat Sheet–Installing In-Database R on SQL Server 2016

Installing R on SQL Server 2016 is simple. Microsoft’s documentation is great, but this cheat sheet is a handy reference. Installing In-Database R requires four steps. 1 – Install R Services (In-Database) on the SQL Server instance in question.  This … Continue reading

Posted in Database Administration | Tagged , , | Leave a comment

SQL Server Management Studio (SSMS) Cannot Script SQL Agent Jobs

I have been testing SSMS 2016 and I wanted to script out some SQL Agent jobs.  When attempting to do so, I ran across an error. Discover dependencies failed.  Job is not supported in dependency discovery. The description under additional … Continue reading

Posted in Database Administration, SQL Server Management Studio | Tagged , , | Leave a comment

Updated Kimball Group Reader

If you are student of Ralph Kimball, I am sure you had mixed emotions when he retired.  The good news is Margy Ross & Bob Becker are still going strong.  They are doing business at DecisionWorks Consulting http://decisionworks.com/.  There is … Continue reading

Posted in Data Warehouse | Tagged , , | Leave a comment

SQL Server 2014 TempDB Improvements

I am not sure how I missed this.  There is a performance improvement in TempDB in 2014. In summary, TempDB will be less aggressive writing to disk.  Here is the CSS page about it from April 2014.  https://blogs.msdn.microsoft.com/psssql/2014/04/09/sql-server-2014-tempdb-hidden-performance-gem/

Posted in Database Administration | Tagged , | Leave a comment

SQL Saturday #421 (Columbus, OH) Summary

SQL Saturday #421 was an excellent event. The Columbus session was held at a new venue.  I think the venue is better than the previous one.  All the rooms had desks which was nice for taking notes.  The rooms didn’t … Continue reading

Posted in Database Administration, Training | Tagged , , , , | 1 Comment

SQL Server 2016

I try to avoid simply posting a link in this blog but there are some significant changes coming in SQL Server 2016 so I am going to break my own rule. http://blogs.technet.com/b/dataplatforminsider/archive/2015/05/04/sql-server-2016-public-preview-coming-this-summer.aspx The encryption feature is certainly timely but I … Continue reading

Posted in Database Administration | Tagged | Leave a comment

Finding SSRS Reports Without A Data Source

When deploying reports to different environments it is possible to have reports not link to a data source.  These reports are unusable and it can be time consuming to find them if there are a lot of reports.  I knew … Continue reading

Posted in SQL Server Reporting Services | Tagged , , | Leave a comment