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
SQL Server Nat Sundar in SQL Server Automating SSIS Project Deployment with PowerShell: ispac Files, SSISDB Catalog, and Multi-Project Scripts Automating SSIS project deployment with PowerShell - deploying .ispac files to the SSISDB catalog, iterating across multiple projects in a... 27 February 2017 30 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 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
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
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 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
.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
Database Administration Alex Grinberg in Database Administration Migrating to SQL Server Memory-Optimized Tables: Indexes, Computed Columns, and Triggers Migrate existing SQL Server disk-based tables to memory-optimized (In-Memory OLTP) tables - covering limitations to plan for, new indexing strategy... 26 January 2017 21 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
BI Nat Sundar in BI Deployment Automation for SQL Server Integration Services (SSIS) SSIS was not originally designed with automated deployment in mind. However, any database that uses SSIS projects and their packages... 12 January 2017 16 min read
Database Administration Joshua Feierman in Database Administration Exploring Azure Storage for SQL Server DBAs If you need to run SQL Server in an Azure Virtual Machine, your choice of Azure storage will have a... 04 January 2017 14 min read
Database Administration Enrico van de Laar in Database Administration Query Store with In-Memory OLTP: What Gets Captured for Memory-Optimized Tables and Natively Compiled Procedures How SQL Server Query Store interacts with In-Memory OLTP features - the statistics available for regular queries against memory-optimized tables... 04 January 2017 12 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
