Why Performance Tuning Isn’t Just “Add an Index” Every time someone asks me for help with a “slow SQL Server,” the first thing I do is not look at the query. I know that sounds backwards, but hear me out — over the years I’ve lost count of how many times I got called in […]
Continue Reading
Over the years of working hands-on as a database developer and DBA, I’ve run into more production surprises than any single course or certification ever prepared me for — queries that mysteriously slow down for no visible reason, audit requirements that show up after a schema’s already frozen, reports that quietly regress the week after […]
Continue Reading
If you’re a DBA or sysadmin managing more than one or two SQL Server instances, you already know the drill: log in, run the same handful of queries, eyeball the results, move to the next server. Do that every morning for a few years and it stops being “quick” — it’s just quiet, repetitive risk. […]
Continue Reading
.NET 11 is on its way, and the internet is buzzing. As expected, most of the noise is about Runtime Async V2 and C# Union Types — the two headliners that developers have been demanding for years. But while everyone is gathered around those two features, a few genuinely impressive additions are sitting quietly in […]
Continue Reading
Windows 11 isn’t just a visual refresh—it’s a productivity-focused operating system packed with keyboard shortcuts that can save you hours every week. While most users rely heavily on the mouse, seasoned Windows users and professionals know that keyboard shortcuts are where real efficiency lives. In this article, we’ll explore 20 essential Windows 11 shortcut […]
Continue Reading
In the world of modern data-driven applications, the ability to extract insights from raw data is a vital skill. Microsoft SQL Server’s Transact-SQL (T-SQL) language offers a rich set of features that allow developers and data analysts to manipulate and query data with precision and efficiency. Among its most powerful constructs are Common Table Expressions […]
Continue Reading
Whenever you happen to work with INSERT or UPDATE Transact-Sql queries, either from within Sql Serve Management Studio or through your favorite programming platform like Visual Studio, you’re often likely to stumble across the error message that says: String or binary data would be truncated… and your query fails right away. The message is […]
Continue Reading
The REPLICATE() function in SQL Server is a powerful tool for string manipulation, allowing developers to repeat a specified string a given number of times. This capability is particularly useful in scenarios where consistent data formatting or data masking is required. Let’s delve into two common use cases: formatting numbers with leading zeros and masking […]
Continue Reading
In a previous article we learnt how to use CTE (Common Table Expression) to render dates in a date range. In this example we’ll use somewhat advance technique to show a data in a heirarchical form. Using the regular T-SQL query this is almost impossible to achieve it without coding in a strored procedure […]
Continue Reading
Using a traditional programming language like C# or Python you can use “for” and “while” loop constructs to generate a sequence of numbers, dates, string values or anything else super-easily. But here we’ll learn how to generate date values in a specific range using Transact-SQL query. We’ll not use any SQL stored procedure. Let’s […]
Continue Reading