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
SQL Server
How to List First or Last n% Records Using NTILE() in SQL Server
Sometimes, we need to find the first or last n% records from a dataset based on a particular column. For instance, a teacher wants to know which students are in the bottom 25% based on marks. Hence, in such situations, the SQL NTILE() function helps. We will leverage this tip to get first or last n% records using NTILE() in SQL Server.
2023-08-04
Installing SQL Server Integration Services
You're tasked with installing SSIS as part of a SQL Server installation or adding it to an existing one and would like a step by step guide showing how to install it.
2023-07-31
GENERATE_SERIES: My new go-to to build sets
I have come across a lot of use cases for manufacturing rows on the fly, aside from the common goal of populating a large data set such as a numbers or calendar table. A few favorites include building sample data, pivoting an unknown number of columns, data extrapolation, and filling gaps in date or time ranges.
2023-07-26
SQL Server vs Oracle Query Statistics to Improve Performance
In this article, learn how to query cached query statistics and execution plans for Oracle or SQL Server to identify code that can be optimized to improve performance.
2023-07-21
SQL Server Database Backup and Restore Failure Notifications
My SQL Server backups and restores fail infrequently, but when I find out it is too late. How can I find out sooner?
2023-07-03
Cheat Sheet for SQL Server DBAs - Monitoring Current Activity, Blocking and Performance
It seems like every DBA has a USB stick or a shared drive filled with scripts they can pull up in almost any situation. How can I build such a library of T-SQL files?
2023-06-26
Troubleshoot SQL Server Deadlocks in Stored Procedures
Deadlocks can occur in any database system, and SQL Server is no exception. In this article, we look at the steps I used to detect and resolve deadlocks in stored procedures.
2023-06-23
ISJSON enhancements in SQL Server for valid JSON format for a Value, Array or Object
SQL Server supports working with JSON data and provides many different functions that can be used. SQL Server 2022 has expanded the ability to check if the JSON format is valid using the ISJSON function which we will cover in this article.
2023-06-19
SQL WHERE LIKE to Construct More Efficient Queries
In this article, we will discuss the purpose and use of the WHERE LIKE clause in SQL Server and how it can help you construct more efficient queries.
2023-06-02
Blogs
A New Word: Vicarous
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
SQL Server Cross Platform Availability Groups and Kubernetes
Say we have a database that we want to migrate a copy of into...
Using Managed Identities with Azure SQL DB
We are trying to get apps and users off of using SQL accounts to...
Forums
View works for me ...but doesn't return results for a user in SSMS but no errors
Hi I have this view to check if a job is running: SELECT...
Dark mode, other color schemes
All, if you are like me and do not care for the built-in color...
Question of the Day
Internal Checkpoints
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers