Data Science Shree Das in Data Science The Social Impact of Artificial Intelligence and Data Privacy Issues Like any technology, AI can be used for evil instead of good. Shree Das explains several examples and what should... 08 September 2020 8 min read
Database Administration Greg Larsen in Database Administration Understanding SQL Server Recovery Models The database recovery model controls how a SQL Server database can be backed up and restored. In this article, Greg... 27 August 2020 12 min read
Career Pamela Mooney in Career DBA in training: Preparing for interviews Getting that first job as a DBA is not easy for most of us. In this article, Pamela Mooney explains... 26 August 2020 17 min read
T-SQL Programming Uwe Ricken in T-SQL Programming Heaps in SQL Server: Part 3 Nonclustered Indexes Uwe Ricken continues his series on heaps. This time he demonstrates a common scenario where the query against a heap... 18 August 2020 8 min read
Editorials Brett Newski in Editorials Eliminating the Fear of Missing Out (FOMO) Many are finding the quarantine a net gain for mental health. Here’s why… The FOMO has been eliminated. There is no... 06 August 2020 3 min read
T-SQL Programming Phil Factor in T-SQL Programming SQL Server Temp Tables: Types, Syntax & Best Practices Everything about SQL Server temporary tables: local (#temp), global (##temp), table variables, and when to use each. Includes creation syntax,... 01 August 2020 23 min read
.NET Julio Sampaio in .NET Microsoft Graph API in .NET Core: Access Microsoft 365 Data from C# Access Microsoft 365 data from .NET Core using the Microsoft Graph API: learn the request URL structure, explore endpoints with... 21 July 2020 13 min read
T-SQL Programming Uwe Ricken in T-SQL Programming Optimize Heap Table Reads in SQL Server (Part 2 of 4) Optimize read performance on SQL Server heap tables. Covers advanced scanning, predicate pushdown, allocation order scans, partitioning, and compression techniques.… 22 June 2020 19 min read
Blogs Kathi Kellenberger in Blogs Using Azure Data Studio with SQL Prompt One of the coolest and most useful features of Azure Data Studio (ADS) is SQL Notebooks. If you haven’t seen... 04 June 2020 4 min read
Opinion Kathi Kellenberger in Opinion Free Classes from Redgate Community Circle Everyone has been impacted in some way from the Covid-19 pandemic, whether it is missing out on holiday travel and... 20 April 2020 2 min read
Theory and design Joe Celko in Theory and design Codd’s Twelve Rules Dr. Codd proposed the normalization rules we used to design databases, but did you know that he also came up... 14 April 2020 16 min read
.NET Diogo Souza in .NET Getting Started with CQRS – Part 3 Diogo Souza completes his series on CQRS. He demonstrates Event Sourcing to capture the data as it flows through the... 01 April 2020 35 min read
T-SQL Programming Edward Pollack in T-SQL Programming Stale SQL Server Views: Detecting and Fixing Views After Table Changes SQL Server views can silently return wrong columns after underlying tables are altered. Learn to detect stale views with sp_refreshview,... 31 March 2020 24 min read
.NET Lance Talbert in .NET Creating Multiplayer Games with Unity and PUN Many games today involve more than one player, but creating a multiplayer game is not easy. In this article, Lance... 10 March 2020 18 min read
BI Sanil Mhatre in BI Text Mining and Sentiment Analysis: Power BI Visualizations Power BI is perfect for analyzing surveys. In this article, Sanil Mhatre demonstrates how to build several visualizations for key... 02 March 2020 15 min read
Data Science Dennes Torres in Data Science SQL Server Machine Learning 2019: Working with Security Changes SQL Server Machine Learning allows you to run R and Python scripts from SQL Server. When SQL Server 2019 was... 21 February 2020 17 min read
Editorials Samuel Nitsche in Editorials Why Empathy is Not Enough in Tech In 2020, my main personal goal is to reduce doing harm, and this has been mainly inspired by the work... 10 February 2020 3 min read
BI Sanil Mhatre in BI Sentiment Analysis with Power BI and Azure AI Language: A Practical Introduction Perform sentiment analysis on survey responses using Power BI and Azure AI Language (formerly Azure Text Analytics). Part 1 covers... 03 February 2020 13 min read
.NET Lance Talbert in .NET Saving Game Data in Unity: PlayerPrefs for Simple Values and C# Serialization for Complex Objects Two approaches to saving game data in Unity - PlayerPrefs for simple key-value persistence of primitives (int, float, string), and... 03 February 2020 13 min read
T-SQL Programming Edward Pollack in T-SQL Programming Gaps and Islands in SQL Server: Efficient Window Function Solutions Advanced gaps and islands analysis in SQL Server using efficient window function patterns. Covers streak detection, PARTITION BY for multi-entity... 21 January 2020 32 min read
