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

Content with tag Stairway Series Rss

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

Stairway to SQL Server Extended Events Level 3: Working with the Extended Events UI

In the next installment of our stairway to Extended Events, we delve into the Live Data and Target Data Viewers.  Read more...
By Erin Stellato 2017/12/27 (first published: 2016/05/25) | Source: SQLServerCentral.com | Category: extended events (xe)
Rating: |  Discuss |   Briefcase | 2,279 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 2017/12/20 (first published: 2016/01/13) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,380 reads

Stairway to SQL Server Agent - Level 3: Agent Alerts and Operators

How to be notified when a job succeeds or fails, or be notified when a SQL Server performance condition is met.  Read more...
By Richard Waymire 2017/12/13 (first published: 2011/06/29) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,632 reads

Stairway to SQL PowerShell Level 4: Objects in SQL PowerShell

This far, we have learned about installation and setup of the PowerShell environment. You should now have a foundation of SQL Server PowerShell. We now are ready to learn about Objects in SQL PowerShell.  Read more...
By Ben Miller 2017/12/06 (first published: 2012/10/22) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,965 reads

Stairway to MDX - Level 3: The Order() Function

The Order() function provides the 'hierarchized' sorts you need for reports and applications using MDX. In this Step, Business Intelligence Architect Bill Pearson explores using the versatile Order() function for providing dataset sorts that respect dimensional hierarchies.  Read more...
By Bill Pearson 2017/11/22 (first published: 2011/05/25) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,042 reads

Stairway to MDX - Level 2: The Ordinal Function

Business Intelligence Architect Bill Pearson introduces the MDX Ordinal Function, as a means for generating lists and for conditionally presenting calculations. He also demonstrates the use of the function in creating datasets to support report parameter picklists.  Read more...
By Bill Pearson 2017/11/15 (first published: 2011/02/17) | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 16,931 reads

Stairway to Row-Level Security

This series looks at row based access control in SQL Server 2016+ as implemented in the Row-Level Security feature.  Read more...

Stairway to Database Design Level 5: Procedures

Joe Celko tackles the subject of the Stored Procedure and its place in database design. What he writes is food for thought, even for experienced database developers.  Read more...
By Joe Celko 2017/10/25 (first published: 2010/08/25) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 14,235 reads

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,584 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 | 8,054 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,475 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 | 538 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 | 394 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,624 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 | 617 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 | 7,032 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,690 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,435 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,526 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,648 reads
<< Newer    Items 21 to 40 of 410    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)    
extended events (xe) (5)    
streaminsight (5)    
smo (4)    
sql dialects (4)    
ssas (4)    
virtualization (4)    
always on (3)    
complex event processing (3)    
dynamic data masking (3)    
row-level security (rls) (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)    
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)