T-SQL Programming Joe Celko in T-SQL Programming Do You Have REFERENCES? The logic for referential integrity can be implemented in application code, but to make sure that it is enforced, include... 03 December 2019 13 min read
Database Administration Forrest McDaniel in Database Administration How Does Accelerated Database Recovery Work? Accelerated Database Recovery is new with SQL Server 2019 and Azure SQL Database and used to decrease the time for... 26 November 2019 12 min read
Editorials Kathi Kellenberger in Editorials SSRS is Still Around The other day, a friend asked me if Microsoft is discontinuing SQL Server Reporting Services (SSRS) now that Power BI... 20 November 2019 3 min read
T-SQL Programming Joe Celko in T-SQL Programming Understanding Auctions We participate in auctions all the time even when we don’t realize it. In this article, Joe Celko discusses the... 29 October 2019 13 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming What Does PERCENTILE_CONT Do? In this article, Kathi Kellenberger takes on a logic puzzle in trying to understand how the windowing function, PERCENTILE_CONT, works.... 17 October 2019 10 min read
T-SQL Programming Joe Celko in T-SQL Programming SQL and Scope Understanding scoping rules is a basic skill for developers. In this article, Joe Celko gives a bit of the history... 07 October 2019 20 min read
BI Kathi Kellenberger in BI Reporting Services Basics: Adding Groups to Reports Most SSRS reports are organized into grouping levels where it’s possible to add totals for each group. In this article,... 01 October 2019 13 min read
Data Science Supriya Pande in Data Science Building Machine Learning Models to Solve Practical Problems Machine learning is a skill that many data professionals are learning as they plan their careers over the next five... 24 September 2019 13 min read
Editorials Kendra Little in Editorials SQL Server Management Studio is as Relevant as Ever After fifteen years of heavy usage by developers and DBAs, it might seem like Microsoft’s free tool, SQL Server Management... 24 September 2019 3 min read
T-SQL Programming Dennes Torres in T-SQL Programming SQL Server 2019 Graph Database and SHORTEST_PATH With SQL Server 2019 on the way, it’s time to begin learning about all the new features. In this article,... 11 September 2019 13 min read
Database Administration Joshua Feierman in Database Administration How to Use SQL Audit and Azure Log Analytics to Comply with Audit Rules You can use SQL Audit to record changes to security, access to tables, and more to help you meet compliance... 09 September 2019 16 min read
Theory and design Joe Celko in Theory and design Yes and No Questions Are Not So Simple Joe Celko explains why questions requiring yes or no answers are more complicated than you might realize in both spoken... 07 August 2019 8 min read
BI Kathi Kellenberger in BI Reporting Services Basics: Parameters Kathi Kellenberger continues her series on SSRS. In this article you learn how to use parameters that let your report... 02 August 2019 18 min read
BI Andy Brown in BI Cracking DAX – the EARLIER and RANKX Functions So far in this series, Andy Brown of Wise Owl Training has shed light on functions like CALCULATE, VALUES and... 31 July 2019 17 min read
BI Benjamin Weissman in BI PolyBase in SQL Server 2019 – The End of ETL? PolyBase has been around since 2016, but Microsoft is enhancing it in 2019 with the ability to connect to more... 23 July 2019 10 min read
T-SQL Programming Monica Rathbun in T-SQL Programming What are Columnstore Indexes? Microsoft continues to enhance the performance of SQL Server with new features. In this article, Monica Rathbun explains how to... 22 July 2019 15 min read
T-SQL Programming Joe Celko in T-SQL Programming Modeling Time There are those who argue that time doesn’t really exist; it’s just an illusion. That debate won’t keep you from... 15 July 2019 16 min read
BI Kathi Kellenberger in BI Reporting Services Basics: Understanding Data Sources and Datasets Data sources and datasets are critical components of an SSRS report, but many people new to SSRS struggle to understand... 05 July 2019 10 min read
Database Administration K. Brian Kelley in Database Administration The End of SQL Server 2008 and 2008 R2 Extended Support Many organisations still run their companies on SQL Server 2008 or 2008 R2. There are many reasons to upgrade, but... 21 June 2019 26 min read
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
