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
Blogs Tony Davis in Blogs Bridging the DevOps Divide What’s the main obstacle to implementing a DevOps approach in your organization? In a recent “State of DevOps” survey conducted... 05 January 2017 3 min read
Blogs Dennes Torres in Blogs How to allow nulls in unique fields An interesting workaround using unique fields Unique fields in SQL Server are created using unique constraints or unique indexes, furthermore,... 27 December 2016 2 min read
Blogs Simple Talk Editorial Team in Blogs Trouble with TLAs? Our Agony Aunt Advises Dear Marjorie, I try my best to keep up with the latest technology. I even read “IT Trends Monthly” religiously,... 16 December 2016 3 min read
Blogs Tony Davis in Blogs The Dangers of TechnoMarketingBabble Everyone’s encouraged to be a content producer these days. It’s not marketing, it’s content! Sometimes the tell-tale signs are obvious.... 01 December 2016 3 min read
Blogs Tony Davis in Blogs Virtue in the Virtual Are we now seeing just a frisson of excitement amongst database professionals at the potential of virtualization, and containerization technologies?... 21 November 2016 3 min read
