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 180    Older >>
 

Implementing Stretch Database.

Learn how you can enable the Stretch Database feature in SQL Server 2016.  Read more...
By Deepak Prasad Sahu 2019/01/15 | Source: SQLServerCentral.com | Category: stretch database
Rating: |  Discuss |   Briefcase | 875 reads

Date Dimension Script

T-SQL script that creates Date_Dim & populates it for any date-range.  Read more...
By Dave Bunch 2018/12/27 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 1,124 reads

Datatypes and the Default Mask with Dynamic Data Masking

This article digs deeper into the ways that Dynamic Data Masking works with different data types.  Read more...
By Steve Jones 2018/11/09 (first published: 2016/03/23) | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: |  Discuss |   Briefcase | 1,833 reads

The Basics of Dynamic Data Masking

Learn the basics of how Dynamic Data Masking can be used to obfuscate data in SQL Server 2016+.  Read more...
By Steve Jones 2018/10/26 (first published: 2016/03/15) | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: |  Discuss |   Briefcase | 3,766 reads

Approaches to Import JSON in SSIS (SQL Server 2016+) Part 2

In this article, 2nd of 2-part series, we will look at the 3rd approach to import JSON, recap both parts of the series and form a conclusion.  Read more...
By Nikolai Basov 2018/08/27 | Source: SQLServerCentral.com | Category: sql server 2016
Rating: (not yet rated) |  Discuss |   Briefcase | 575 reads

Approaches to Import JSON in SSIS (SQL Server 2016+) Part 1

In this article, 1st of 2-part series, we will look at 2 approaches to import JSON in SSIS using 2 methods: the new functionality of SQL Server 2016 and the Json.NET library.  Read more...
By Nikolai Basov 2018/08/20 | Source: SQLServerCentral.com | Category: sql server 2016
Rating: |  Discuss |   Briefcase | 843 reads

Learning about FOR JSON

Links and information about the FOR JSON clause in SQL Server 2016.  Read more...
By Site Owners 2018/08/10 (first published: 2015/10/05) | Source: SQLServerCentral.com | Category: for json
Rating: |  Discuss |   Briefcase | 4,716 reads

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017.  Read more...
By Ola Hallengren 2018/06/04 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 45,934 reads

Configuring R Services in SQL Server 2016

R Services provides in-database analytics in SQL Server 2016. In this article we step through configuring R Services and get you started with in-database analytics.  Read more...
By Nick Burns 2018/05/28 (first published: 2016/01/27) | Source: SQLServerCentral.com | Category: revolutionr
Rating: |  Discuss |   Briefcase | 4,406 reads

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,514 reads

JSON in SQL Server 2016

By Evgeny Garaev 2018/03/13 | Category: sql server 2016
Rating: (not yet rated) |  Discuss |   Briefcase | 924 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,507 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 | 7,641 reads

Creation of a temporal table

By Evgeny Garaev 2018/02/15 | Category: sql server 2016
Rating: (not yet rated) |  Discuss |   Briefcase | 864 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,930 reads

Store JSON data in SQL Server 2016

By Evgeny Garaev 2018/01/29 | Category: json
Rating: (not yet rated) |  Discuss |   Briefcase | 830 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 | 5,527 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 | 3,228 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 | 3,060 reads
   Items 1 to 20 of 180    Older >>
 
Tags
json (15)    
dynamic data masking (9)    
editorial (7)    
stretch database (7)    
columnstore index (6)    
polybase (6)    
query data store (qds) (6)    
tempdb (6)    
temporal tables (6)    
ado.net (5)    
always encrypted (5)    
installation (5)    
integration services (ssis) (5)    
sql server 2014 (5)    
t-sql (5)    
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)    
backup (3)    
in-memory oltp (3)    
query plans (3)    
security (3)    
administration (2)    
always on (2)    
aps (2)    
compress() (2)    
dax (2)    
dbcc checkdb (2)    
development (2)    
disaster recovery (dr) (2)    
execution plans (2)    
json.net (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 to azure (1)    
batchmode execution. (1)    
build list (1)    
checkpoint (1)    
ci (1)    
cloud integration (1)    
collation (1)    
columnstore row group merge (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)    
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)