Introduction TOP is one of the many syntactical operators available in T-SQL and at a first view, it could seem very simple and not particularly interesting. According to the official documentation, it “limits the rows returned in a query result set to a specified number of rows or percentage of rows”. The following is the […]
This Friday's poll looks at the time after deployment. Can you tell if things were successful? Do you have a formal way to determine if the changes are causing issues?
Learn how to remove gaps in Identity values in SQL Server caused by Identity Cache.
Phil Factor demonstrates how to use SQL Clone to create 'disposable' SQL Server databases, for development and testing work. You can spin up a clone, use it to unit test your code, messing up the clone in the process, then reset the clone in seconds, ready for the next test.
In this tip we look at how to use Common Table Expressions CTE in SQL Server including the syntax, use cases, using more than 1 CTE at the same time and recursive CTEs with a parameter.
This article will explain and help to create and deploy ARM templates using the Azure portal. When Azure was first created, Azure resources were managed using the Azure service management (ASM), which is also known as “Classic”. Now this has been replaced and is called the Azure resource manager (ARM) API. ARM is the deployment […]
There are many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a query fit the needs of the people viewing it.
SQL Server has many tools used to make it secure. In this article, Robert Sheldon demonstrates several of these features including SQL Server Configuration Manager and the Vulnerability Assessment tool.
Just as you write a unit test before writing the code, so you must devise the means to monitor a database, to ensure its smooth operation, before creating the database.
This will allow you to create "Data-Driven" subscriptions on your Standard SQL Server version.
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
I’m doing a small series on indexing basics for SQL Server, and on May...
Gedung Tanah Abang Zona III Lantai 3A L03A, Jl. KH. Fachrudin, Kp. Bali, Kecamatan...
Jl. Percetakan Negara II No.16 B-C, RT.3/RW.3, Johar Baru, Kec. Johar Baru, Kota Jakarta...
Kawasan Terpadu Pusat Kota, Gedung Perkantoran Tower One, Lantai Dasar, Jl. KH Mas Mansyur...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers