Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Stairway Series Rss

Search for any content tagged stairway series

   Items 1 to 20 of 221    Older >>
 

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 2014/07/23 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,505 reads

Stairway to XML: Level 2 - The XML Data Type

Robert Sheldon describes SQL Server's XML Data Type, and shows that it is as easy to configure a variable, column, or parameter with the XML data type as configuring one of these objects with any other datatype  Read more...
By Rob Sheldon 2014/07/18 (first published: 2012/09/26) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 12,475 reads

SSRS In a Flash - Level 1 in the Stairway to Reporting Services

Learn the basics of Reporting Services, what it is, and what it can do from you. From MVP Jessica Moss, we have a new series that can help you get started with this part of SQL Server.  Read more...
By Jessica M. Moss 2014/07/04 (first published: 2010/04/06) | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 43,647 reads

Stairway to Biml Level 5 - Biml Language Elements

In the next level of the Stairway to Biml, we breakdown the various elements in a Biml file to help you understand what parts of the files are used to control the package generation.  Read more...
By Reeves Smith, Andy Leonard 2014/07/02 | Source: SQLServerCentral.com | Category: biml
Rating: |  Discuss |   Briefcase | 3,098 reads

The SSIS Data Pump - Level 2 of the Stairway to Integration Services

Learn the basics of data flow in SSIS with the data pump in this second installment of our series designed to teach you about Integration Services.  Read more...
By Andy Leonard 2014/06/27 (first published: 2011/02/17) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 45,723 reads

Stairway to T-SQL: Beyond The Basics Level 7: Controlling the Flow of Your T-SQL

When you are writing TSQL code there are times when you want to perform the same logic over and over again. To accomplish this you can used the WHILE keyword. There are other times when you want to perform a conditional test and depending on the results of the test you execute one code block for the TRUE condition and possibly a different code block when the condition is FALSE. When you need to conditionally execute code based on the outcome of a condition you can used the IF keyword. In this Stairway level I will be discussing how to use the WHILE and IF constructs to control the flow of your TSQL code.  Read more...
By Gregory Larsen 2014/06/25 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,664 reads

Stairway to SQL Server Security Level 2: Authentication

Authentication is the first step in letting a principal get access to an instance of SQL Server, essentially resolving the question, Who are you? In this stairway level you’ll learn about the basics of authentication and the authentication options available. This level covers logins and users and you’ll learn about the password policies that can help strengthen SQL Server authentication.  Read more...
By Don Kiely 2014/06/18 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,659 reads

Stairway to Database Source Control Level 2: Getting a Database into Source Control

In this level, we're going to continue the philosophy of learning by example, and get a database into our SVN repository. We will also consider our overall approach to source control for databases, and the manner in which our team will develop these databases, concurrently.  Read more...
By Dave Green 2014/06/11 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,133 reads

Stairway to SQL Server Security Level 1: Overview of SQL Server Security

The ubiquity of databases and the potentially valuable information stored in them makes them attractive targets for people who want to steal data or harm its owner by tampering with it. Making sure that your data is secure is a critical part of configuring SQL Server and developing applications that use it to store data.  Read more...
By Don Kiely 2014/06/04 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,448 reads

Stairway to SQLCLR Level 3: Security (General and SAFE Assemblies)

In the third level of our Stairway to SQLCLR, we look at the various mechanisms in place to help us control Security. In this Level we will focus on SAFE mode and see how secure SQLCLR is by default.  Read more...
By Solomon Rutzky 2014/05/28 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,772 reads

Deployment and Execution – Step 18 of the Stairway to Integration Services

In the next installment of the stairway to integration services, Andy Leonard looks at deploying and executing the package on an instance of SQL Server.  Read more...
Rating: |  Discuss |   Briefcase | 3,134 reads

Stairway to SQL PowerShell Level 7: SQL Server PowerShell and the Basics of SMO

In this level we begin our journey into the SQL Server SMO space. SMO stands for Shared Management Objects and is a library written in .NET for use with SQL Server. The SMO library is available when you install SQL Server Management Tools or you install it separately.  Read more...
By Ben Miller 2014/05/14 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,251 reads

Stairway to PowerPivot and DAX - Level 1: Getting Started with PowerPivot and DAX

Learning DAX is easy once you install the PowerPivot for Excel 2010 add-in and get practical exposure to using functions, operators and values in DAX formulas. Bill Pearson, business intelligence architect and author, kicks off another Stairway series designed to get you using DAX and PowerPivot quickly to provide actionable business intelligence in your own environment.  Read more...
By Bill Pearson 2014/05/07 (first published: 2011/12/21) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 19,975 reads

Stairway to SQL PowerShell Level 6: PowerShell Modules

In this level, we will walk through creating and using modules for PowerShell. Modules are simply a collection of functions that are most likely related to each other and packaged in a way that allow you to import them as a group.  Read more...
By Ben Miller 2014/04/30 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,250 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 2014/04/23 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,618 reads

Stairway to SQL Server Agent - Level 9: Understanding Jobs and Security

Security is a confusing topic to many, especially when it comes to understanding what rights are needed to monitor and use SQL Server Agent. This article will examine the rights and roles used for SQL Server Agent, as well as the security context requirements for jobs.  Read more...
By Richard Waymire 2014/04/16 (first published: 2012/01/11) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,564 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 2014/04/09 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 9,798 reads

Stairway to T-SQL: Beyond The Basics Level 5: Storing Data in Temporary Tables

There are times when retrieving data for complex business requirement requires you to temporarily store one or more results sets for a short period of time. Typically these temporary tables are stored in the scope of the current connection, but they may also need to be available across multiple connections.   Read more...
By Gregory Larsen 2014/04/02 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,519 reads

Stairway to XML: Level 1 - Introduction to XML

In this level, Rob Sheldon explains what XML is, and describes the components of an XML document, Elements and Attributes. He explains the basics of tags, entity references, enclosed text, comments and declarations  Read more...
By Rob Sheldon 2014/03/26 (first published: 2012/09/20) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 28,582 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 2014/03/19 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,492 reads
   Items 1 to 20 of 221    Older >>