DevOps might sound intimidating if your organisation has not yet begun on its DevOps journey. In this article, Rahul Varshneya explains some of the benefits and reviews the stages all DevOps organisations go through to achieve it.… Read more
Understanding scoping rules is a basic skill for developers. In this article, Joe Celko gives a bit of the history of scoping in early programming languages and shows how scoping applies to SQL queries as well. … Read more
I never allowed my children play with modelling clay in my home when they were young, but changed my mind when grandchildren arrived. I have the perfect table, a discarded fast food restaurant booth, so that the mess stays in one spot. There is one sturdy box to hold all the cans of dough and … Read more
Most SSRS reports are organized into grouping levels where it’s possible to add totals for each group. In this article, Kathi Kellenberger continues her SSRS series by walking through how to create both a Matrix and Table report. … Read more
Video games often contain animation of the objects and characters, but how is that accomplished? In this article, Lance Talbert explains how a Unity plugin called iTween can make creating animation easy. … Read more
Machine learning is a skill that many data professionals are learning as they plan their careers over the next five to ten years. In this article, Supriya Pande gives an overview of machine learning and walks through a practical example.… Read more
After fifteen years of heavy usage by developers and DBAs, it might seem like Microsoft’s free tool, SQL Server Management Studio, is about to go out of style. SSMS is no longer the cool new kid on the block: Microsoft has shown consistent effort to develop their new tool, Azure Data Studio (formerly known as SQL Operations Studio), … Read more
The year is 1999, somewhere in Cambridge, UK. Kathi, a member of the Data-Philes team, is reading a memo sent from her manager. The memo talks about someone who disrupted a project management meeting in London. He claims he is from 20 years in the future. Chris walks in. Chris: Kathi, have you seen the … Read more
With SQL Server 2019 on the way, it’s time to begin learning about all the new features. In this article, Dennes Torres demonstrates how to use the new SHORTEST_PATH function that is part of the Graph Database feature. … Read more
Robert Sheldon continues his DevOps series with a look at security, privacy, and compliance. He recommends that these critical areas are tackled early in the DevOps pipeline.… Read more
You can use SQL Audit to record changes to security, access to tables, and more to help you meet compliance requirements. In this article, Joshua Feierman explains how to set up the audit and collect the data in Azure Log Analytics when running SQL Server in an Azure VM.… Read more
React is a popular JavaScript library for creating interactive UIs. In this article, Julio Sampaio shows you how to write your first ASP.NET app that takes advantage of its components for each of use and reusability. … Read more
I’ve worked with Microsoft technologies for over 20 years and, during that time, earned a good income to support my family and have a comfortable life. Despite that, Microsoft manages to break my heart again and again. Take the sad saga of the Windows Phone. I was working for Microsoft when the first Windows Phones … Read more
One of the hallmark features of video games is the ability to choose or even customize your character. In this article, Lance Talbert shows how easy it is to let the player create custom characters for your game, especially when you can take advantage of premade image assets available online. … Read more
You can now write applications in C# or F# that take advantage of Apache Spark. In this article, Edward Elliott walks you through installing everything you need and creating your first Apache Spark app.… Read more
The React library allows teams to work faster and with more consistency. In this article, Camilo Reyes explains how to get started using React components in a C# application. … Read more
Back when I was working on a master’s degree, one of our professors told us a story about a colleague who learned how to navigate the Unix system. She was so thrilled about learning this new skill that, in her exuberance, she stumbled upon some hidden human resource files containing confidential information. Eventually, an administrator … Read more
When the DevOps pipeline does not include the database, the database can become a bottleneck and slow down the delivery of new features. In this article, Robert Sheldon discusses the challenges involved with including the database and how to overcome them. … Read more
Compliant Database DevOps
Standardize team-based development
Automate database deployments
Monitor performance and availability
Protect and preserve data
