BI Sanil Mhatre in BI Text Mining and Sentiment Analysis: Introduction Microsoft provides a service to analyze text data called Text Analytics Cognitive Service. In this article, Sanil Mhatre demonstrates how... 03 February 2020 12 min read
Database Administration Robert Sheldon in Database Administration Storage 101: The Language of Storage Robert Sheldon continues his series on storage. This article covers some of the basics of performance metrics, HDDs, and SSDs.… 22 January 2020 13 min read
Containers and Virtualization Carlos Robles in Containers and Virtualization Managing SQL Server Docker containers in macOS In the second article of this series, Carlos Robles explains how to manage Docker images and containers.… 21 January 2020 11 min read
T-SQL Programming Edward Pollack in T-SQL Programming Efficient Solutions to Gaps and Islands Challenges Window functions are useful for solving many SQL queries. In this article, Ed Pollack demonstrates how they can be used... 21 January 2020 32 min read
BI Andy Brown in BI Using Calendars and Dates in Power BI You can use a host of time-intelligence functions in DAX to calculate everything from simple year-to-date totals to moving averages... 03 January 2020 17 min read
T-SQL Programming Edward Pollack in T-SQL Programming Introduction to Gaps and Islands Analysis T-SQL window functions simplify solving many complex queries. In this article, Edward Pollack demonstrates how the functions can be used... 02 January 2020 19 min read
Database Administration Robert Sheldon in Database Administration Storage 101: Welcome to the Wonderful World of Storage Understanding all the storage options available today is not easy. In this new series, Robert Sheldon will explain what you... 03 December 2019 13 min read
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
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
