Managing a Data Leak in your Business

Even if we look past industry figures on frequency of cyber attacks, it is reasonably evident that cyber attacks are increasingly causing significant disruption and damage to businesses brand and reputation. Consequently, instead of asking “Is my business secure?” business executives must pose the question is, “Is my business prepared to timely detect and swiftly […]
Read More ›

The Word is Mightier than the Sword – Microsoft Word Tips

The power of Microsoft Word Microsoft Word has some very powerful hidden features that allow you to use the software much more efficiently. We have all been using the Mouse to navigate our documents for decades. But there is a real benefit of using the combination of the Keyboard and Mouse at the same time. […]
Read More ›

LINQ: The Good, The Bad, and The Poorly Optimized (Part 2)

Part 2: Controlling Parameter Optimization with Plan Guides For Part 1 of this series, see LINQ: The Good, The Bad, and The Poorly Optimized. T-SQL supports a variety of “hints”. They are hints in the same sense that your mother used to hint that it’s time to wash up and come to dinner. In other […]
Read More ›

LINQ: The Good, The Bad, and The Poorly Optimized (Part 1)

Part I: LINQ and sp_executesql Numerous questions raised in numerous forums mention that LINQ to SQL wraps queries in a call to the stored procedure sp_executesql. There seems to be agreement that this is done to ensure the caching of the query and query parameterization (if, indeed, parameters are supplied). Some advantages to sp_executesql, like […]
Read More ›

Analyzing SQL Server Data with R and RODBC

Down the Rabbit Hole with RODBC The most direct method for reading SQL Server data into the statistical program R is with ODBC. If R is running on a Windows system, this is straightforward using the R package RODBC. On a Linux system, the installation of RODBC is more challenging. Of course, RODBC requires a […]
Read More ›

Type to search

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.