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

Content with tag Stairway Series Rss

   Items 1 to 20 of 447    Older >>
 

Pages and Extents: Stairway to SQL Server Indexes Level 4

We've now seen how indexed and non-indexed tables perform in queries, and established "logical reads" as the metric for query performance. Now it is time to explain why logical reads are an excellent metric and also explain what is actually being read.   Read more...
By David Durant 2019/01/16 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 13,385 reads

Stairway to DAX and Power BI - Level 9: Function / Iterator Function Pairs: The DAX MAX() and MAXX() Functions

As a part of his "Function / Iterator Pairs" mini-series, Business Intelligence architect, Analysis Services Maestro, SQL Server MVP, and author Bill Pearson introduces the DAX MAX() and MAXX() 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 "largest numeric values" to meet differing needs within our PowerPivot model designs.  Read more...
By Bill Pearson 2019/01/09 (first published: 2015/01/14) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,843 reads

Stairway to MDX - Level 15: Basic Set Functions: The Tail() Function

Return, in order, a specified number of elements from the end of a set. SSAS Maestro, SQL Server MVP and Business Intelligence Architect Bill Pearson introduces the MDX Tail() function.  Read more...
By Bill Pearson 2018/12/26 (first published: 2015/09/30) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,461 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/12/19 (first published: 2015/11/04) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,228 reads

Stairway to SQL Server Security Level 11: Auditing

By defining server- and database-level audits, you can record just about any kind of event that occurs in SQL Server, which can be an invaluable source of security troubleshooting and forensic information when security breaches occur. In this stairway level you’ll learn how to define the various audit specification objects, how to capture audit data, and how to explore and use the data.  Read more...
By Don Kiely 2018/12/12 (first published: 2015/09/23) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,549 reads

Adding Disks - Level 3 of the Stairway to SQL Server on Linux

In this level we examine how to add disks to separate our data, log, and tempdb files.  Read more...
By Danilo Dominici 2018/12/05 | Source: SQLServerCentral.com | Category: sql server on linux
Rating: |  Discuss |   Briefcase | 245 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 2018/11/28 (first published: 2016/08/17) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,808 reads

Permissions and Security in Dynamic Data Masking

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 2018/11/16 (first published: 2016/06/29) | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: |  Discuss |   Briefcase | 1,219 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 2018/11/14 (first published: 2015/12/16) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,617 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 2018/11/07 (first published: 2017/06/07) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,789 reads

The Configured Data Masks for Dynamic Data Masking

Continuing with his look at Dynamic Data Masking, Steve Jones looks at the masking patterns available besides the default mask.  Read more...
By Steve Jones 2018/11/02 (first published: 2016/04/06) | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: |  Discuss |   Briefcase | 1,793 reads

What is ADF? Level 1 of the Stairway to Azure Data Factory

Azure Data Factory is a new way of moving data around, and this first level gives you a good overview of what the service can do.  Read more...
By Andy Leonard 2018/10/31 | Source: SQLServerCentral.com | Category: azure data factory
Rating: |  Discuss |   Briefcase | 779 reads

Basic Administration Tasks - Level 5 of the Stairway to for Azure SQL Database

In this next level, learn how to accomplish a few simple administration tasks that may help you manage your Azure SQL Database.  Read more...
By Arun Sirpal 2018/10/24 | Source: SQLServerCentral.com | Category: azure sql database
Rating: |  Discuss |   Briefcase | 468 reads

Installing the Database Server - Level 2 of the Stairway to SQL Server on Linux

In this next level, we learn how to install SQL Server on Linux and verify that everything is working.  Read more...
By Danilo Dominici 2018/10/17 | Source: SQLServerCentral.com | Category: sql server on linux
Rating: (not yet rated) |  Discuss |   Briefcase | 331 reads

Stairway to Biml 9 – Refactoring a Simple Custom Biml Framework

This level of the Stairway to Biml examines how to refactor your Biml into an easier to maintain format.  Read more...
By Andy Leonard 2018/10/10 | Source: SQLServerCentral.com | Category: biml
Rating: (not yet rated) |  Discuss |   Briefcase | 333 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 2018/10/03 (first published: 2017/05/24) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,546 reads

Connecting - Level 4 of the Stairway to Azure SQL Database

Learn how to configure connectivity and firewall rules for your Azure SQL Database  Read more...
By Arun Sirpal 2018/09/26 | Source: SQLServerCentral.com | Category: azure sql database
Rating: |  Discuss |   Briefcase | 404 reads

Stairway to Biml Level 8 – Using the Relational Database Metadata to Build Packages

In this next level of the Stairway to Biml, we will examine how you can use the information stored in your RDBMS to build packages.  Read more...
By Andy Leonard 2018/09/19 | Source: SQLServerCentral.com | Category: biml
Rating: |  Discuss |   Briefcase | 469 reads

Stairway to SSAS Tabular Level 4: Implementing Date Dimensions

In this first level of the SSAS Tabular stairway, learn how to implement and format a date dimension.  Read more...
By Thomas LeBlanc 2018/09/12 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 567 reads

Stairway to Columnstore Indexes Level 11: Optimizing Queries For Batch Mode (Part 2)

Hugo Kornelis continues his exploration of the types of queries that can end up running in row mode when accessing columnstore indexes. He demonstrates how careful rewriting can often yield a logically equivalent query that runs in batch mode instead, and therefore gains the best possible performance benefit.  Read more...
By Hugo Kornelis 2018/09/05 (first published: 2017/01/04) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,364 reads
   Items 1 to 20 of 447    Older >>
 
Tags
integration services (ssis) (25)    
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)    
biml (9)    
power bi (9)    
sqlclr (9)    
u-sql (9)    
azure (8)    
data (8)    
pivottable (8)    
productx (8)    
security (8)    
metadata (7)    
big data (6)    
data lake (6)    
source control (6)    
ssas (6)    
azure sql database (5)    
extended events (xe) (5)    
streaminsight (5)    
smo (4)    
sql dialects (4)    
sql server on linux (4)    
virtualization (4)    
always on (3)    
complex event processing (3)    
dynamic data masking (3)    
row-level security (rls) (3)    
administration (2)    
azure data lake (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)    
ssas - cubes with huge dimensions (2)    
sumx() (2)    
test automation (2)    
test driven development (tdd) (2)    
.currentmember (1)    
.nextmember (1)    
.prevmember (1)    
agent jobs (1)    
algorithmic trading (1)    
apply (1)    
auditing (1)    
authentication (1)    
azure data factory (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)    
linux (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)    
temporary tables (1)    
test-driven development (1)    
time (1)    
t-log (1)    
top (1)    
transparent data encryption (tde) (1)    
twitter (1)    
ubuntu (1)    
unpivot (1)    
update (1)    
upgrading (1)    
views (1)    
visual studio (1)    
wsfc (1)