Articles

A Plunge Into TOP

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 […]

5 (6)

2019-06-04

3,806 reads

SQL Clone for Unit Testing Databases

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.

2019-06-04

Create and deploy Azure Resource Manager templates by using the Azure portal

 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 […]

2019-06-03

787 reads

Blogs

SQL Server Containers Are Boring

By

Not really, but sort of. The beauty of containers, at least in a dev/test...

Public Role Permissions – Back to Basics

By

If you are being serious in your role, then the amount of times you...

It’s interesting how an OR short circuits.

By

I recently did a post on the case expression short circuting and received a...

Read the latest Blogs

Forums

Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

Always on AG and SQL Upgrade

By Admingod

Looking to upgrade from SQL Server 2014 to SQL 2016 which has always on...

Migration from server to server

By rrizzojr

I recently migrated from Windows 2003 SBS running SQL 2005 Express along with SSMS...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers