Blogs Phil Factor in Blogs Statistics in SQL: The Kruskal–Wallis Test Before you report your conclusions about your data, have you checked whether your 'actionable' figures occurred by chance? The Kruskal-Wallis... 01 June 2017 4 min read
Blogs Dennes Torres in Blogs Simultaneous Auto-growth in Multiple Files SQL Server 2016 has a new configuration to control the auto-growth of multiple files in the same filegroup. When we... 27 May 2017 4 min read
Blogs William Brewer in Blogs WannaCry Over Spilled Data The WannaCry ransomware attack has highlighted a serious problem. If there is negligence in your IT strategy, you are increasingly... 24 May 2017 3 min read
Blogs Phil Factor in Blogs The Need for Database DevTest The first and overriding thought of the experienced developer given any new development task is, or should be, ‘How the... 09 May 2017 3 min read
T-SQL Programming Phil Factor in T-SQL Programming Visual Checks on How Data is Distributed in SQL Server There are many reasons for wanting to know how data is distributed. Sometimes you just want a rough idea of... 05 May 2017 12 min read
Blogs Tony Davis in Blogs Python in SQL Server Anyone using R in SQL Server employs the procedure sp_execute_external_script, the first parameter of this being the language to use.... 26 April 2017 3 min read
Blogs William Brewer in Blogs Generating HTML from SQL Server Queries You can produce HTML from SQL because SQL Server has built-in support for outputting XML, and HTML is best understood... 21 April 2017 11 min read
Blogs Phil Factor in Blogs Statistics in SQL: Simple Linear Regressions Although linear regressions can get complicated, most jobs involving the plotting of a trendline are easy. Simple Linear Regression is... 13 April 2017 4 min read
Blogs Phil Factor in Blogs Statistics in SQL: Kendall’s Tau Rank Correlation Statistical calculations in SQL are often perfectly easy to do. SQL was designed to be a natural fit for calculating... 10 April 2017 6 min read
Blogs Tony Davis in Blogs The Oxford Comma and Me Many people in IT, even at Redgate where I work, see the job title “Editor” and think I spend most... 07 April 2017 3 min read
Blogs Phil Factor in Blogs Statistics in SQL: Pearson’s Correlation Some people will assure you that you can't do any serious statistical calculations in SQL. In the first of a... 06 April 2017 3 min read
Blogs Tony Davis in Blogs Avoiding the Slide From DevOps to DevOops If you roll out DevOps across an organization before it is culturally prepared for it, you will see warning signs... 27 March 2017 3 min read
Blogs Tony Davis in Blogs Glasnost in IT: Discarding the Old Certainties Three of Redgate’s tools are now part of the 2017 release of Visual Studio Enterprise (as announced last week), as... 13 March 2017 3 min read
Blogs Tony Davis in Blogs Old is the New New: SQL Server 2016 Learns Ancient Auditing Tricks The new temporal tables in SQL Server 2016 are interesting, in that they seem a much better way of storing... 06 March 2017 3 min read
Blogs Rodney Landrum in Blogs A Quick Look At Two New DMV Columns for Tuesday I have learned over the years that some people really like it when I am verbose, long-winded, redundant and carry... 14 February 2017 3 min read
Blogs Phil Factor in Blogs String Comparisons in SQL: The Metaphone Algorithm When exploring the use of the Metaphone algorithm for fuzzy search, Phil couldn't find a SQL version of the algorithm... 14 February 2017 10 min read
Blogs William Brewer in Blogs The Harsh Reality Behind Big Data Misuse Big Data has its origin in science, but it is now being used commercially to increase the information that organizations... 10 February 2017 4 min read
Blogs Phil Factor in Blogs Metaprogramming Over the history of personal computing, it seems that the best software was written by a team of five or... 02 February 2017 3 min read
Blogs Phil Factor in Blogs Kadane’s solution to the Maximum Subarray problem Sometimes, you can be asked an awkward question about data that doesn't quite fit with the SQL way of thinking.... 25 January 2017 8 min read
Blogs Tony Davis in Blogs Tying Down the Source Code Database source code analysis can flush out weakly-authenticated database users, over-privileged users and roles, or stored procedure code that concatenates... 19 January 2017 2 min read
