Monthly Archives: October 2017

Time is Precious

Posted on October 11, 2017 by way0utwest

I’ll hear people constantly say they don’t have time to work on their career. They can’t attend a UG meeting to network. They can’t spare a minute to go through a Stairway Series. They have family commitments, kids, hobbies, volunteer activities, … Continue reading →

Posted in Editorial | Tagged | 2 Comments

Citizen Scientists

Posted on October 10, 2017 by way0utwest

The last few years have seen quite a bit of demand for people that can analyze data. Certainly the Microsoft platform has embraced more ways to import and visualize data with tools like Power BI, more intelligent analysis with SQL Server … Continue reading →

Posted in Editorial | Tagged | Comments Off on Citizen Scientists

Don’t Use Code Coverage

Posted on October 9, 2017 by way0utwest

I got asked in a seminar recently how to perform code coverage for T-SQL. There aren’t a lot of options, but there is a project from Ed Elliot called SQLCover that looks to examine how much of your code gets called from … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Don’t Use Code Coverage

Using xp_delete_file

Posted on October 9, 2017 by way0utwest

First, this is an undocumented proc, and there’s nothing in BOL on this. Second, it’s a holdover from previous versions, so you’d be better served by using Powershell or some other type of scripting mechanism. This procedure is not supposed … Continue reading →

Posted in Blog | Tagged , , | 2 Comments