SELECT DISTINCT SQL Command to Return a Unique List of Values
The post SELECT DISTINCT SQL Command to Return a Unique List of Values appeared first on SQLServerCentral.
Build a Better WordPress Archives Page Using MySQL
I recently wrote about a way to generate visual, interactive calendars in HTML by combining a calendar table with data from an events table (part 1 and part 2). This technique could be used to overlay any type of data onto calendars, but my specific go …
Who’s Hiring in the Microsoft Data Platform Community? March 2023 Edition
Is your company hiring for a database position as of March 2023? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must incl …
Complex Production Database Deployments and Flyway
The post Complex Production Database Deployments and Flyway appeared first on SQLServerCentral.
AWS Lambdas with C#
The post AWS Lambdas with C# appeared first on SQLServerCentral.
Why a monitoring tool is an essential tool for growing server estates
When I was a DBA involved with the management of a large number of database servers, I didn’t have many third-party tools to help me do my job. For the most part, I relied on scripts that I found or wrote. I enjoyed writing scripts to manage the …
I’m Coming to Boston for SQLSaturday!
I’m coming back to Boston for SQLSaturday this October 14th! On Friday the 13th (muhaha), before the event, I’m teaching a one-day pre-conference workshop on Mastering Query Tuning. You need to speed up a SQL Server app, and you’re allowed …
Synapse Serverless and Dedicated Pool: The differences no one told you about
The basic differences between Synapse Serverless and the Dedicated pool are obvious: While the serverless doesn’t store data, only access data from storage accounts and scale the MPP environment automatically, the dedicate SQL Pool keeps a static …
Optional Code in T-SQL Scripts using SQLCMD
When you are writing T-SQL scripts to save away, for example one to create a new database, there are often optional bits of code you need to run sometimes, and not others. In the creating a database script, there are quite a few parameters you will wan …
It’s Monday. Get Back to Learning PowerShell.
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 …
Snowflake for SQL Server Developers – NULL Functions – Part 2
The post Snowflake for SQL Server Developers – NULL Functions – Part 2 appeared first on SQLServerCentral.
ChatGPT in SQL Server – Practical examples
Introduction ChatGPT in SQL Server In this article, we will learn some basic examples of ChatGPT in SQL Server. In a previous article, we had an interview with ChatGPT an AI chatbot developed by OpenAI. If you do not know how to use it yet, you can go …
Understanding Azure Synapse Analytics Pricing
Introduction Azure Synapse Analytics combines data integration, enterprise data warehousing, and data analytics. It is a cloud-based limitless data integration and analytics platform. It provides a cloud platform to create data pipelines from various s …
How to Improve the Quality of Database Releases using Clones
The post How to Improve the Quality of Database Releases using Clones appeared first on SQLServerCentral.
Creating Animated Line Plots with Python
The post Creating Animated Line Plots with Python appeared first on SQLServerCentral.