Other Andrew Clarke in Other Working From Home The idea that one can do nothing useful as a developer unless you are in an open plan office is... 20 June 2017 3 min read
Other Dennes Torres in Other SQL 2017 new DMF: Managing VLOGs in our databases SQL Server 2017 brings to us some new interesting DMV’s and DMF’s, one of them is sys.dm_db_log_info. This new DMF... 20 June 2017 4 min read
Other Dennes Torres in Other Filtering Errors in PowerBI I just faced this problem when trying to analyze some information from google analytics in PowerBI. In my specific situation,... 09 June 2017 2 min read
Other Tony Davis in Other To Fly, To Serve, To Fry Your Servers So, the story goes that an Ops engineer walked into a data center with the necessary pass, a cheery wave... 08 June 2017 3 min read
Other Dennes Torres in Other News for Differential Backup SQL Server 2017 brings several improvements to us. Sometimes a simple new field in a DMV can turn possible interesting... 02 June 2017 4 min read
Other Phil Factor in Other 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
Other Dennes Torres in Other 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
Other William Brewer in Other 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
Other Phil Factor in Other 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
Other Tony Davis in Other 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
Other William Brewer in Other Generate HTML Tables & Lists from SQL Server Queries Learn how to generate HTML tables, directory lists, and hierarchical lists directly from SQL Server using FOR XML PATH. Includes... 21 April 2017 12 min read
Other Phil Factor in Other 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
Other Phil Factor in Other 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
Other Tony Davis in Other 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
Other Phil Factor in Other 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
Other Tony Davis in Other 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
Other Tony Davis in Other 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
Other Tony Davis in Other 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
Other Rodney Landrum in Other 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
