Other Phil Factor in Other 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
Other William Brewer in Other 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
Other Phil Factor in Other 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
Other Phil Factor in Other 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
Other Tony Davis in Other 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
Other Tony Davis in Other 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
Other Dennes Torres in Other 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
Other Simple Talk Editorial Team in Other 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
Other Tony Davis in Other 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
Other Tony Davis in Other 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
Other Tony Davis in Other 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
Other William Brewer in Other 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
Other Tony Davis in Other 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
Other Phil Factor in Other PSYaml: PowerShell does YAML PSYaml is a simple PowerShell module that I’ve written that allows you to serialize PowerShell objects to “YAML Ain’t Markup... 23 September 2016 17 min read
Other Phil Factor in Other 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
Other Grant Fritchey in Other 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
Other Dennes Torres in Other Careful With Trustworthy Setting Trustworthy database setting is an easy solution for some problems in the server, especially cross database access. However, this setting... 16 September 2016 2 min read
Other Tony Davis in Other 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
Other Phil Factor in Other Using Computed Columns and Scalar Functions in SQL Server for Text Transformations and Anagrams Use SQL Server computed columns with scalar functions to precompute text transformations - shown through two worked examples: finding textonyms... 31 August 2016 15 min read
Other Dennes Torres in Other Creating schemas without DBO permission One result of having the correct care with the access permissions in our databases is the need to avoid the... 31 August 2016 2 min read
