Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Mike McQuillan

SQLServerCentral.com profile

   Items 1 to 16 of 16   
 

Stairway to U-SQL Level 11: Stored Procedures

To finish off our look at the core database objects, we inspect how the venerable stored procedure works in U-SQL.  Read more...
By Mike McQuillan 2016/11/16 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,228 reads

Stairway to U-SQL Level 10: Table-Valued Functions and UDTs

Table-Valued Functions and User-Defined Types can help you write parameterised U-SQL views in an elegant manner. They also aid code reuse.  Read more...
By Mike McQuillan 2016/10/12 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,150 reads

Using OVER() to Remove Duplicate Rows

Tables used purely for reporting sometimes lack a unique identifier. Find out how to remove duplicates from such a table when data loads go bad.  Read more...
By Mike McQuillan 2016/11/08 | Source: SQLServerCentral.com | Category: over
Rating: |  Discuss |   Briefcase | 3,308 reads

Using OVER() to Fix Bad Version Numbers

See how the OVER() clause was used in a live system to fix overlapping field version numbers.   Read more...
By Mike McQuillan 2016/10/17 | Source: SQLServerCentral.com | Category: over
Rating: |  Discuss |   Briefcase | 2,040 reads

Stairway to U-SQL Level 9: Views and C# Expressions

Learn how U-SQL views can hide complexity and use C# expressions, providing powerful ways to format and return your data.  Read more...
By Mike McQuillan 2016/10/05 | Source: SQLServerCentral.com | Category: u-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,046 reads

Stairway to U-SQL Level 8: Joining Tables in U-SQL

U-SQL provides a number of ways to join data sources together. This articles introduces the joins available and how you can use them.  Read more...
By Mike McQuillan 2016/09/14 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,510 reads

Stairway to U-SQL Level 7: More Partition Schemes

Following on from our previous introduction to indexes and partition schemes, we review the distribution schemes used by horizontal partitioning.  Read more...
By Mike McQuillan 2016/08/24 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 778 reads

Stairway to U-SQL Level 6: U-SQL Indexes and Partition Schemes

Find out how to speed up your queries by indexing and partitioning data, U-SQL style.  Read more...
By Mike McQuillan 2016/08/10 | Source: SQLServerCentral.com | Category: u-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,138 reads

Stairway to U-SQL Level 5: Databases and Tables in Azure Data Lakes with U-SQL

A guide to using databases, schemas and tables in Azure Data Lakes, using (of course!) U-SQL.  Read more...
By Mike McQuillan 2016/07/27 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 430 reads

Stairway to U-SQL Level 4: U-SQL and Data Lake Tooling with Visual Studio

A guide to using Visual Studio to create U-SQL projects and scripts.  Read more...
By Mike McQuillan 2016/07/20 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,172 reads

Stairway to U-SQL Level 3: Processing Multiple Files With U-SQL

In part 3 of the U-SQL Stairway, we look at how multiple files can be processed with a single U-SQL statement.  Read more...
By Mike McQuillan 2016/07/06 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,733 reads

Stairway to U-SQL Level 2: Breakdown of a U-SQL Statement

Following on from our introduction to U-SQL, we take a look at how a typical U-SQL statement is constructed.  Read more...
By Mike McQuillan 2016/06/22 | Source: SQLServerCentral.com | Category: usql
Rating: |  Discuss |   Briefcase | 3,581 reads

Stairway to U-SQL Level 1: Introduction to U-SQL and Azure Data Lakes

An introductory guide to querying files in Azure Data Lakes using Microsoft's U-SQL language.  Read more...
By Mike McQuillan 2016/06/15 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 4,759 reads

Guide to MCITP: SQL Server 2008 BI Developer

A guide to the SQL Server 2008 Business Intelligence exams.  Read more...
Rating: |  Discuss |   Briefcase | 12,030 reads

Guide To MCITP: SQL Server 2008 Administration

Find out what you need to learn for the SQL Server 2008 Administration certification exams.  Read more...
By Mike McQuillan 2011/08/05 | Source: SQLServerCentral.com | Category: mcts
Rating: |  Discuss |   Briefcase | 8,516 reads

Guide to MCITP: SQL Server 2008 Developer

An overview of what's involved in the two exams you need to pass to become a Microsoft IT Professional in SQL Server 2008.  Read more...
By Mike McQuillan 2009/08/21 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 10,174 reads
   Items 1 to 16 of 16