Viewing the Data Profiling Task Data - SQL School Video
It can be helpful in ETL operations to know what the distribution of your data is. Brian Knight shows how to use the Data Profiling task in this video.
2009-01-27
5,119 reads
It can be helpful in ETL operations to know what the distribution of your data is. Brian Knight shows how to use the Data Profiling task in this video.
2009-01-27
5,119 reads
In this SQL School Video, Brian Knight shows how to abstract your schema with views and synonyms.
2009-01-22
4,390 reads
After you complete an upgrade to SQL Server 2008, Brian Knight goes over some things you might want to do first.
2009-01-08
3,231 reads
Not every option in SQL Server is useful or appropriate. Brian Knight shows which ones you might not wish to mess with.
2009-01-06
6,253 reads
Learn the basics of how to work with Management Studio in this SQL School video.
2009-01-01
8,064 reads
There are times that you want to determine quickly if any data has changed. Brian Knight shows how checksums can be used in T-SQL.
2008-12-18
6,103 reads
In the second part of this basic video on MDX queries, MVP Brian Knight continues with his discussion of MDX, examining some more advanced MDX features.
2008-12-11
6,727 reads
MDX is the query language for multidimensional queries, usually against SSAS cubes. Brian Knight introduces us to the basics of MDX in this video.
2008-12-09
9,133 reads
MVP Brian Knight brings us some details on the Aggregate transformation in Integration Services.
2008-12-04
4,421 reads
MVP Brian Knight shows how you can use precedence constraints to control the flow of your SSIS packages.
2008-11-27
5,069 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