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,102 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,102 reads
In this SQL School Video, Brian Knight shows how to abstract your schema with views and synonyms.
2009-01-22
4,382 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,230 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,248 reads
Learn the basics of how to work with Management Studio in this SQL School video.
2009-01-01
7,821 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,010 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,720 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,061 reads
MVP Brian Knight brings us some details on the Aggregate transformation in Integration Services.
2008-12-04
4,417 reads
MVP Brian Knight shows how you can use precedence constraints to control the flow of your SSIS packages.
2008-11-27
5,065 reads
By Ed Elliott
The next example is how to do a ROW_NUMBER(), my favourite window function. T-SQL SELECT...
By Ed Elliott
I have been playing around with the new Azure Synapse Analytics, and I realised...
By Steve Jones
Some time ago I had downloaded all the SQL Saturday XML files. I’ve been...
Yes the databases (source and destination) are the same version. I have checked 3...
Comments posted to this topic are about the item The Time Zone Range
Comments posted to this topic are about the item Mathematicians and SQL