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

Articles with tag stairway series Rss

Search for any content tagged stairway series

   Items 1 to 20 of 317    Older >>
 

Stairway to SQL Server Extended Events Level 4: Extended Events Engine - Essential Concepts

In this level, we're going to dig a little deeper into the Extended Events engine, its architecture, and fundamental components. It will give you a deeper understanding of why, in general, an Extended Events session is inherently lower in overhead than an equivalent SQL Trace. We'll also investigate how to design our event sessions to minimize any unnecessary overhead during event data collection, even when we need to create relatively complex event sessions to investigate difficult performance problems.  Read more...
By Erin Stellato 2016/08/17 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 792 reads

Stairway to Exploring Database Metadata Level 1: Why Should You Care About the Dynamic Online Catalog?

In this first level, we look at the overview of what metadata is contained in each database, gain some understanding of the different types of information, and examine a few basic examples.  Read more...
By Phil Factor 2016/08/03 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,201 reads

Stairway to T-SQL: Beyond The Basics Level 9: Dynamic T-SQL Code

There times when you need to write T-SQL code that creates specific T-SQL Code and executes it. When you do this you are creating dynamic T-SQL code. When writing dynamic T-SQL you need to understand how dynamic code opens the possibilities for a SQL injection attack.  Read more...
By Gregory Larsen 2016/07/29 (first published: 2014/07/23) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,476 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: (not yet rated) |  Discuss |   Briefcase | 331 reads

Stairway to T-SQL: Beyond The Basics Level 4: Using Views to Simplify Your Query

This level discusses how to use a database VIEW to simplify your Transact-SQL(T-SQL) code. By understanding how to use a VIEW you will be able to better support writing T-SQL code to meet complex business requirements. In this article I will be discussing what a database VIEW is and then providing a number of examples to help you understand how you can use a VIEW to implement different coding scenarios.  Read more...
By Gregory Larsen 2016/07/22 (first published: 2014/03/19) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,452 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,050 reads

Stairway to DLM Dashboard Level 2: Setting up DLM Dashboard

Learn how to install and configure your initial DLM Dashboard instance.  Read more...
By Owen Priestley 2016/07/14 | Source: SQLServerCentral.com | Category: dlm dashboard
Rating: (not yet rated) |  Discuss |   Briefcase | 533 reads

Stairway to Server Management Objects (SMO) Level 2: Connections and Creating Server Inventories

Learn how to get started working with SMO and PowerShell.  Read more...
By Laerte Junior 2016/07/13 | Source: SQLServerCentral.com | Category: smo
Rating: |  Discuss |   Briefcase | 1,024 reads

Stairway to DLM Dashboard Level 1: An Introduction

In the first article of this stairway, learn what DLM Dashboard can do and how it provides a useful service to DBAs and developers.  Read more...
By Owen Priestley 2016/07/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: (not yet rated) |  Discuss |   Briefcase | 951 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,587 reads

Stairway to SQL Server Virtualization Level 1: What is Virtualization?

The first level in the Stairway to Virtualization introduces the concept of virtualized servers as well as the terminology and benefits of implementing the technology.  Read more...
By David Klee 2016/07/04 (first published: 2014/08/06) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,190 reads

Stairway to Dynamic Data Masking Level 4: Permissions and Security

Learn about the permissions associated with Dynamic Data Masking as well as some of the security implications of using this feature.  Read more...
By Steve Jones 2016/06/29 | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: |  Discuss |   Briefcase | 705 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 | 3,791 reads

Stairway to Database Design Level 2: Domains, Constraints and Defaults

A clear understanding of SQL Data Types and domains is a fundamental requirement for the Database Developer, but it is not elementary. If you select the most appropriate data type, it can sidestep a variety of errors. Furthermore, if you then define the data domains as exactly as possible via constraints, you can catch a variety of those problems that would otherwise bedevil the work of the application programmer.  Read more...
By Joe Celko 2016/06/01 (first published: 2010/05/04) | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 24,749 reads

Stairway to Columnstore Indexes Level 1: A First Look At Columnstore Indexes

This level introduces of you to the fundamentals of columnstore indexes, introdused in SQL Server 2012 to manage the indexing of very large tables.  Read more...
By Hugo Kornelis 2016/05/30 (first published: 2015/02/25) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,738 reads

Stairway to SQL Server Extended Events Level 3: Working with the Extended Events UI

In the next installment of our stairway to Extended Events, we delve into the Live Data and Target Data Viewers.  Read more...
By Erin Stellato 2016/05/25 | Source: SQLServerCentral.com | Category: extended events
Rating: |  Discuss |   Briefcase | 1,281 reads

Stairway to Database Source Control Level 5: Working with Others (Distributed Repository)

This level starts with an overview of how versioning works in Git, a DVCS, and suggests a sensible database project versioning strategy. It then offers some simple, but illustrative, practical examples showing how to share database changes and deal gracefully with any conflicting changes.  Read more...
By Dave Green 2016/05/18 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 949 reads

Stairway to Server Management Objects (SMO) Level 1: Concepts and Basics

Learn how to get started working with SMO and PowerShell.  Read more...
By Laerte Junior 2016/05/11 | Source: SQLServerCentral.com | Category: smo
Rating: |  Discuss |   Briefcase | 2,556 reads

Stairway to T-SQL: Beyond The Basics Level 6: Using the CASE Expression and IIF Function

There are times where you need to write a single T-SQL statement that is able to return different T-SQL expressions based on the evaluation of another expression. When you need this kind of functionality you can use the CASE expression or IIF function to meet this requirement. In this Stairway level Gregory Larsen reviews the CASE and IIF syntax and showing you examples of how the CASE expression and IIF function.  Read more...
By Gregory Larsen 2016/04/20 (first published: 2014/04/09) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 15,589 reads

Stairway to Advanced T-SQL Level 2: Using the APPLY Operator

The APPLY operator allows you to join a record set with a function, and apply the function to every qualifying row of the table (or view). The APPLY operator takes on two formats: CROSS APPLY, or OUTER APPLY. This article will explain the differences between these two formats, and show you examples of how each of these formats work.  Read more...
By Gregory Larsen 2016/03/30 (first published: 2015/01/28) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 17,152 reads
   Items 1 to 20 of 317    Older >>