.NET Dennes Torres in .NET Encrypting connection strings in web.config Encrypting web.config elements is a good security feature. Web.Config elements can include passwords and important keys that we need to... 01 August 2017 2 min read
Blogs William Brewer in Blogs Representing a simple hierarchical list in SQL Server with JSON, YAML, XML and HTML How difficult can it be to produce a simple hierarchical list in JSON, YAML, XML and HTML from a SQL... 18 July 2017 7 min read
Blogs William Brewer in Blogs The Fast Route from Raw Data to Analysis and Display There are very few real breakthroughs in IT. Most progress in the industry comes from pure effort and attention to... 18 July 2017 3 min read
Blogs Dennes Torres in Blogs Auto Starting SQL Server Agent I faced this problem some years ago. The company I was working for had a lot of clients with very... 17 July 2017 2 min read
Blogs Dennes Torres in Blogs Using R to illustrate relationships from graph objects My new article about Graph Database Objects was just published, it’s really a very good new feature. Another new feature... 06 July 2017 3 min read
Blogs William Brewer in Blogs Morphing the Monolith Microservices can certainly be made to work well for particular types of applications, but is it relevant to the mainstream?... 05 July 2017 3 min read
Phil Factor Statistics in SQL: The Mann–Whitney U test Imagine you have some data. Maybe you’ve done a web redesign and you want to do some A/B testing to... 30 June 2017 6 min read
Blogs Dennes Torres in Blogs SQL Server 2017: New ‘Queries with high variation’ Graph A few weeks ago I published an interesting article about how to use query store to identify parameterization problems. At... 30 June 2017 3 min read
Blogs Dennes Torres in Blogs New T-SQL Functions in SQL Server 2017 SQL Server 2017 brings us some new T-SQL functions. They are very simple to use, and can also help us... 28 June 2017 5 min read
Blogs Phil Factor in Blogs Is It Time To Stop Using IsNumeric()? The old system function IsNumeric() often causes exasperation to a developer who is unfamiliar with the quirks of Transact SQL.... 23 June 2017 12 min read
Blogs Andrew Clarke in Blogs 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
Blogs Dennes Torres in Blogs 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
Blogs Dennes Torres in Blogs 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
Blogs Tony Davis in Blogs 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
Blogs Dennes Torres in Blogs 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
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
