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

Content with tag Stairway Series Rss

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

Stairway to ColumnStore Indexes Level 7: Optimizing Nonclustered Columnstore Indexes

In this level, we will focus on optimization techniques to apply while building the nonclustered columnstore index, which is available in all versions of SQL Server from 2012 up.  Read more...
By Hugo Kornelis 2016/03/16 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,465 reads

Stairway to AlwaysOn Level 8: Segregate Mirror Traffic in AlwaysOn

this article details how to segregate the mirror traffic in an AlwaysOn group configuration  Read more...
By Perry Whittle 2016/03/09 | Source: SQLServerCentral.com | Category: alwayson
Rating: (not yet rated) |  Discuss |   Briefcase | 1,267 reads

Stairway to SQLCLR Level 8: Using Visual Studio to work around SSDT

In the final installment of this three-Level series, we use another automation-related feature to do what SSDT doesn't handle natively.  Read more...
By Solomon Rutzky 2016/03/03 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 1,895 reads

Stairway to SQLCLR Level 7: Development and Security

Learn about some Visual Studio features that help with automation, and use them to create an Asymmetric Key and Login.  Read more...
By Solomon Rutzky 2016/03/02 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 893 reads

Stairway to SQLCLR Level 6: Development Tools Intro

This time we look at the commonly used tools for doing SQLCLR development: Visual Studio (VS), SQL Server Data Tools (SSDT), and SQL Server Express LocalDB (LocalDB).  Read more...
By Solomon Rutzky 2016/03/01 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 1,683 reads

Stairway to Advanced T-SQL Level 1: Intro to Advanced T-SQL Using a CROSS JOIN

The first installment of this new stairway series will be discuss the CROSS JOIN operator. This stairway should help readers prepare for passing the Microsoft Certification exam 70-461: Querying Microsoft SQL Server 2012.  Read more...
By Gregory Larsen 2016/02/19 (first published: 2014/12/17) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 20,680 reads

Stairway to Database Source Control Level 4: Getting a Database into Source Control (Distributed Repository)

Now that we have our database under source control, we will want to share our work with other developers. If we are in a centralized source control system, our changes may be committed straight into the central repository. When we are working in a distributed system, it means pulling down any changes from other developers, addressing any areas of conflict, and pushing our changes up to allow others to benefit from our work. This allows our changes to be synchronized with the changes other developers have made. This level is principally about setting up a distributed source control system, namely Git, and how to commit database development changes to a local repository, before pushing them into a remote 'central' repository for sharing with other developers. The next level will delve a little deeper into Git's versioning mechanisms, and show some examples of how to share database changes during development, and how to deal with conflicting changes.  Read more...
By Dave Green 2016/02/03 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,012 reads

Stairway to Columnstore Indexes Level 6: Updating and Deleting Data in a Columnstore Index

This level looks in detail at what happens when we update or delete data from a clustered columnstore index, the impact it has on concurrent data access, and how without careful maintenance the efficiency of columnstore indexes can degrade over time.  Read more...
By Hugo Kornelis 2016/01/20 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,526 reads

Stairway to SQL Server Extended Events Level 2: Creating Basic Event Sessions in the UI

In this Level, we'll walk through the basics of using the New Session dialog in the UI to create a new event session, define its events, actions and predicates, and establish a target for the session in which to collect the event data.  Read more...
By Erin Stellato 2016/01/13 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,997 reads

Stairway to T-SQL: Beyond The Basics Level 2: Writing Subqueries

In this level of the Beyond the T-SQL Basics stairway, we will be discussing the different aspects of a subquery.  Read more...
By Gregory Larsen 2016/01/01 (first published: 2014/01/29) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 18,099 reads

Stairway to SQL Server Extended Events Level 1: From SQL Trace to Extended Events

Over the course of this stairway series, we're going to explore in detail the use of Extended Events as a diagnostic data collection tool, to track down causes of poor performance in SQL Server. This first level will start from a point known and familiar to many DBAs, namely the use of SQL Trace to track down and investigate long-running queries.  Read more...
By Erin Stellato 2015/12/23 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,746 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 2015/12/16 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,715 reads

Stairway to SQL PowerShell Level 10: Getting data in and out of SQL Server using SQL Server PowerShell

In this level we will look at ways of getting data into and out of SQL Server. We will specifically look at the Database object and a cmdlet Invoke-Sqlcmd or Invoke-SqlCmd2. To get data in, we are going to leverage a PowerShell script that uses SMO to put data into a predefined table in SQL Server.  Read more...
By Ben Miller 2015/12/02 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,336 reads

Stairway to SQL Server Extended Events

Erin Stellato, a Principal Consultant with SQLskills.com, explores the use of Extended Events as a diagnostic data collection tool or SQL Server. She describes how to define efficient low-overhead event sessions that exploit fully the vast number of events, as well as the powerful filtering and data collection options, offered by this new event collection infrastructure. She also demonstrates simple techniques to analyze event data and identify and troubleshoot the causes of poor SQL Server performance, such as long-running queries that consume vast amounts of CPU and I/O resources. It is time to embrace Extended Events and understand all that it has to offer, and Erin's stairway is the perfect place to start.  Read more...

Stairway to SQLCLR Level 1: What is SQLCLR?

The first step to using the SQLCLR begins with this overview of what is possible and what is not. Start your journey to decide if this is a tool you can use inside your SQL Server instance.  Read more...
By Solomon Rutzky 2015/11/27 (first published: 2014/01/09) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 17,472 reads

Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values

When you build applications that store data in SQL Server you will most likely have to store dates and times, and you’ll call functions to do date manipulations. It is important to understand the different date and time data types, and when to use one data type over another. In this level I will be exploring the different date and time data types and discussing when each type is appropriate.  Read more...
By Gregory Larsen 2015/11/25 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,818 reads

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,840 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,295 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,531 reads
<< Newer    Items 21 to 40 of 340    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)    
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)    
u-sql (4)    
virtualization (4)    
alwayson (3)    
azure (3)    
big data (3)    
complex event processing (3)    
data lake (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)    
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)    
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)    
visual studio (1)    
wsfc (1)