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

<< Newer    Items 21 to 40 of 299    Older >>
 

Stairway to T-SQL: Beyond The Basics Level 1: The TOP Clause

The first topic in this stairway will be discussing the TOP clause. The TOP clause allows you to control the number of rows to be returned or affected by a query.  Read more...
By Gregory Larsen 2015/11/20 (first published: 2014/01/15) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 21,643 reads

Stairway to Biml Level 2: Biml Basics

The next step in the stairway to Biml teaches you how to build a basic SSIS package using the scripting language.  Read more...
By Andy Leonard 2015/11/13 (first published: 2013/07/31) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 20,042 reads

An Overview of SSIS Variables – Step 13 of the Stairway to Integration Services

In this level of the Integration Services Stairway article, Andy Leonard examines SSIS variables.  Read more...
By Andy Leonard 2015/11/06 (first published: 2013/06/19) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 15,450 reads

Stairway to Columnstore Indexes Level 5: Adding New Data To Columnstore Indexes

Earlier levels have shown how Columnstore Indexes work effectively with static data. In most tables however, data is hardly ever static. We are constantly inserting new rows, and updating or deleting existing rows. If you think about what this means for a columnstore index, you will realize that this comes with some unique challenges.  Read more...
By Hugo Kornelis 2015/11/04 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,717 reads

Stairway to Advanced T-SQL Level 8: Functions to Generate Date and Time values

When you build applications that store records in SQL Server you will most likely have to store date and time values as part of the data. To manage all the different date related tasks you might need to perform Microsoft has introduced a number of date functions. In this stairway I will be exploring those date and time functions.  Read more...
By Gregory Larsen 2015/10/21 | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,857 reads

Level 4 - Building the Hyper-V VM

In this level of the Stairway to Server Virtualization, learn how to build a Hyper-V virtual machine for SQL Server.  Read more...
By David Klee 2015/10/07 | Source: SQLServerCentral.com | Category: virtualization
Rating: |  Discuss |   Briefcase | 3,732 reads

Stairway to MDX - Level 15: Basic Set Functions: The Tail() Function

Return, in order, a specified number of elements from the end of a set. SSAS Maestro, SQL Server MVP and Business Intelligence Architect Bill Pearson introduces the MDX Tail() function.  Read more...
By Bill Pearson 2015/09/30 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,943 reads

Stairway to SQL Server Security Level 11: Auditing

By defining server- and database-level audits, you can record just about any kind of event that occurs in SQL Server, which can be an invaluable source of security troubleshooting and forensic information when security breaches occur. In this stairway level you’ll learn how to define the various audit specification objects, how to capture audit data, and how to explore and use the data.  Read more...
By Don Kiely 2015/09/23 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,766 reads

Stairway to MDX - Level 14: Basic Set Functions: The Head() Function

SSAS Maestro, SQL Server MVP and Business Intelligence Architect Bill Pearson introduces the MDX Head() function, which allows us to return, in order, a specified number of elements within a set.  Read more...
By Bill Pearson 2015/09/09 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,825 reads

Stairway to Advanced T-SQL Level 7: Ordering Your Data Using Ranking Functions

In SQL Server there are 4 different ranking functions: RANK, DENSE_RANK, NTILE, and ROW_NUMBER. These ranking functions were introduced in SQL Server 2005. In this stairway level I will be reviewing each of these different ranking functions, and will show you how to use them by providing a few examples.  Read more...
By Gregory Larsen 2015/09/02 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,936 reads

Stairway to MDX - Level 13: MDX Time/Date Series Functions: LastPeriods() and ParallelPeriod() Functions

BI Architect Bill Pearson continues with the third of a subseries surrounding a group of MDX functions we can use to support analysis and reporting in a time / date context. In this Level, we will explore the LastPeriods() and ParallelPeriod() functions, and get hands-on practice with each in meeting sample business requirements.  Read more...
By Bill Pearson 2015/08/14 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,231 reads

Stairway to Biml Level 3: Building an Incremental Load Package

The Stairway to BIML continues, with a lesson on how you might build a more complex package: an incremental load package.  Read more...
By Andy Leonard 2015/08/12 (first published: 2013/08/07) | Source: SQLServerCentral.com | Category: biml
Rating: |  Discuss |   Briefcase | 18,767 reads

Stairway to Columnstore Indexes Level 4: Catalog Views

In this level, we will first take a look at how to recognize columnstore indexes in some of the generic catalog views. After that we will investigate the new catalog views that have been added just for columnstore indexes.  Read more...
By Hugo Kornelis 2015/08/05 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,756 reads

Stairway to SQL Server Security Level 10: Row-Level Security

Unlike some other industrial-strength database servers, SQL Server lacks a built-in mechanism for protecting individual data records, called row-level security. This stairway level explores why you might want to use such a low-level granularity of data access security and how you can implement row-level security.  Read more...
By Don Kiely 2015/07/29 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,440 reads

Stairway to MDX - Level 12: : MDX Time/Date Series Functions: OpeningPeriod() and ClosingPeriod() Functions

BI Architect Bill Pearson continues with the second of a set of articles surrounding a group of MDX functions specialized to support the analysis of data within the context of time / date. In this article, we will explore the OpeningPeriod() and ClosingPeriod() functions, and get hands-on practice with each in meeting sample business requirements.  Read more...
By Bill Pearson 2015/07/22 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,226 reads

Stairway to Database Source Control Level 1: Setting Up For Database Source Control

The first level of this stairway introduces the basics of source control, some common technologies and technologies, and demonstrates how to start versioning a SQL Server database.  Read more...
By Dave Green 2015/07/15 (first published: 2014/04/23) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 13,029 reads

Extending Custom Execution in the SSIS Catalog – Level 21 of the Stairway to Integration Services

In this installment of the Stairway to Integration Services, Andy Leonard shows you how to execute packages synchronously or asynchronously.  Read more...
Rating: |  Discuss |   Briefcase | 3,505 reads

Stairway to AlwaysOn Level 7: Combining FCIs with Availability Groups

In Level 7 of this stairway, we look at combining Availability Groups with FCIs for both HA and DR protection.  Read more...
By Perry Whittle 2015/07/01 | Source: SQLServerCentral.com | Category: high availability
Rating: |  Discuss |   Briefcase | 2,857 reads

Stairway to Advanced T-SQL Level 6: Creating Rows Of Data Using The UNPIVOT Operator

The UNPIVOT operator does just the opposite of the PIVOT operator, which we looked at in the previous level. By using the PIVOT operator we can take multiple rows of data and create as single row as output. The UNPIVOT operator will take values from a single row and will create multiple rows. Microsoft introduced the UNPIVOT operator when they rolled out SQL Server 2005. In this level I will be showing you different examples of how to use the UNPIVOT operator.  Read more...
By Gregory Larsen 2015/06/24 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,843 reads

Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions

BI Architect Bill Pearson launches a set of articles surrounding a group of MDX functions specialized to meet the pervasive business need to analyze data within the context of time / date. In this article, we will overview the PeriodsToDate() function, and then we will introduce "shortcut" functions that are based upon it.  Read more...
By Bill Pearson 2015/06/17 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,566 reads
<< Newer    Items 21 to 40 of 299    Older >>