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

Content with tag SQL Server 2016 Rss

   Items 1 to 20 of 171    Older >>

TEMPDB Enhancements in SQL Server 2016

TEMPDB Enhancements in SQL Server 2016 - By default enforced to follow best practices.  Read more...
By Dharmendra Keshari 2018/03/16 (first published: 2016/04/13) | Source: SQLServerCentral.com | Category: tempdb
Rating: |  Discuss |   Briefcase | 6,444 reads

JSON in SQL Server 2016

By Evgeny Garaev 2018/03/13 | Category: sql server 2016
Rating: (not yet rated) |  Discuss |   Briefcase | 868 reads

Performance Comparison Between SQL Server 2014 and 2016

This article outlines the performance innovations in SQL Server 2016 for Columnstore Index and BatchMode Execution.  Read more...
By Savaram Ravindra 2018/02/22 | Source: SQLServerCentral.com | Category: columnstore index
Rating: |  Discuss |   Briefcase | 1,436 reads

An Easier Way of Pivoting Data in SQL Server

There are several methods to pivot, or transpose, data in T-SQL, but most are difficult to understand and write. Phil Factor demonstrates how to take advantage of JSON support, introduced with SQL Server 2016, to create a function that makes pivoting data simple.  Read more...
By 2018/02/16 | Source: SimpleTalk | Category: pivoting
Rating:  Rate this |   Briefcase | 5,916 reads

Creation of a temporal table

By Evgeny Garaev 2018/02/15 | Category: sql server 2016
Rating: (not yet rated) |  Discuss |   Briefcase | 821 reads

How to Implement Dynamic Data Masking in Azure SQL Database and SQL Server

Anoop Kumar shows you the SQL Commands (T-SQL) to secure PII/PHI data using the SQL Server Dynamic Data Masking (DDM) feature and explores DDM's built in functions to mask all critical data elements. DDM restricts unauthorized users from accessing critical data with no changes in the application.  Read more...
By Additional Articles 2018/02/12 | Source: Database Journal | Category: dynamic data masking
Rating: (not yet rated)  Rate this |   Briefcase | 2,697 reads

Store JSON data in SQL Server 2016

By Evgeny Garaev 2018/01/29 | Category: json
Rating: (not yet rated) |  Discuss |   Briefcase | 802 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free ebook Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications than you ever thought possible.  Read more...
By Additional Articles 2018/01/09 | Source: SimpleTalk | Category: in-memory oltp
Rating:  Rate this |   Briefcase | 4,297 reads

Live Query Plans and Blocking

Erik Darling looks at how SQL Server 2016's live query plans react when they're blocked.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,967 reads

Extracting a DAX Query Plan With Analysis Services 2016 Extended Events

In this post, Koen Verbeeck shows how to use SQL Sever 2016's Extended Events to find the query plan for a DAX query, just like you would for a T-SQL statement.  Read more...
By Additional Articles 2017/10/27 | Source: MSSQLTips.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 2,825 reads

SQL Server R Services: Working with ggplot2 Statistical Graphics

It is when you use R in SQL Server with one of the huge range of packages that comes with it that you can begin to appreciate the power of the system. With a package such as ggplot there are many 'knobs one can twiddle' in order to get spectacular and informative visualisations. Rob Sheldon continues his beginners series for R in SQL Server by showing how to refine the output to get it as you need it.  Read more...
By Additional Articles 2017/10/25 | Source: SimpleTalk | Category: sql server r services
Rating: (not yet rated)  Rate this |   Briefcase | 3,000 reads

SQL Server 2016 SSIS Basics - Install SQL Server Data Tools

Step-by-step instructions for downloading and installing SQL Server Data Tools (SSDT) for SQL Server 2016.  Read more...
Rating: |  Discuss |   Briefcase | 1,233 reads

Setup and Implement SQL Server 2016 Always On Distributed Availability Groups

SQL Server 2016 introduced a new feature called Distributed Availability Group. A Distributed Availability Group is a special type of Availability Group that spans two separate Availability Groups. Edwin Sarmiento explains.  Read more...
By Additional Articles 2017/09/08 | Source: MSSQLTips.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 3,803 reads

Time Traveling with Temporal Tables on SQL Server 2016

One of the new features of SQL Server 2016 is the ability to time travel in your databases and visit a specific table at a specific point of time in history. You can also use this feature to audit changes or “undo” whole data warehouse updates.  Read more...
By Johan Åhlén 2017/09/04 (first published: 2016/10/18) | Source: SQLServerCentral.com | Category: sql server 2016
Rating: |  Discuss |   Briefcase | 3,762 reads

Why PolyBase Matters

An alternative approach to disaster recovery and backup strategies using PolyBase.   Read more...
By Alain Dormehl 2017/08/25 (first published: 2015/08/10) | Source: SQLServerCentral.com | Category: aps
Rating: |  Discuss |   Briefcase | 6,966 reads

Analysing Sales Patterns: R + SQL Server

We show how to use RevolutionR to analyse & visualise purchasing behaviours in AdventureWorksDW2012.  Read more...
By Nick Burns 2017/08/18 (first published: 2015/12/15) | Source: SQLServerCentral.com | Category: revolutionr
Rating: |  Discuss |   Briefcase | 7,285 reads

SQL Server R Services: The Basics

It is possible to do a great deal with R within SQL Server, but it is best to start by doing analysis in R on numeric data from SQL Server and returning the results to SQL Server. There is great value to be gained even with this basic foundation. Robert Sheldon is on hand to give you a kick start with the first in his series on beginning with R in SQL Server.  Read more...
By Additional Articles 2017/08/10 | Source: SimpleTalk | Category: r services
Rating:  Rate this |   Briefcase | 7,091 reads

Properly Persisted Computed Columns

Paul White walks through a new trace flag in SQL Server 2016 designed to yield better execution plans (and performance) for queries involving computed columns.  Read more...
By Additional Articles 2017/06/20 | Source: SQLPerformance.com | Category: trace flags
Rating: (not yet rated)  Rate this |   Briefcase | 4,605 reads

Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 4

Continuing his series covering a step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster, Edwin Sarmiento looks at adding a node to an existing SQL Server 2016 failover clustered instance (FCI).  Read more...
By Additional Articles 2017/05/22 | Source: MSSQLTips.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 2,840 reads
   Items 1 to 20 of 171    Older >>
json (13)    
dynamic data masking (9)    
editorial (7)    
polybase (6)    
stretch database (6)    
tempdb (6)    
temporal tables (6)    
ado.net (5)    
always encrypted (5)    
installation (5)    
query store (qs) (5)    
sql server 2014 (5)    
t-sql (5)    
columnstore index (4)    
encryption (4)    
ezado (4)    
r services (4)    
reporting services (ssrs) (4)    
rest services (4)    
row-level security (rls) (4)    
sql server 2012 (4)    
availability group (ag) (3)    
azure sql database (3)    
in-memory oltp (3)    
integration services (ssis) (3)    
query plans (3)    
security (3)    
administration (2)    
always on (2)    
aps (2)    
backup strategy (2)    
dax (2)    
dbcc checkdb (2)    
development (2)    
disaster recovery (dr) (2)    
execution plans (2)    
performance (2)    
r language (2)    
reporting (2)    
revolutionr (2)    
sql server 2008 r2 (2)    
sql server parallel data warehouse (2)    
alter column (1)    
analysis services (ssas) (1)    
analytics (1)    
azure (1)    
backup (1)    
backup to azure (1)    
batchmode execution. (1)    
build list (1)    
checkpoint (1)    
ci (1)    
cloud integration (1)    
collation (1)    
columnstore (1)    
columnstore indexes (1)    
columnstore row group merge (1)    
compress (1)    
compress() (1)    
computed columns (1)    
configuration (1)    
continuous delivery (1)    
continuous integration (ci) (1)    
data analysis (1)    
data driven subscriptions (1)    
data security (1)    
data types (1)    
data warehousing (1)    
database design (1)    
database weekly (1)    
database-scoped credential (1)    
date conversion (1)    
dbcc (1)    
deploy (1)    
deterministic (1)    
distributed availability groups (1)    
dmvs (1)    
ebook (1)    
extended events (xe) (1)    
failover clustered instance (fci) (1)    
for json (1)    
hardware (1)    
hashbytes() (1)    
hekaton (1)    
high availability (ha) (1)    
indatabase analytics (1)    
indexing (1)    
install (1)    
instant file initialization (ifi) (1)    
integrity check (1)    
internals (1)    
live query statistics (1)    
managed backup (1)    
microsoft (1)    
microsoft azure sql database (1)    
miscellaneous (1)    
number of rows read (1)    
operational analytics (1)    
other (1)    
package parts (1)    
pivoting (1)    
product reviews (1)    
query store (1)    
random numbers (1)    
redgate (1)    
row level security (rls) (1)    
service packs (1)    
shallow backup (1)    
spatial data (1)    
sql server (1)    
sql server 2005 (1)    
sql server 2008 (1)    
sql server 2017 (1)    
sql server data tools (ssdt) (1)    
sql server r services (1)    
sql server reporting services (1)    
sql toolbelt (1)    
sqlclr (1)    
statistics (1)    
stretch (1)    
stretch database adviser (1)    
string_split (1)    
system-versioned tables (1)    
tabular model (1)    
tempdb performance tuning (1)    
temporal data (1)    
temporal table (1)    
trace flag 1117 (1)    
trace flag 1118 (1)    
trace flags (1)    
transparent data encryption (tde) (1)    
user groups (1)