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

Content with tag Stairway Series Rss

   Items 1 to 20 of 383    Older >>
 

Deeper into Nonclustered Indexes: Stairway to SQL Server Indexes Level 2

By this stage, you should be familiar with the basics of SQL Server indexes. We've discussed what an Index actually is, as well as some of the most common types you're likely to encounter. Now that we've seen some simple examples of how Indexes can be useful, we're going to delve deeper into nonclustered indexes, as we'll see how they can improve the performance of more complex queries.  Read more...
By David Durant 2017/10/18 (first published: 2014/11/26) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 28,178 reads

Stairway to SQL Server Agent - Level 2: Job Steps and Subsystems

SQL Server Agent jobs are made up of a series of one or more Job Steps. A job step is assigned to a specific job subsystem, which identifies the kind of work the job step is going to perform. Each job step runs in a separate security context, although each job also has an owner that determines who can modify the job.  Read more...
By Richard Waymire 2017/10/11 (first published: 2011/02/17) | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 7,890 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 2017/09/27 (first published: 2015/11/25) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,087 reads

Stairway to U-SQL Level 17: Executing U-SQL Jobs with PowerShell

Automate your Data Lake with PowerShell! Learn how PowerShell can be used to execute U-SQL scripts, as well as a few other little tricks.  Read more...
By Mike McQuillan 2017/09/20 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 448 reads

Moving Dynamic Data Masked Data to New Locations

In this level of the Stairway to Dynamic Data Masking we examine how masking affects data movement.  Read more...
By Steve Jones 2017/09/13 | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: |  Discuss |   Briefcase | 369 reads

Using SQL Server Dynamic Online Catalog to Explore Keys and Relationships: Stairway to Exploring Database Metadata Level 4

This level introduces keys, constraints, and relationships.  Read more...
By Phil Factor 2017/09/06 (first published: 2016/10/19) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,568 reads

Stairway to U-SQL Level 16: The Azure Data Lake Catalog

Delve behind the scenes and learn about the catalog used to manage Azure Data Lakes.  Read more...
By Mike McQuillan 2017/08/30 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 516 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 2017/08/23 (first published: 2015/12/23) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,633 reads

Stairway to SQL Server Automated Database Testing Level 1: Why You Need TDD

The first article in this Stairway Series makes the case for test-driven development.  Read more...
By Sebastian Meine 2017/08/16 (first published: 2014/12/31) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,590 reads

Stairway to AlwaysOn Level 2: Storage 101

In this new level of the stairway, we examine the storage knowledge you need for an AlwaysOn configuration.  Read more...
By Perry Whittle 2017/08/09 (first published: 2014/10/01) | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 7,194 reads

Stairway to T-SQL DML Level 3: Implementing a Relational Model in SQL Server

This level of the stairway details the creation of a relational database, as well as filling in some of the history of the relational database model.  Read more...
By Gregory Larsen 2017/08/02 (first published: 2011/11/09) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 13,300 reads

Stairway to Advanced T-SQL Level 8: Functions to Generate Date and Time values

When you build applications that store records in SQL Server you will most likely have to store date and time values as part of the data. To manage all the different date related tasks you might need to perform Microsoft has introduced a number of date functions. In this stairway I will be exploring those date and time functions.  Read more...
By Gregory Larsen 2017/07/19 (first published: 2015/10/21) | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,485 reads

Stairway to Advanced T-SQL Level 7: Ordering Your Data Using Ranking Functions

In SQL Server there are 4 different ranking functions: RANK, DENSE_RANK, NTILE, and ROW_NUMBER. These ranking functions were introduced in SQL Server 2005. In this stairway level I will be reviewing each of these different ranking functions, and will show you how to use them by providing a few examples.  Read more...
By Gregory Larsen 2017/07/14 (first published: 2015/09/02) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,880 reads

Stairway to DAX and Power BI - Level 8: The DAX COUNT() and COUNTX() Functions

As a part of his “Function / Iterator Pairs” mini-series, Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX COUNT() and COUNTX() functions, discussing similarities and differences. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating counts to meet differing needs within our PowerPivot model designs.  Read more...
By Bill Pearson 2017/07/12 (first published: 2015/01/07) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,004 reads

Stairway to U-SQL Level 15: U-SQL Global Scalar Functions With C#

In this article, see how to created shared functions using C# assemblies in U-SQL.  Read more...
By Mike McQuillan 2017/06/14 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 460 reads

Stairway to Columnstore Indexes Level 13: Improvements in SQL Server 2016

This stairway series was started in 2015. As such, the focus was on SQL Server 2012 and SQL Server 2014 only. When SQL Server 2016 was released, with lots of improvements in the columnstore technology, I decided to finish the planned levels with the original focus on SQL Server 2012 and 2014, and add one extra level with a brief overview of the improvements available in SQL Server 2016.  Read more...
By Hugo Kornelis 2017/06/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,060 reads

Stairway to U-SQL Level 14: Local U-SQL Scalar Functions with C#

Learn how U-SQL leverages C# to support flexible scalar functions in your scripts.  Read more...
By Mike McQuillan 2017/05/31 | Source: SQLServerCentral.com | Category: u-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 562 reads

Stairway to Columnstore Indexes Level 12: Clustered or Nonclustered?

The previous levels of this stairway describe details, features, and limitations of columnstore indexes in SQL Server. But they do not answer what should be the first question for every database professional: should columnstore indexes be used in my databases; on what tables should they be used; and should they be clustered or nonclustered columnstore indexes?  Read more...
By Hugo Kornelis 2017/05/24 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 878 reads

Stairway to DAX and Power BI - Level 7: Function / Iterator Function Pairs: The DAX AVERAGE() and AVERAGEX() Functions

Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson explores the DAX AVERAGE() and AVERAGEX() functions, comparing and contrasting the two. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating arithmetic means within our PowerPivot model designs.  Read more...
By Bill Pearson 2017/05/03 (first published: 2014/09/17) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,120 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 2017/04/21 (first published: 2015/04/29) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,078 reads
   Items 1 to 20 of 383    Older >>
 
Tags
integration services (ssis) (23)    
t-sql (22)    
indexing (16)    
mdx (15)    
columnstore index (14)    
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)    
powerpivot (9)    
sqlclr (9)    
u-sql (9)    
azure (8)    
data (8)    
pivottable (8)    
power bi (8)    
productx (8)    
metadata (7)    
big data (6)    
biml (6)    
data lake (6)    
security (6)    
source control (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)    
ssas (3)    
azure data lake (2)    
c# (2)    
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)    
optimization (2)    
scalar functions (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)    
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)    
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 (ha) (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)    
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)    
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)