Microsoft SQL Server Tutorials
In this comprehensive article, I’ll walk you through multiple methods to get weekdays from dates in SQL Server, explain their performance implications with multiple examples. SQL Server Weekday From Date Before diving into the technical details, let’s understand why extracting weekday information is so valuable: Now, let’s explore the various methods to get weekday from … Read more
One of the most common requirements is checking if a date field contains today’s date. In this comprehensive article, I’ll walk you through multiple methods to check if a date is today in SQL Server, sharing the techniques. SQL Server Check If Date Is Today Before diving into specific solutions, it’s essential to understand why … Read more
Recently, I was executing a select query to check if date is today in SQL Server for one of the requirements. In this article, I will discuss the cause and solution to fix this error. The datepart millisecond is not supported by date function dateadd for data type date. I was executing the following SQL … Read more
In this comprehensive article, I’ll share everything you need to know about SQL Server short date formatting, including multiple techniques, performance considerations, and best practices that I’ve learned throughout my career. SQL Server Short Date Before diving into the specifics, it’s essential to understand why date formatting is so crucial. In the United States, we … Read more
As a database administrator or developer working with SQL Server, tracking service dates is essential for maintaining system health and troubleshooting issues. In this article, I’ll walk you through different approaches to find service dates in SQL Server, including installation dates, service pack updates, and maintenance activities. How to look for date of service in … Read more
Knowing how to efficiently retrieve the first day of a month in SQL Server is an essential skill for a developer. In this comprehensive article, I’ll walk you through multiple approaches and explain when to use each approach, providing examples along the way. SQL Server First Date Of Month Before diving into the technical solutions, … Read more
As a database administrator or developer, knowing when a table was last modified is crucial for effective data management, auditing, and troubleshooting. I’ve relied on several approaches to track these changes accurately. In this article, I’ll share these methods with you in detail. SQL Server Table Last Modified Date Before diving into the technical aspects, … Read more
As a database administrator or security professional, monitoring your SQL Server certificates is crucial for maintaining secure connections and preventing unexpected downtime. In this comprehensive article, I’ll walk you through various approaches to check the expiration dates of your SQL Server certificates. How to check SQL Server certificate expiration date Before diving into the methods, … Read more
In this comprehensive article, I’ll walk you through multiple approaches to add months to date in SQL Server, complete with real-world examples. You’ll learn not only the syntax but also the performance implications and best practices for each method. Add Month To Date SQL Server Let’s take a deep dive into all the possible approaches … Read more
As a SQL developer, I often received the requirement to retrieve a date from SQL Server. In this comprehensive guide, I’ll walk you through multiple methods for extracting date components from SQL Server timestamps with practical examples. Get Date From Timestamp SQL Server Before diving into extraction methods, it’s essential to clarify what we mean … Read more