2024-03-29
1,260 reads
T-SQL
The difference between BIN2 and Case-Sensitive collations in SQL
Here you will learn about the key differences between the binary and SQL/Windows collations. You will see that even with all sensitivity flags enabled, SQL/Windows collation cannot behave the same way as the binary collations.
2024-03-15
1,166 reads
Writing SQL Server code with AI using GitHub Copilot
Introduction In this article, we will see how to work with GitHub Copilot. GitHub copilot is an interesting plug-in that generates code using AI. The technology is from Microsoft and OpenAI. We will show how to install Copilot, and how to generate SQL Server code (T-SQL) using Copilot. First, we will answer some FAQs about Copilot […]
2024-02-12
5,411 reads
SQL Window Functions Series: LAG() and LEAD()
Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.
2023-12-11
4,590 reads
2023-11-27
4,012 reads
Efficient Table Migration to a New Schema in T-SQL
This article will explain why and how you can easily move tables to new schemas if the need arisees.
2023-11-03
2,354 reads
GENERATE_SERIES() Breaks Minimal Logging
tl;dr The title says it all. Prologue One of the keys to my personal learning is that, very early in my database career, I taught myself how to make lot’s of rows of Random Constrained Data in a comparatively short time. With the help of a few good folks over time, the method has been […]
2023-09-18
3,536 reads
Different Ways to Format Currency Output in SQL
In this tutorial, we will show different ways to output different currency formats with the T-SQL language.
2023-08-28
Sample Use Case for Using SQLCMD Utility Batch Files
In this article, we look at a sample use case of how you can create SQLCMD batch files that can be interactive and reused in different SQL Server environments.
2023-07-14
Starter Metadata T-SQL Query Examples for Databases and Tables
SQL Server provides lots of information about various aspects of server and database objects and this data is referred to as metadata. Understanding what is available and how to use this metadata can greatly enhance and streamline how you can work with SQL Server.
2023-07-07
Blogs
SQL Aggregate Functions: Your Essential Guide & Cheat Sheet
SQL aggregate functions are your go-to tools for transforming raw data into actionable insights....
T-SQL Tuesday #174 – My Favorite Interview Question
By Steve Jones
This month is a great topic to me. I think growing and improving your...
T-SQL Tuesday #174: Job Interview Questions
By Brian Kelley
Once upon a time, I used to think of difficult technical questions to ask...
Forums
SQL JOB add/modified
Is there a trigger to notify when a new SQL Agent job is created/modified?
View generating different plan
Hello I have a view based upon a number of tables I'm selecting...
Alert For Blocking in Azure SQL Managed Instance
In an Azure SQL Managed Instance there is no option to create what we...
Question of the Day
Full Text Editions
In which editions can I use Full-Text and semantic search?
See possible answers