Using a CTE as a Tally Table
Sometimes you need to output blank lines
- in effect displaying Records for Missing Data. This article explains how to use a CTE to do this
The Top Five Things That DBAs Need to Monitor
Being a database administrator is much more than knowing how to install SQL Server and set up a database. One of the most important responsibilities is being proactive by monitoring the instances in their care. But, what should be monitored? Here are the top five things to monitor when you are a SQL Server DBA
Dynamic SQL Crossword
This crossword is based on terms you might come across in an article about Dynamic SQL.
SQL Server Index Tutorial Overview
Although there are many different things that can be done to improve the performance of a database system, creating an index is the main tool in every DBA's toolbox that is used when we are trying to improve the performance of a query.
Steps to Migrate Oracle Database to Azure SQL Database
In the world of paradigm shifts, many organizations are looking at the prospect of a technology migration, where capabilities are moved to a new set of technologies, supporting and enabling the business for the future. On other hand, a technology or platform may reach the end of its life for other business reasons, like ease of use, increased cost, etc.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
Cara menghubungi Cs AirAsia
Saluran resmi AirAsia, Anda dapat menghubungi Call Center AirAsia +62.821-3111-157 atau melalui WhatsApp CS...
BCA KCP Batu Ceper Telp/WA.0851°8812°0691
BCA KCP Batu Ceper Telp/WA.0851°8812°0691 Kawasan Pusat Niaga Terpadu Blok A No. 8 F,...
BCA KCP Pondok Indah Tlpn/wa0853.7373-7551
Tlpn/wa0853.7373-7551 Jl. Metro Pondok Indah No.60 & 61 UA, Pd. Pinang, Kec. Kebayoran Lama,...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers