Connect to SQL Azure database from SSMS
In this article I’ll show you how to connect to SQL Azure database instance and create a simple database. First you have...
2016-10-11
267 reads
In this article I’ll show you how to connect to SQL Azure database instance and create a simple database. First you have...
2016-10-11
267 reads
This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that:...
2016-10-02
462 reads
This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that: You simply forgot to change the name of your...
2016-10-02
This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that: You simply forgot to change the name of your...
2016-10-02
26 reads
This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that:...
2016-10-02
280 reads
Administering SQL ServerBelow are the topics every Administrator has to keep up with.Backup / Restore:Understand the backup / restore options SQL Server...
2016-09-19
182 reads
Below are the topics every Administrator has to keep up with. Backup / Restore: Understand the backup / restore options SQL Server provides for you. Implement those on your...
2016-09-19
1 reads
Below are the topics every Administrator has to keep up with. Backup / Restore: Understand the backup / restore options SQL Server provides for you. Implement those on your...
2016-09-19
Below are the topics every Administrator has to keep up with.
Backup / Restore:
Understand the backup / restore options SQL Server provides for...
2016-09-19
179 reads
Introduction The process that writes the dirty pages from the system memory (RAM) to the disk is called the checkpoint process. Dirty pages consist of the data and log...
2016-07-12
37 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Testing with AG on Linux with Cluster=NONE. it was all going ok and as...
Hi, I have two tables: one for headers with 9 fields and another for...
We're trying to understand how quick new versions of SQL server can be. Obviously...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers