SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Stairway Series Rss

   Items 1 to 20 of 420    Older >>
 

Creating a Logical SQL Server: Level 2 of the Stairway to Azure SQL Database

In this second level of the Stairway to Azure SQL Database, we cover the basics of building a logical server using the portal and PowerShell.  Read more...
By Arun Sirpal 2018/07/18 | Source: SQLServerCentral.com | Category: azure sql database
Rating: (not yet rated) |  Discuss |   Briefcase | 308 reads

Stairway to SSAS Tabular Level 1: Why use Analysis Services

In this first level of the SSAS Tabular stairway, learn the benefits of implementing an SSAS solution.  Read more...
By Thomas LeBlanc 2018/07/11 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 833 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 2018/07/04 (first published: 2016/08/31) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,544 reads

Exploring SQL Server Indexes: Stairway to Exploring Database Metadata Level 3

This level of the Stairway to Exploring Database Metadata focuses on indexes and all the information you can gather about them.  Read more...
By Phil Factor 2018/06/27 (first published: 2016/09/28) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,280 reads

Stairway to SSAS Tabular

SSAS (SQL Server Analysis Services) is available in two modes, tabular and multidimensional. The new tabular model is easier for those companies who are not already invested in the traditional, multidimensional model. In this stairway, Thomas LeBlanc will teach you how to create tabular models used for reports and dashboards.   Read more...

Getting Started with Level 1 of the Stairway to Azure SQL Database

In this first level, learn how to get started with Azure and Azure SQL Database.  Read more...
By Arun Sirpal 2018/06/13 | Source: SQLServerCentral.com | Category: azure sql database
Rating: |  Discuss |   Briefcase | 916 reads

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 2018/06/06 (first published: 2016/03/16) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,535 reads

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

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 2018/05/30 (first published: 2016/09/07) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,928 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 2018/05/30 (first published: 2016/05/11) | Source: SQLServerCentral.com | Category: smo
Rating: |  Discuss |   Briefcase | 3,477 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 2018/05/23 (first published: 2016/01/20) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,363 reads

What is the Machine Learning Server? Level 2 of the Stairway to ML Services

In Level 2, we look at the architecture and structure of the Machine Learning Services server process.  Read more...
Rating: |  Discuss |   Briefcase | 882 reads

SQL Server Dynamic Online Catalog: Why Should You Care? Stairway to Exploring Database Metadata Level 1

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 2018/05/09 (first published: 2016/08/03) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,175 reads

Installing Machine Learning Services – Level 1 of the Stairway to ML Services

This first installment of the Stairway to Machine Learning Services explains the installation process for this subsystem in SQL Server.  Read more...
Rating: |  Discuss |   Briefcase | 1,125 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 2018/04/25 (first published: 2015/12/02) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,803 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/04/18 (first published: 2015/11/04) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,781 reads

Row-Level Security Predicate Functions - Level 2 of the Stairway to Row Level Security

In this level, we dive deeper into predicates and the various ways to structure them in an RLS environment.  Read more...
By Steve Jones 2018/04/11 | Source: SQLServerCentral.com | Category: row-level security (rls)
Rating: |  Discuss |   Briefcase | 762 reads

Stairway to Biml Level 4: Using Biml as an SSIS Design Patterns Engine

In this level, we make a large leap forward, showing you how to use BIML to script a large number of packages using C#.  Read more...
By Andy Leonard 2018/04/04 (first published: 2013/08/14) | Source: SQLServerCentral.com | Category: biml
Rating: |  Discuss |   Briefcase | 13,063 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 2018/03/21 (first published: 2015/03/18) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 16,039 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 2018/02/28 (first published: 2015/06/10) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,301 reads
   Items 1 to 20 of 420    Older >>
 
Tags
integration services (ssis) (23)    
t-sql (22)    
indexing (16)    
mdx (15)    
columnstore index (14)    
powershell (14)    
database design (13)    
dax (12)    
sql trace (12)    
replication (11)    
reporting services (ssrs) (11)    
sql server agent (11)    
xml (11)    
powerpivot (10)    
transaction log (10)    
advanced t-sql (9)    
power bi (9)    
sqlclr (9)    
u-sql (9)    
azure (8)    
data (8)    
pivottable (8)    
productx (8)    
security (8)    
metadata (7)    
big data (6)    
biml (6)    
data lake (6)    
source control (6)    
ssas (6)    
extended events (xe) (5)    
streaminsight (5)    
smo (4)    
sql dialects (4)    
virtualization (4)    
always on (3)    
complex event processing (3)    
dynamic data masking (3)    
row-level security (rls) (3)    
azure data lake (2)    
azure sql database (2)    
c# (2)    
continuous integration (ci) (2)    
cross join (2)    
dlm dashboard (2)    
dml (2)    
etl (extract, transform, and load) (2)    
failover clustered instance (fci) (2)    
insert (2)    
logging (2)    
machine learning services (mls) (2)    
math (2)    
optimization (2)    
scalar functions (2)    
schemas (2)    
server security (2)    
sql agent (2)    
sumx() (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)    
batch mode (1)    
bi (1)    
books (1)    
bulk logged (1)    
business intelligence (1)    
case expression (1)    
catalog (1)    
catalog views (1)    
centralized repository (1)    
ci (1)    
closingperiod() (1)    
cloud (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)    
ddl (1)    
delete rows (1)    
derivative shortcut functions (1)    
desktop (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)    
filter (1)    
format_string (1)    
functions (1)    
grouping sets (1)    
head() (1)    
high availability (ha) (1)    
history (1)    
hyper-v (1)    
iif (transact-sql) (1)    
join (1)    
lastperiods() (1)    
log growth (1)    
log throughput (1)    
maintenance (1)    
matrix (1)    
max() (1)    
maxx() (1)    
mdx time/date series functions (1)    
merge (1)    
metdata (1)    
monitoring (1)    
mysql (1)    
nonclustered index (1)    
objects (1)    
openingperiod() (1)    
order by (1)    
ordering (1)    
parallelperiod() (1)    
periodstodate() (1)    
permissions (1)    
pivot (1)    
power pivot (1)    
ranking functions (1)    
relational (1)    
report (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)    
sum() (1)    
svn (1)    
tabular (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)