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

Nat Sundar

Comparing SSIS Catalog Contents Using DBFit Framework

When you are doing the rapid deployment of an updated SSIS project, there are a number of things you have...

06 April 2017 16 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

Database DevOps

Phil Factor in Database DevOps

Gnuplot with PowerShell & SQL Server: Automated Data Plotting

Generate automated data plots from SQL Server using Gnuplot and PowerShell. Covers chart types, script-from-data separation, business and financial charts,...

27 March 2017 12 min read

Joshua Feierman

Azure Networking for SQL Server DBAs

The network is important to any DBA because so much performance is dependent on I/O, because of the importance of...

27 March 2017 15 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

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

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

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

Register for Simple Talk

Databases

Statistics in SQL: Pearson’s Correlation

Comparing SSIS Catalog Contents Using DBFit Framework

Building Better Entity Framework Applications

Gnuplot with PowerShell & SQL Server: Automated Data Plotting

Azure Networking for SQL Server DBAs

Using the DbFit Framework for Data Warehouse Regression Testing

Encrypting SQL Server: Dynamic Data Masking

Oracle for Absolute Beginners: Users, Synonyms, Privileges, & Roles

R in SQL Server: Forecasting with Power BI

Automating SSIS Project Deployment with PowerShell: ispac Files, SSISDB Catalog, and Multi-Project Scripts

Exploring Azure Storage for SQL Server DBAs – Part 2

Fuzzy Search in SQL Server: Edit Distance, Metaphone, and Soundex

Getting started with Oracle Database 12c Multitenant Architecture

JSON For Absolute Beginners: Part 6 – Generating JSON post-12c Release 2

Oracle for Absolute Beginners: Data Types

Scaling out SSRS on SQL Server Standard Edition

String Comparisons in SQL: The Metaphone Algorithm

SQL Server Temporal Tables: Practical Recipes & Examples

SQL Server Encryption: Always Encrypted

Oracle Partitioned Index Efficiency