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
BI Saurabh Desai in BI R in SQL Server: Forecasting with Power BI Run R packages inside SQL Server using sp_execute_external_script for sales forecasting, then visualize results in Power BI with DirectQuery for... 28 February 2017 14 min read
BI Nat Sundar in BI Deploying Multiple SSIS Projects via PowerShell When there are several SSIS projects with packages in a SQL Server Database or Data Warehouse development, automated deployments as... 27 February 2017 29 min read
Database Administration Joshua Feierman in Database Administration Exploring Azure Storage for SQL Server DBAs – Part 2 Managed Disks have simplified way that Azure storage interacts with the users' virtual machines, thanks to the way that it... 27 February 2017 15 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
Aman Sharma Getting started with Oracle Database 12c Multitenant Architecture Oracle database, since its inception, has always used a very specific and unique architecture which served it very well. In... 22 February 2017 15 min read
David Njoku JSON For Absolute Beginners: Part 6 – Generating JSON post-12c Release 2 In this sixth and final installment in this introductory series on JSON I’d like to revisit the question of generating... 22 February 2017 6 min read
David Njoku Oracle for Absolute Beginners: Data Types All databases stand on a tripod of datatypes: strings, numbers and dates. And so I’d imagine that by Day 2... 15 February 2017 11 min read
BI Rodney Landrum in BI Scaling out SSRS on SQL Server Standard Edition The ability to scale out SSRS, so that multiple report server instances can access a single report server database, is... 14 February 2017 16 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 Alex Grinberg in Database Administration SQL Server Temporal Tables: Practical Recipes & Examples Practical recipes for SQL Server temporal tables: create system-versioned tables, query historical data with FOR SYSTEM_TIME, manage retention, and implement... 10 February 2017 16 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
Houri Oracle Partitioned Index Efficiency PartitionedIndexEfficiency Although it is generally true that rebuilding an index represents a waste of time and resources, there nevertheless exist... 09 February 2017 10 min read
Anju Garg Policy-Managed Oracle RAC One Node Databases Oracle RAC One Node, introduced in Oracle Database 11g Release 2 (11.2.0.2), is a single instance of an Oracle RAC-enabled... 09 February 2017 13 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
Aman Sharma Understanding SQL Query Parsing: Part 4 – Understanding Bind Variable Peeking In the 3rd part of this series, I introduced you to the concept of the bind variables. We also learned... 03 February 2017 8 min read
David Njoku Oracle for Absolute Beginners: Date, Timestamp and Interval All databases stand on a tripod of datatypes: strings, numbers and dates. And though they might dress them in fancy... 02 February 2017 12 min read
David Njoku Oracle for Absolute Beginners: Other SQL Functions Here’s a simple trick you can play on your friends. Ask them to pick a number from 1 to 10,... 30 January 2017 8 min read
