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
PowerShell Greg Moore in PowerShell How to Use Parameters in PowerShell Part II PowerShell is a basic skill any administrator working in Windows or Azure should know. After writing his first article about... 18 August 2020 17 min read
Database DevOps Kendra Little in Database DevOps The Two Ways Containers Will Revolutionize Database DevOps Containers have already transformed the way application development works, but adoption has been slower for databases. Finally, the revolution is... 17 August 2020 8 min read
.NET Rishit Mishra in .NET Securing Web Application Secrets Through Azure Key Vault Azure Key Vault is a service for storing securely certificates, credentials, connection strings, and more. In this article, Rishit Mishra... 12 August 2020 12 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
Editorials Kathi Kellenberger in Editorials Keeping up with SQL Server I gave a session for the recent PASS Marathon entitled “Modern T-SQL for Better Performance.” During the session, I talked... 25 July 2020 3 min read
Editorials Kathi Kellenberger in Editorials Reading Books Books are usually meant to be read in an analogue fashion. Start at page one and keep on going until... 14 July 2020 3 min read
.NET Lance Talbert in .NET How to Create a Settings Menu in Unity Video game enthusiasts expect that they can make changes to the game’s environment and that the setting changes will be... 30 June 2020 19 min read
Editorials Kendra Little in Editorials Will We Still be Talking About DevOps in Two Years? While individual buzzwords will come in and out of fashion, the ideas at the heart of DevOps aren’t going anywhere. ... 26 June 2020 2 min read
T-SQL Programming Uwe Ricken in T-SQL Programming Heaps in SQL Server: Part 2 Optimizing Reads In the second article of this series, Uwe Ricken discusses ways to affect the performance of queries involving heaps, including... 22 June 2020 18 min read
Editorials Kathi Kellenberger in Editorials PASS Summit Goes Virtual The PASS organization announced last week that the 2020 Summit, originally planned for Houston this November, will now be held... 09 June 2020 3 min read
Editorials Kathi Kellenberger in Editorials Too Much Stuff We’ve lived in our current home for 30 years and have managed to accumulate a lot of possessions. We have... 02 June 2020 3 min read
Database Administration Robert Cain in Database Administration How to Create an Ubuntu PowerShell Development Environment – Part 3 Running SQL Server in a container may seem daunting at first, but it’s easy once you understand the handful of... 28 May 2020 20 min read
T-SQL Programming Edward Pollack in T-SQL Programming Hands-On with Columnstore Indexes: Part 1 Architecture Microsoft introduced Columnstore with SQL Server 2012 and have improved the feature in every version since then. You may be... 21 May 2020 22 min read
PowerShell Greg Moore in PowerShell How to Add Help to PowerShell Scripts PowerShell scripts are the tool of choice for many admins, but how do you make them easy for others to... 13 May 2020 12 min read
BI Sanil Mhatre in BI Text Mining and Sentiment Analysis: Analysis with R In the third article of this series, Sanil Mhatre demonstrates how to perform a sentiment analysis using R including generating... 13 May 2020 19 min read
.NET Lance Talbert in .NET How to Use Scriptable Objects in Unity In this article, Lance Talbert demonstrates how to use scriptable objects in Unity for creating multiple, but similar, objects such... 11 May 2020 17 min read
Editorials Kathi Kellenberger in Editorials Learning New Skills A lot of folks have taken advantage of more time at home recently to pick up new skills and hobbies.... 10 May 2020 3 min read
Editorials Kathi Kellenberger in Editorials Making a Difference in Uncertain Times Most of us have found our lives turned upside down in recent weeks as we try to shelter in place,... 22 April 2020 3 min read
NoSQL Shel Burkow in NoSQL Translating a SQL Server Schema into a Cassandra Table: Part III Many-to-Many, Attribute Closure and Solution Space In the third and final article of the series, Shel Burkow demonstrates several designs that cover many-to-many relationships, attribute closure,... 21 April 2020 18 min read
