Blogs William Brewer in Blogs Generating HTML from SQL Server Queries You can produce HTML from SQL because SQL Server has built-in support for outputting XML, and HTML is best understood... 21 April 2017 11 min read
Blogs Phil Factor in Blogs 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
Blogs Phil Factor in Blogs 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
T-SQL Programming Robert Sheldon in T-SQL Programming Questions About SQL Server Collations You Were Too Shy to Ask Of course we all like our colleagues to think that we know everything there is to know about SQL Server... 06 April 2017 29 min read
Blogs Phil Factor in Blogs 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
.NET Jon Smith in .NET Building Better Entity Framework Applications Entity Framework (EF) is Microsoft’s Object/Relational (ORM) database access library, with a new generation, EF Core, released in 2016. In... 27 March 2017 22 min read
T-SQL Programming Nat Sundar in T-SQL Programming Using the DbFit Framework for Data Warehouse Regression Testing It is ironic that the users of database application need to rely on the very technologists that created the system... 08 March 2017 15 min read
T-SQL Programming Robert Sheldon in T-SQL Programming Encrypting SQL Server: Dynamic Data Masking Dynamic Data Masking is a good way of rendering data unreadable for such purposes as user-acceptance testing, or demonstrating an... 08 March 2017 15 min read
David Njoku Oracle for Absolute Beginners: Users, Synonyms, Privileges, & Roles I accidentally locked myself out of my house this evening, and so I had to climb up the wall like... 01 March 2017 11 min read
T-SQL Programming Phil Factor in T-SQL Programming Doing Fuzzy Searches in SQL Server A series of arguments with developers who insist that fuzzy searches or spell-checking be done within the application rather then... 23 February 2017 17 min read
Blogs Phil Factor in Blogs 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
Database Administration Robert Sheldon in Database Administration SQL Server Encryption: Always Encrypted Is 'Always Encrypted' SQL Server 2016's most widely important new feature? It is significant that 'Always Encrypted' in SQL Server... 10 February 2017 26 min read
.NET Sophia Segal in .NET User Acceptance Testing and the Application Lifecycle User Acceptance Testing (UAT) is an important part of the development process. If carried out as early as possible and... 03 February 2017 24 min read
Blogs Phil Factor in Blogs 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
T-SQL Programming Joe Celko in T-SQL Programming Handling Graphs in SQL Many practical database problems can be tackled more simply and intuitively by graphs or networks, which in this sense are... 20 January 2017 17 min read
Oracle Aman Sharma in Oracle Understanding SQL Query Parsing – Part 3: Bind Variables and Cursor Sharing In the first and the second parts of this series, we learned what query parsing is, how hard and soft... 20 January 2017 10 min read
T-SQL Programming Robert Sheldon in T-SQL Programming Core Database Source Control Concepts Sometimes, it isn't the technicalities or details of database source control that people find difficult, but the general concepts and... 13 January 2017 30 min read
T-SQL Programming Robert Sheldon in T-SQL Programming Encrypting SQL Server: Transparent Data Encryption (TDE) Transparent Data Encryption (TDE) encrypts the data within the physical files of the database, the 'data at rest'. Without the... 12 January 2017 16 min read
T-SQL Programming Robert Sheldon in T-SQL Programming Encrypting SQL Server: Using an Encryption Hierarchy to Protect Column Data SQL Server Encryption is an essential part of what is required for protecting data. Column-level encryption can be a very... 13 December 2016 15 min read
T-SQL Programming Phil Factor in T-SQL Programming Lists With, or Without, Ranges in both T-SQL and PowerShell Whether you are working in a procedural language like PowerShell or in T-SQL, there is something slightly bothersome about having... 01 December 2016 19 min read
