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 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 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 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 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 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
Blogs Tony Davis in Blogs When Stored Procedures Go Bad It is far easier to work out what is wrong with a slow-running SQL query than one that shows erratic... 04 November 2016 3 min read
Blogs William Brewer in Blogs Skilling and De-skilling Not long ago, I was having to do a fairly simple DBA task onsite. It involved database provisioning by copying... 20 October 2016 3 min read
Blogs Tony Davis in Blogs Removing the Clutter from Graphs You can quickly get an audience to see patterns and trends in data if you present that data graphically. Data... 04 October 2016 3 min read
Blogs Phil Factor in Blogs On Being Economical with the Truth A while back, I attended a presentation about a suite of software that allowed IT managers to track in some... 21 September 2016 3 min read
Blogs Grant Fritchey in Blogs SQL Server Geeks Annual Conference A couple of weeks ago I was privileged to be able to travel out to Bengaluru in India to attend... 20 September 2016 5 min read
Blogs Tony Davis in Blogs JSON and the Arguments Now that we’re getting better support for storing JSON (JavaScript Object Notation) in databases, what is it really giving us?... 08 September 2016 3 min read
Blogs Tony Davis in Blogs Why is Uninstalling SQL Server Such a Pain? A developer friend of mine recently, upon the briefest mention of SQL Server, descended unexpectedly into a rant about the... 30 August 2016 3 min read
Blogs Tony Davis in Blogs Software Animism The tendency to attribute malice to inanimate objects is deeply entrenched in the human psyche. In a famous account from... 11 August 2016 2 min read