Who’s Hiring in the Microsoft Data Platform Community? February 2023 Edition
It’s Valentine’s day – let’s do some matchmaking! Is your company hiring for a database position as of February 2023? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. …
An Introduction to Assessing Normal Distribution with Python
The post An Introduction to Assessing Normal Distribution with Python appeared first on SQLServerCentral.
What is ChatGPT – Is it the rise of the Skynet era?
Introduction to ChatGPT ChatGPT is a Generative Pre-trained Transformer. It is a chatbot created by OpenAI (An American AI research lab). Skynet is a fictional computer that conquered the world with the help of the Terminators. It was a computer with A …
How do your DevOps plans really measure up?
The post How do your DevOps plans really measure up? appeared first on SQLServerCentral.
Join Redgate at SQL Bits, March 15-18
The post Join Redgate at SQL Bits, March 15-18 appeared first on SQLServerCentral.
Steps to add a new disk to SQL Server failover cluster instance and move a user database to it
The post Steps to add a new disk to SQL Server failover cluster instance and move a user database to it appeared first on SQLServerCentral.
PostgreSQL Temporary Table
Overview In this tutorial, we will learn about a PostgreSQL temporary table and its usage. We will study the basic syntax and some examples to understand its functionality. Definition A PostgreSQL temporary table, as its name implies, is a table that e …
How to ask for programming help
Over the past 25 years, I have answered a lot of programming questions in online forums, from co-workers, and from friends. It has been a while since I had been around forums, but I recently decided it was time to get back to what started me in the SQL …
[Video] Office Hours: Quiet Sunday Edition
While waiting for the dry cleaner to open, I went live to stream a quiet session going through a bunch of y’all’s questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:45 Rollback is single threaded: H …
Firebase and Supabase: Key differences you need to know
The tools classified as “Realtime Backend / API“, or tools that can rapidly process an API call and in this case, store data, include Firebase and Supabase. Firebase is a NoSQL database, while Supabase is a relational database. The Firestor …
Free Training Coming Up! March is PowerShell Month.
You’re a production database administrator responsible for the health, security, and uptime of many database servers. You’ve been pointing and clicking your way through SSMS for years, scripting out T-SQL to files, but… when you need …
A Version Control Strategy for Branch-based Database Development
Our existing database development and release process was holding back team productivity and causing frequent deployment delays. It was manual and error prone. Developers worked on a shared development database, with all changes committed to a ‘monolit …
A Simple Example of Flyway Development using GitHub Branching
The post A Simple Example of Flyway Development using GitHub Branching appeared first on SQLServerCentral.
[Video] Office Hours: Snowy Michigan Edition
We went up to Michigan to see my dad’s side of the family, and the snow came down just in time for our arrival. Always love the fresh snow look. So I stood outside and took your top-voted questions from https://pollgab.com/room/brento. Let’ …
Using TOP clause in a SELECT statement
This article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 9 items in the series, click here. TOP Clause Syntax The syntax for the top clause is simple and is shown in Figure 1. TOP (<expression>) [PERCENT] [ WITH TIES …