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

Content with tag Stairway Series Rss

<< Newer    Items 41 to 60 of 331    Older >>
 

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,854 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,479 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,235 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,281 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,551 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,929 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,885 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,586 reads

Stairway to Columnstore Indexes Level 3: Building The Columnstore

The performance increase columnstore indexes grant when reading data from the index is offset by the expensive process required to build the index. In this Stairway level, Hugo Kornelis walks you through the steps SQL Server takes when building (or rebuilding) a columnstore index.  Read more...
By Hugo Kornelis 2015/06/10 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,874 reads

Stairway to SQL Server Security Level 9: Transparent Data Encryption

Even an otherwise well-secured database is susceptible to attack if an attacker is able to get access to the disk files that comprise the database. Cell-level encryption can protect some of the data, but for complete protection against this kind of attack it is necessary to encrypt the files and not just the data. That is exactly what Transparent Data Encryption (TDE) does, and in this stairway level you'll learn what TDE does, how it works, and how to make use of it to protect your database files.  Read more...
By Don Kiely 2015/06/03 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,480 reads

Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator

The PIVOT operator was added to the Transact-SQL language in SQL Server 2005. It allows you to turn your row data on its side, so it can be presented as column data. This is useful when you want take unique column values and have them displayed as column headings, where the column headings are associated with summarized values displayed below each column heading. In this article I will be exploring how to use the PIVOT operator.   Read more...
By Gregory Larsen 2015/05/27 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,530 reads

Level 3 - Building the Ideal VMware-based SQL Server Virtual Machine

In this level of the Stairway to SQL Server Virtualization David looks at the ideal virtual machine setup for a SQL Server instance on VMware.  Read more...
By David Klee 2015/05/20 | Source: SQLServerCentral.com | Category: virtualization
Rating: |  Discuss |   Briefcase | 7,810 reads

Level 2 - The Ideal SQL Server Virtual Machine Architecture

In Level 2 of the Stairway to SQL Server Virtualization, we examine the ideal VM configuration from a standpoint of the various resources involved.  Read more...
By David Klee 2015/05/13 | Source: SQLServerCentral.com | Category: virtualization
Rating: |  Discuss |   Briefcase | 12,437 reads

Stairway to Advanced T-SQL Level 4: Record Level Processing Using Transact-SQL Cursors

Using a CURSOR is not normally the best way to process through a set of records. Yet when a seasoned programmer moves to writing TSQL for the first time they frequently look for ways to process a sets of records one row at a time. They do this because they are not used to thinking about processing records as a set. In order to process through a TSQL record set a row at a time you can use a cursor. A cursor is a record set that is defined with the DECLARE CURSOR statement. Cursors can be defined as either read-only or updatable. In this article I will introduce you to using cursors to do record level processing one row at a time.   Read more...
By Gregory Larsen 2015/05/06 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,704 reads

Stairway to Columnstore Indexes Level 2: Columnstore Storage

To fully appreciate just how different columnstore indexes are, and why work so well in reporting and online analytical processing (OLAP) workloads, but not for online transaction processing (OLTP), we must first look at the traditional “rowstore” indexes.  Read more...
By Hugo Kornelis 2015/04/29 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,670 reads

Stairway to SQL PowerShell Level 9: Objects For Everyone

This level will show how to create objects including a login, a database, a filegroup, a file a database user and then we’ll end with a table and an index.  Read more...
By Ben Miller 2015/04/22 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,858 reads

Stairway to SQL Server Security Level 8: Data Encryption

This stairway level will explore data protection through encryption, both when the data is in motion across the network or in memory and at rest in a table. You’ll learn about the encryption key hierarchy and the various kinds of keys you can use to encrypt data, as well as how you can manage the keys or let SQL Server do it for you.  Read more...
By Don Kiely 2015/04/15 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,020 reads

Stairway to SQL Server Security Level 7: Security Across Databases with Cross-Database Ownership Chaining

Sometimes you need to reach outside a database and access data and objects from multiple databases, which raises some security issues and increases the complexity of data access. In this stairway level, you’ll learn about cross-database ownership chaining so that you can reach across database boundaries securely.  Read more...
By Don Kiely 2015/04/08 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,749 reads

Stairway to SQL PowerShell Level 1: SQL PowerShell Basics

What are PowerShell and SQL PowerShell and how do you use them? Level 1 of this Stairway will help you answer these questions, and start to show you why you might want to use this great tool.  Read more...
By Ben Miller 2015/03/20 (first published: 2012/08/08) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 48,204 reads

Stairway to Advanced T-SQL Level 3: Understanding Common Table Expressions (CTEs)

A CTE is a temporary result set defined by a simple query, and is used within the execution scope of a single INSERT, UPDATE, DELETE, or SELECT statement. In this article we will explore how to define and use CTE's.  Read more...
By 2015/03/18 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 13,528 reads
<< Newer    Items 41 to 60 of 331    Older >>
 
Tags
integration services (ssis) (23)    
t-sql (22)    
indexing (16)    
mdx (15)    
database design (13)    
powershell (13)    
sql trace (12)    
dax (11)    
replication (11)    
reporting services (ssrs) (11)    
sql server agent (11)    
xml (11)    
transaction log (10)    
advanced t-sql (9)    
columnstore index (9)    
powerpivot (9)    
sqlclr (9)    
data (8)    
pivottable (8)    
power bi (8)    
productx (8)    
security (6)    
source control (6)    
biml (5)    
streaminsight (5)    
extended events (4)    
sql dialects (4)    
virtualization (4)    
alwayson (3)    
complex event processing (3)    
ssas (3)    
continuous integration (2)    
cross join (2)    
dml (2)    
etl (2)    
failover clustered instance (fci) (2)    
insert (2)    
logging (2)    
math (2)    
server security (2)    
smo (2)    
sql agent (2)    
test automation (2)    
test driven development (tdd) (2)    
u-sql (2)    
.currentmember (1)    
.nextmember (1)    
.prevmember (1)    
administration (1)    
agent jobs (1)    
algorithmic trading (1)    
apply (1)    
auditing (1)    
authentication (1)    
azure (1)    
bi (1)    
big data (1)    
books (1)    
bulk logged (1)    
business intelligence (1)    
case expression (1)    
catalog views (1)    
centralized repository (1)    
ci (1)    
closingperiod() (1)    
cluster (1)    
clustered index (1)    
code signing (1)    
common table expressions (cte) (1)    
continuous delivery (1)    
correlated subqueries (1)    
count() (1)    
countx() (1)    
cross-database ownership chaining (1)    
cube (1)    
cursors (1)    
data encryption (1)    
data lake (1)    
date (1)    
delete rows (1)    
derivative shortcut functions (1)    
diagnostics (1)    
distributed repository (1)    
dvcs (1)    
dynamic t-sql code (1)    
event driven architecture (1)    
event stream processing (1)    
excel (1)    
execution context (1)    
format_string (1)    
functions (1)    
grouping sets (1)    
head() (1)    
high availability (1)    
history (1)    
hyper-v (1)    
iif (transact-sql) (1)    
join (1)    
lastperiods() (1)    
log growth (1)    
log throughput (1)    
maintenance (1)    
max() (1)    
maxx() (1)    
mdx time/date series functions (1)    
merge (1)    
monitoring (1)    
mysql (1)    
nonclustered index (1)    
objects (1)    
openingperiod() (1)    
optimization (1)    
order by (1)    
ordering (1)    
parallelperiod() (1)    
periodstodate() (1)    
permissions (1)    
pivot (1)    
power pivot (1)    
ranking functions (1)    
relational (1)    
rollup (1)    
row-level security (rls) (1)    
schemas (1)    
select (1)    
server monitoring (1)    
server side trace (1)    
set functions (1)    
sql server 2008 r2 (1)    
sql server security (1)    
subqueries (1)    
sum() (1)    
sumx() (1)    
svn (1)    
tail() function (1)    
temp tables (1)    
test-driven development (1)    
time (1)    
t-log (1)    
top (1)    
transparent data encryption (tde) (1)    
twitter (1)    
unpivot (1)    
update (1)    
upgrading (1)    
views (1)    
wsfc (1)