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

Content with tag Stairway Series Rss

   Items 1 to 20 of 348    Older >>
 

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 2016/09/23 (first published: 2015/05/27) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 9,715 reads

Stairway to Exploring Database Metadata Level 2: Using the Dynamic Online Catalog to Solve Problems

In this second level of the Stairway, Phil looks at where we go to find information about objects, using triggers as the example.  Read more...
By Phil Factor 2016/09/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 949 reads

Stairway to Columnstore Indexes Level 9: Batch Mode Execution

In this level, Hugo explains what batch mode execution is, how it differs from row mode execution, and what its limitations are.  Read more...
By Hugo Kornelis 2016/08/31 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 706 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 2016/08/17 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 886 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,383 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,525 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 | 363 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,515 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,092 reads

Stairway to Exploring Database Metadata

In addition to the data that our clients and customers store in a database, there is a tremendous amount of meta data, "data about data", that describes how the database is set up, configured, and what the properties are for the various objects. This stairway aims to demystify and explain how you can query and use this meta data to more effectively manage your SQL Server Databases.  Read more...

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 | 559 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,062 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 | 999 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,638 reads

Stairway to DLM Dashboard

This stairway is designed to showcase the capabilities and value of DLM Dashboard, as well as teach you how to setup and use this free tool in your environment.  Read more...

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,252 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 | 713 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 | 4,097 reads

Stairway to U-SQL

As Microsoft continues to expand the Azure platform, they have enhanced its ability in ways that are quite different from what we've come to expect from SQL Server. Learn about the new language from Microsoft, U-SQL, designed to work with Data Lakes and Big Data in Azure.  Read more...

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,862 reads
   Items 1 to 20 of 348    Older >>
 
Tags
integration services (ssis) (23)    
t-sql (22)    
indexing (16)    
mdx (15)    
powershell (14)    
database design (13)    
sql trace (12)    
dax (11)    
replication (11)    
reporting services (ssrs) (11)    
sql server agent (11)    
xml (11)    
columnstore index (10)    
transaction log (10)    
advanced t-sql (9)    
powerpivot (9)    
sqlclr (9)    
data (8)    
pivottable (8)    
power bi (8)    
productx (8)    
security (6)    
source control (6)    
biml (5)    
extended events (5)    
streaminsight (5)    
u-sql (5)    
azure (4)    
big data (4)    
data lake (4)    
sql dialects (4)    
virtualization (4)    
alwayson (3)    
complex event processing (3)    
metadata (3)    
smo (3)    
ssas (3)    
continuous integration (ci) (2)    
cross join (2)    
dlm dashboard (2)    
dml (2)    
etl (2)    
failover clustered instance (fci) (2)    
insert (2)    
logging (2)    
math (2)    
schemas (2)    
server security (2)    
sql agent (2)    
test automation (2)    
test driven development (tdd) (2)    
.currentmember (1)    
.nextmember (1)    
.prevmember (1)    
administration (1)    
agent jobs (1)    
algorithmic trading (1)    
apply (1)    
auditing (1)    
authentication (1)    
bi (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)    
date (1)    
delete rows (1)    
derivative shortcut functions (1)    
diagnostics (1)    
distributed repository (1)    
dvcs (1)    
dynamic data masking (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)    
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)    
visual studio (1)    
wsfc (1)