SQL Clone
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 425    Older >>
 

Using Client Tools - Level 4 of the Stairway to SQL Server on Linux

In the next level of the Stairway to SQL Server on Linux learn about the client tools available to connect to your instance.  Read more...
By Danilo Dominici 2019/03/13 | Source: SQLServerCentral.com | Category: sql server on linux
Rating: |  Discuss |   Briefcase | 289 reads

Pages and Extents: Stairway to SQL Server Indexes Level 4

We've now seen how indexed and non-indexed tables perform in queries, and established "logical reads" as the metric for query performance. Now it is time to explain why logical reads are an excellent metric and also explain what is actually being read.   Read more...
By David Durant 2019/03/06 (first published: 2019/01/16) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 14,037 reads

Updating Rows in Incremental Loads – Level 4 of the Stairway to Integration Services

Part four of this stairway series examines the process of updating the data in an existing table in a load. MVP Andy Leonard talks about the way in which packages can handle changes in a repeatable fashion.  Read more...
By Andy Leonard 2019/02/27 (first published: 2011/10/12) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 35,742 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 2019/02/20 (first published: 2015/09/09) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,229 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 2019/02/13 (first published: 2016/05/11) | Source: SQLServerCentral.com | Category: smo
Rating: |  Discuss |   Briefcase | 4,212 reads

Stairway to Data, Level 1: The Basics

A great deal of the confusion that occurs when a database application is developed comes from a poor understanding of the basics of data. Here, Joe Celko gives a broad coverage of the difficulties you're likely to meet when handling data in databases  Read more...
By Joe Celko 2019/02/06 (first published: 2011/05/12) | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 18,595 reads

Stairway to SSAS Tabular Level 5: Cleaning up Dimensions

In this fifth level of the SSAS Tabular stairway, learn how to clean up dimensions.  Read more...
By Thomas LeBlanc 2019/01/28 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 373 reads

Pages and Extents: Stairway to SQL Server Indexes Level 4

We've now seen how indexed and non-indexed tables perform in queries, and established "logical reads" as the metric for query performance. Now it is time to explain why logical reads are an excellent metric and also explain what is actually being read.   Read more...
By David Durant 2019/03/06 (first published: 2019/01/16) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 14,037 reads

Stairway to DAX and Power BI - Level 9: Function / Iterator Function Pairs: The DAX MAX() and MAXX() Functions

As a part of his "Function / Iterator Pairs" mini-series, Business Intelligence architect, Analysis Services Maestro, SQL Server MVP, and author Bill Pearson introduces the DAX MAX() and MAXX() functions, discussing similarities and differences. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating "largest numeric values" to meet differing needs within our PowerPivot model designs.  Read more...
By Bill Pearson 2019/01/09 (first published: 2015/01/14) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,867 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 2018/12/26 (first published: 2015/09/30) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,481 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 2018/12/19 (first published: 2015/11/04) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,280 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 2018/12/12 (first published: 2015/09/23) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,583 reads

Adding Disks - Level 3 of the Stairway to SQL Server on Linux

In this level we examine how to add disks to separate our data, log, and tempdb files.  Read more...
By Danilo Dominici 2018/12/05 | Source: SQLServerCentral.com | Category: sql server on linux
Rating: |  Discuss |   Briefcase | 274 reads

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 2018/11/28 (first published: 2016/08/17) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,843 reads

Permissions and Security in Dynamic Data Masking

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 2018/11/16 (first published: 2016/06/29) | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: |  Discuss |   Briefcase | 1,242 reads

Stairway to SQL PowerShell Level 11: SQL Server Maintenance Using SQL PowerShell

This level will demonstrate simple techniques to perform a few important SQL Server maintenance tasks using PowerShell. We'll barely scratch the surface of what's possible but I hope it will whet your appetite.  Read more...
By Ben Miller 2018/11/14 (first published: 2015/12/16) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,642 reads

Stairway to Columnstore Indexes Level 13: Improvements in SQL Server 2016

This stairway series was started in 2015. As such, the focus was on SQL Server 2012 and SQL Server 2014 only. When SQL Server 2016 was released, with lots of improvements in the columnstore technology, I decided to finish the planned levels with the original focus on SQL Server 2012 and 2014, and add one extra level with a brief overview of the improvements available in SQL Server 2016.  Read more...
By Hugo Kornelis 2018/11/07 (first published: 2017/06/07) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,826 reads

The Configured Data Masks for Dynamic Data Masking

Continuing with his look at Dynamic Data Masking, Steve Jones looks at the masking patterns available besides the default mask.  Read more...
By Steve Jones 2018/11/02 (first published: 2016/04/06) | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: |  Discuss |   Briefcase | 1,801 reads
   Items 1 to 20 of 425    Older >>