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
Brian Knight
Using Views and Synonyms for Abstraction - SQL School Video
In this SQL School Video, Brian Knight shows how to abstract your schema with views and synonyms.
2009-01-22
4,382 reads
Post SQL Server 2008 Upgrade - SQL School Video
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
SQL Server Options to Avoid - SQL School Video
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
SQL Server Management Studio for Beginners - SQL School Video
Learn the basics of how to work with Management Studio in this SQL School video.
2009-01-01
7,821 reads
Using the CheckSum Function - SQL School Video
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
Writing a Basic MDX Query Pt.2 - SQL School Video
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
Writing a Basic MDX Query Pt.1 - SQL School Video
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
Using the Aggregate Transform - SQL School Video
MVP Brian Knight brings us some details on the Aggregate transformation in Integration Services.
2008-12-04
4,417 reads
Using SSIS Precedence Constraints - SQL School Video
MVP Brian Knight shows how you can use precedence constraints to control the flow of your SSIS packages.
2008-11-27
5,065 reads
Blogs
Synapse Analytics Spark Example 2 - ROW_NUMBER()
By Ed Elliott
The next example is how to do a ROW_NUMBER(), my favourite window function. T-SQL SELECT...
Synapse Analytics Spark Example 1 - Group By
By Ed Elliott
I have been playing around with the new Azure Synapse Analytics, and I realised...
Renaming Files by Padding Numbers with PowerShell
By Steve Jones
Some time ago I had downloaded all the SQL Saturday XML files. I’ve been...
Forums
The media family on device incorrectly formed for read only file group restore
Yes the databases (source and destination) are the same version. I have checked 3...
The Time Zone Range
Comments posted to this topic are about the item The Time Zone Range
Mathematicians and SQL
Comments posted to this topic are about the item Mathematicians and SQL
Ask SSC