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 Fuzzy Search in SQL Server: Edit Distance, Metaphone, and Soundex Implement fuzzy search in SQL Server using three complementary techniques: edit distance for misspellings, Metaphone sound-alike matching for phonetic errors,... 23 February 2017 17 min read
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
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
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
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 Oracle SQL Query Parsing – Part 3: Bind Variables and Cursor Sharing In this third article, we will look at the issue of duplicate SQL statements and how Bind Variables can help... 20 January 2017 9 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
Database Administration Enrico van de Laar in Database Administration Determining What Happens When You Force an Execution Plan via the Query Store When you force a query plan via the Query Store, you will need to track what happens: Sometimes the request... 29 November 2016 12 min read
T-SQL Programming Phil Factor in T-SQL Programming PowerShell and SQLite: Query, Transfer Data, and Store Results Learn how to use SQLite with PowerShell and SQL Server: query SQLite databases via ADO.NET, transfer results to SQL Server... 03 November 2016 16 min read
T-SQL Programming Joe Celko in T-SQL Programming Triggers: Threat or Menace? Triggers are generally over-used in SQL Server. They are only rarely necessary, can cause performance issues, and are tricky to... 27 October 2016 13 min read
Database Administration Robert Sheldon in Database Administration Retrieving SQL Server Query Execution Plans Execution plans explain all you need to know about query performance, and how to fine-tune. Sure, you can see them... 18 October 2016 26 min read
T-SQL Programming Grant Fritchey in T-SQL Programming Who the Devil Wrote This SQL Code? The way that you format T-SQL code can affect the productivity of the people who have to subsequently maintain your... 05 October 2016 12 min read
T-SQL Programming Edward Elliott in T-SQL Programming Which Edition of SQL Server is Best for Development Work? You might think, as a developer, that nothing but the best is good enough as a development database. You might... 04 October 2016 15 min read
T-SQL Programming Uwe Ricken in T-SQL Programming DELETE Operation in SQL Server HEAPs You should stick to using tables in SQL Server, rather than heaps that have no clustered index, unless you have... 05 September 2016 14 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
