Other John Paul Cook in Other Simulating Bad Networks to Test SQL Server Replication SQL Server replication works well on a low latency, high bandwidth network. When actual networks have high latency or limited... 02 January 2018 8 min read
Other Phil Factor in Other Pivot Rotation and Matrix Transpose in SQL Server: A New Method? The question often comes up: how do you pivot data in SQL Server? In looking closer at the question, there... 12 December 2017 7 min read
Other John Paul Cook in Other Troubleshooting Failed PolyBase Installation in SQL Server 2017 This article shows you how to troubleshoot a failed installation of SQL Server and how to implement a workaround to... 12 December 2017 4 min read
Other Dennes Torres in Other Easy way to create policies using SSMS SSMS has an interesting feature that turns easy the creation of policies to check our servers compliance. Right-clicking an item... 09 October 2017 2 min read
Other Dennes Torres in Other Monitoring SQL Server with Power BI Query Store is becoming more and more important for server monitoring, specially in SQL Server 2017, which allows us to... 04 October 2017 2 min read
Other Phil Factor in Other SQL Server OPENJSON: Parse Hierarchical JSON into Relational Tables Use SQL Server OPENJSON to parse hierarchical JSON documents into relational table structures. Covers recursive and iterative approaches, EAV patterns,... 12 September 2017 14 min read
Dennes Torres How much should you worry about CXPACKET? Several experts already wrote about CXPACKET before, there are plenty of articles about this subject on the internet, so, why... 11 September 2017 3 min read
Dennes Torres Thoughts about submitting a new Power BI Quick Measure ‘Quick Measures’ is a feature included in Power BI Desktop April update. It’s still in preview, so you need to... 25 August 2017 5 min read
Other Dennes Torres in Other Monitoring UnmatchedIndexes Warning If you are using filtered indexes in SQL Server, it worthwhile monitoring the UnmatchedIndexes warning, it can give us very... 07 August 2017 4 min read
Other Phil Factor in Other Statistics in SQL: Student’s t-test Many undergraduates have misunderstood the name 'Students' in the t-test to imply that it was designed as a simple test... 03 August 2017 5 min read
.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
Other William Brewer in Other 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
Other William Brewer in Other 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
Other Dennes Torres in Other 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
Other Dennes Torres in Other 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
Other William Brewer in Other 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
Other Dennes Torres in Other 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
Other Dennes Torres in Other 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
Other Phil Factor in Other SQL Server IsNumeric vs TRY_CAST and TRY_CONVERT: Why IsNumeric Gives Misleading Results Why IsNumeric() returns true for values that can't actually be cast to numeric types - currency symbols, commas, scientific notation,... 23 June 2017 17 min read
