Category Archives: Database Administration

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

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

Installing SQL Server 2014 Data Tools

I noticed that SQL Server Data Tools (a.k.a. BIDS) was not listed under Shared Features on the SQL Server 2014 Developer DVD. So where did it go?  With SQL Server 2014, there is a link on the Installation Center window … Continue reading

Posted in Database Administration, Development, SQL Server Integration Services, SQL Server Reporting Services | Tagged , , | Leave a comment

Teradata SQL Assistant Options for SQL Server Users

At first glance SQL Assistant seems quite different from SQL Server Management Studio.  However there are two options that go a long way in making SQL Assistant behave more like SSMS.  The first option to set will display all databases … Continue reading

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