Paging Data in T-SQL
This article will show you how to page through a set of results using the OFFSET and FETCH options of the ORDER BY clause.
2023-06-28
T-SQL
REPLACE versus TRANSLATE for SQL Server Text Data Manipulation
Learn how to replace text in SQL Server strings using the REPLACE and TRANSLATE functions and how these could be used for data manipulation.
2023-05-19
Find 40 Problems in this SQL Server Stored Procedure
I often perform code reviews and thought it would be fun to frame this exercise: a completely fictitious stored procedure hits my desk, I’ll reject it of course, and enumerate the reasons why.
2023-05-10
Performance Tuning with SQLFacts Tools
The need for performance tuning your SQL Server workloads has never been more critical. As workloads are moved into cloud services, their efficiency has a direct impact on the recurring bills. A workload that consumes more resources than necessary costs more to host in the cloud and affects the bottom line for your organization.
2023-04-07
10,330 reads
DAX CASE Statement Functionality with IF, SWITCH and SWITCH True
The CASE expression is one of the most valuable tools in your T-SQL toolbox. I use it in almost every query I write. However, there isn't a direct equivalent of CASE in DAX. Since it's a different language entirely, I don't expect it. As my grandmother used to say, I am not surprised, just disappointed. If you don't know, DAX (Data Analysis Expressions) is a language for creating custom calculations and aggregations in Power Pivot, Power BI, and other data analysis tools. Two functions in DAX come close to replicating the functionality but come with limitations. Which one of these functions should you use? Please stay tuned.
2023-04-03
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 to that article. We will show some […]
2023-03-06
46,406 reads
Getting started with ROUND() and Its Use Cases
Learn the basics of the ROUND() function in this article.
2022-12-02
2,977 reads
How to get IO statistics of SQL Server database files
This article shows how you can query your database files to get metadata about them and use that to get the reads, writes, and other IO statistics.
2022-11-18
7,917 reads
SQL Server Engineering Using Free Tools
You can master engineering for your SQL Server databases, on premises or in the cloud, with a FREE toolkit!
2022-10-28
4,654 reads
Data Lineage Scripts for Microsoft SQL Server and Azure SQL
Learn how you can easily analyze the data lineage in your SQL Server database.
2022-10-19
7,292 reads
Blogs
Migrate datetime data to datetimeoffset with AT TIME ZONE
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
The Comprehensive Guide to Mastering Your SQL DBA Skills
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
Friday Basics: Authentication vs. Authorization
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Forums
Performance
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
How to install mysql-connector-python-8.4.0.zip it does not have setup.py
How to install mysql-connector-python-8.4.0.zip it does not have setup.py. Checked also: mysql-connector-python-8.4.0.tar.gz
when primary is down and not accessible failover not occured then how to recover
HI All, can any one reply on this when primary is down and not...
Question of the Day
Two Table Hints
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers