Simple Talk RSS Feed

Latest articles

Building and consuming GraphQL API in ASP.NET Core 3.1

It was in the year 2012 that Facebook decided to rebuild their apps to improve performance and efficiency. It was a time when Facebook’s mobile strategy wasn’t working because of high network usage. Optimization strategies using caching might have improved the performance, but since the app was too complex, it was thought that the data fetching strategy...

Getting Started with GitFlow

Chances are that you already work with Git as your default versioning system, and it’s even more likely if you’re an experienced developer. The importance of this technology to the global software community is undeniable, regardless of what programming language you use, your preferences and your experience. Massive open source communities like the ones...

How to Create a Settings Menu in Unity

Virtually every game you play, especially on a personal computer, allows you to change the graphics settings to get the best performance and appearance you can on your device. These games save those settings and then reload them whenever the user reopens the project. Perhaps you might be wondering how it does all that? In the case of a typical Unity...

The Pros and Cons of Virtual Conferences: Just My Opinions

Before taking any time with the rest of my SQL Saturday Chattanooga, Home Edition teammates to discuss what went right and wrong with our event (it felt mostly right, honestly as far as I could tell, but we won’t totally know until we get the feedback from attendees), I was thinking as I was enjoying the conference process that there were some things...

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.  Like any good buzzword, DevOps may mean different things to different people. There are several good definitions of DevOps out there. My favorite definition comes from @IanColdwater, who defined DevOps in terms a teenager would understand:...

Hands-On with Columnstore Indexes: Part 2 Best Practices and Guidelines

The series so far: Hands-On with Columnstore Indexes: Part 1 Architecture Hands-On with Columnstore Indexes: Part 2 Best Practices and Guidelines A discussion of how columnstore indexes work is important for making the best use of them, but a practical, hands-on discussion of reality and how they are used in production environments is key to...

Heaps in SQL Server: Part 2 Optimizing Reads

The series so far: Heaps in SQL Server: Part 1 The Basics Heaps in SQL Server: Part 2 Optimizing Reads Heaps are not necessarily the developer’s favourite child, as they are not very performant, especially when it comes to selecting data (most people think so!). Certainly, there is something true about this opinion, but in the end, it is always...

Storage 101: Cloud Storage

The series so far: Storage 101: Welcome to the Wonderful World of Storage Storage 101: The Language of Storage Storage 101: Understanding the Hard-Disk Drive  Storage 101: Understanding the NAND Flash Solid State Drive Storage 101: Data Center Storage Configurations Storage 101: Modern Storage Technologies Storage 101: Convergence and Composability ...

Connecting to a SQL Server Docker Container Running in macOS

The series so far: Creating Your First SQL Server Docker Container in macOS Managing SQL Server Docker containers in macOS Connecting to a SQL Server Docker Container Running in macOS In the second part of this article series, you learned about the container’s nature (ephemeral) and a few details about its life cycle. More importantly, I provided...

Using a Public Web Service to Consume SQL Server Build Numbers

During my time as a professional DBA, I have been responsible for quite a few SQL Server instances, all with their own set of characteristics, including different versions and patching levels, the topic of this article. One of the primary duties that DBAs have is making sure that the SQL Server instances are patched and up to date, as Microsoft makes...

Discover, share and read the best on the web

Subscribe to RSS Feeds, Blogs, Podcasts, Twitter searches, Facebook pages, even Email Newsletters! Get unfiltered news feeds or filter them to your liking.

Get Inoreader
Inoreader - Subscribe to RSS Feeds, Blogs, Podcasts, Twitter searches, Facebook pages, even Email Newsletters!