Security Greg Larsen in Security SQL Server security – Providing a security model using user-defined roles Greg Larsen continues his series and shows how user-defined roles roles can control SQL Server security.… 26 April 2021 13 min read
.NET Lance Talbert in .NET Using MySQL with Unity Even games must store data like top scores. In this article, Lance Talbert explains how to save data using MySQL... 15 April 2021 16 min read
NoSQL Robert Sheldon in NoSQL How to choose between SQL and NoSQL databases Organizations have many choices when it comes to databases. In this article, Robert Sheldon explains how to choose between SQL... 13 April 2021 10 min read
Data Science Chandra Kudumula in Data Science Insurance price prediction using Machine Learning (ML.NET) In this article, Chandra Kudumula shows how to use ML.NET to train a model for predicting costs from an insurance... 09 April 2021 9 min read
Database Administration Greg Larsen in Database Administration SQL Server Security – Fixed server and database roles Security roles can simplify permissions in SQL Server. In this article, Greg Larsen explains fixed server and database roles.… 01 April 2021 13 min read
Testing Julio Sampaio in Testing Load/stress testing .NET apps with Apache JMeter Since Microsoft discontinued their cloud-based load testing services, developers need a new way to test applications. Julio Sampaio demonstrates how... 26 March 2021 11 min read
T-SQL Programming Shel Burkow in T-SQL Programming A data transformation problem in SQL and Scala: Dovetailing declarative solutions Part II In this article, Shel Burkow uses the SQL execution plan from the previous article to write a program in Scala.… 26 March 2021 15 min read
T-SQL Programming Joe Celko in T-SQL Programming What is interpolation? In this article, Joe Celko explains interpolation and covers a bit about the history and what we all did before... 11 March 2021 10 min read
Editorials Kathi Kellenberger in Editorials Do something that scares you Recently, the editor of SQLServerCentral.com, Steve Jones, shared a video in our team Slack channel that talked about how you... 23 February 2021 2 min read
T-SQL Programming Shel Burkow in T-SQL Programming A data transformation problem in SQL and Scala: Dovetailing declarative solutions This article is an interesting approach to solving a data transformation problem in SQL and Scala. Shel Burkow uses a... 22 February 2021 11 min read
Learn SQL Server Greg Larsen in Learn SQL Server SQL Server authentication methods, logins, and database users Understanding SQL Server security is a critical skill. Greg Larsen explains SQL Server authentication methods, logins, and database users in... 22 February 2021 14 min read
.NET Diogo Souza in .NET Using Apache Kafka with .NET Diogo Souza explains using Apache Kafka with .NET including setting it up and creating apps to test sending messages asynchronously.… 18 February 2021 14 min read
Data Science Ashwin Thota in Data Science How to become a data scientist: A data-driven approach to careers in data science Many devs and IT professionals looking for the next career wonder how to become a data scientist. Ashwin Thota matches... 16 February 2021 11 min read
.NET Julio Sampaio in .NET IronPython: First steps Python is one of the most popular languages. Julio Sampaio explains how IronPython allows you to integrate Python with .NET.… 11 February 2021 8 min read
PowerShell Greg Moore in PowerShell PowerShell editors and environments part 1 There is no shortage of PowerShell editors and environments for developing and running scripts. Greg Moore explains some of his... 02 February 2021 11 min read
Editorials Kathi Kellenberger in Editorials Falling out of the zone If you are lucky enough to enjoy the work you do, it could be because you are frequently “in the... 27 January 2021 3 min read
.NET Amit Jambusaria in .NET Google Firebase for serverless front-end applications Google Firebase is a PaaS offering for developing web and mobile apps. Amit Jambusaria explains the advantages and walks through... 19 January 2021 10 min read
.NET Lance Talbert in .NET How to use Unity’s Remote Config You can use Unity’s Remote Config utility to update settings for users. Lance Talbert walks you through using the utility... 19 January 2021 17 min read
Editorials Brett Newski in Editorials Visit your parents Why is it such a cliché to complain about our parents? You hear it from friends or in films all the time…”damn,... 11 January 2021 3 min read
Data Science Shree Das in Data Science Kubeflow for data scientists introduction Machine learning projects often stall when it's time to deploy. Shree Das introduces Kubeflow for data scientists, an end-to-end solution... 08 January 2021 7 min read