T-SQL Programming Rodney Landrum in T-SQL Programming A MongoDB to SQL Server Migration: Data Typing and Un-nesting Importing data from one system to another is a common task for database professionals. It’s possible to spend a lot... 20 June 2019 15 min read
Database Administration Kellyn Pot'Vin-Gorman in Database Administration Navigate Linux for SQL Server DBAs Kellyn Pot’Vin-Gorman shows how to navigate Linux for SQL Server DBAs, using aliases, setting up environment variables, and examining processes.… 17 June 2019 18 min read
BI Kathi Kellenberger in BI Reporting Services Basics: Creating Your First Report In this article, Kathi Kellenberger demonstrates how to create a project and report using the SSRS Report Wizard. The wizard... 30 May 2019 13 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to SQL Server Security — Part 6 SQL Server has many tools used to make it secure. In this article, Robert Sheldon demonstrates several of these features... 29 May 2019 15 min read
BI in BI Streamlining a Power BI Solution Power BI is an excellent tool for departments or small organisations getting started with their BI solution. Unless some time... 17 May 2019 11 min read
Containers and Virtualization Carlos Robles in Containers and Virtualization Creating Your First SQL Server Docker Container in macOS The use of macOS by developers and IT professionals has gained popularity the past few years. Running a sandboxed SQL... 13 May 2019 14 min read
BI Gogula Aryalingam in BI The BI Journey: The Journey Begins Gogula Aryalingam continues telling the story of the BI solution created by a business analyst intern. In this article, after... 08 May 2019 12 min read
Security Robert Sheldon in Security Introduction to SQL Server Security — Part 5 SQL Server contains many built-in views and functions that can be used to understand what is going on “under the... 23 April 2019 21 min read
BI Andy Brown in BI Using the FILTER Function in DAX In the previous article of this series, Andy Brown of Wise Owl Training explained how to use the oh-so-important CALCULATE... 17 April 2019 13 min read
BI Dennes Torres in BI Power BI and The Matrix: A Challenge The Matrix is one of the many built-in visualizations found in Power BI. While the Matrix is easy to populate,... 15 April 2019 14 min read
BI Gogula Aryalingam in BI The BI Journey: The Expert’s Advice – Part 2 A BI project should return value to the company quickly, not only after months or even years of work. In... 15 April 2019 13 min read
Performance Samir Behara in Performance Designing Highly Scalable Database Architectures While architecting cloud native applications, you need to ensure that your system is highly available, performant, scalable, fault tolerant, and... 09 April 2019 13 min read
BI Kathi Kellenberger in BI SSRS Setup Guide: Install & Configure Reporting Install and configure SQL Server Reporting Services (SSRS) step by step. Covers architecture, security, report development tools, and deployment for... 08 April 2019 16 min read
T-SQL Programming Mala Mahadevan in T-SQL Programming Converting a History Table into a System-Versioned Temporal Table Temporal tables were introduced with SQL Server 2016. To take advantage of this feature, you might start fresh with a... 13 March 2019 15 min read
Editorials Kendra Little in Editorials Why You Shouldn’t Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures “There are only two hard things in Computer Science: cache invalidation and naming things” Phil Karlton I’m terrible at naming... 12 March 2019 4 min read
Database Administration Greg Larsen in Database Administration SQL Server Resumable Online Index Rebuild: Pause and Resume Index Operations SQL Server 2017 introduced resumable online index rebuilds - pause and resume large index operations without losing progress. SQL Server... 05 March 2019 15 min read
T-SQL Programming Phil Factor in T-SQL Programming SQL Server Inline Indexes: Add Indexes to Table Variables and UDTTs SQL Server inline indexes let you define clustered, nonclustered, and filtered indexes directly in CREATE TABLE syntax for table variables,... 26 February 2019 13 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to SQL Server Security — Part 3 SQL Server supports partially contained databases. This gives you the option of adding database users with a password inside the... 25 February 2019 14 min read
BI Gogula Aryalingam in BI The BI Journey: The Expert’s Advice – Part 1 Creating a quick dashboard with a few reports may be the beginning of a BI solution, but unless time is... 20 February 2019 14 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming SQL Server 2019 Window Aggregate Performance: Batch Mode on Rowstore SQL Server 2019 Batch Mode on Rowstore dramatically improves window aggregate performance - running totals, moving averages, and accumulating SUM... 11 February 2019 12 min read
