The Query Answers with SQL Server Series
A series of articles based on the Query Answers with SQL Server book.
2018-06-29
4,027 reads
A series of articles based on the Query Answers with SQL Server book.
2018-06-29
4,027 reads
In this article I want to provide an introduction to the vital set of functions that help you to use a time element when analyzing data
2017-10-27 (first published: 2016-06-06)
6,803 reads
Power BI is as extensible as it is powerful In this article you will see how to impress your users with added visuals
2016-05-31
9,314 reads
In this article I would like to introduce you to PowerBI.Com to see how to share analyses in the cloud using SQL Server data
2016-05-23
1,333 reads
This article takes a simple look at loading data in parallel from a single data source, be it a flat file of a database
2015-08-03
6,869 reads
Optimize SSIS data loads using parallel processing and the Balanced Data Distributor
2015-07-02
7,260 reads
Part one of a four part series intent on demystifying and making more accessible SQL Server extended properties
2013-09-27 (first published: 2011-03-17)
21,996 reads
Need to understand new data? This article explains why - and how you can profile it efficiently
2013-02-25
23,021 reads
Of all the technical solutions to the problem of slowly changing dimensions, the T-SQL MERGE statement is one of the most elegant.
2011-06-20
38,348 reads
To finish this short series on extended properties a look at documenting sets of database objects
2011-04-05
8,527 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