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

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 | 846 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,239 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,392 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,912 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,106 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 | 5,618 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,106 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,537 reads

Date Dimension Script

T-SQL script that creates Date_Dim & populates it for any date-range.  Read more...
By Dave Bunch 2017/05/08 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 530 reads

Selecting and Configuring Hardware for SQL Server 2016 Standard Edition

Glenn Berry explains why you need to be very careful about your physical processor choice when configuring servers to run SQL Server 2016 Standard Edition.  Read more...
By 2017/04/25 | Source: SQLPerformance.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 3,356 reads

Package Parts – First Impressions

This article gives an overview of some good and not-so-good features of SSIS package parts.  Read more...
By Shubhankar Thatte 2017/04/19 | Source: SQLServerCentral.com | Category: package parts
Rating: |  Discuss |   Briefcase | 1,305 reads

SQL Server 2016 Online ALTER COLUMN Operation

Learn about the time savings, blocking scenarios, limitations and more for the SQL Server 2016 online ALTER COLUMN operation.  Read more...
By Additional Articles 2017/04/07 | Source: MSSQLTips.com | Category: alter column
Rating: (not yet rated)  Rate this |   Briefcase | 3,167 reads

It Just Runs Faster - Spatial

By Steve Jones 2017/03/31 | Category: spatial data
Rating: (not yet rated) |  Discuss |   Briefcase | 900 reads

It Just Runs Faster - AlwaysOn Compression

By Steve Jones 2017/03/17 | Category: alwayson
Rating: (not yet rated) |  Discuss |   Briefcase | 895 reads

CPU Limits

By Steve Jones 2017/03/07 | Category: sql server 2016
Rating: (not yet rated) |  Discuss |   Briefcase | 1,073 reads

New CREATE OR ALTER statement in SQL Server 2016 SP1

Ahmad Yaseen explains what SQL Server 2016 SP1's new CREATE OR ALTER statement does, and how to use it.  Read more...
By Additional Articles 2017/02/20 | Source: MSSQLTips.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 5,112 reads

SQL Server 2016 Just Runs Faster - DBCC

By Steve Jones 2017/02/10 | Category: dbcc
Rating: (not yet rated) |  Discuss |   Briefcase | 1,056 reads

Simple Row Level Security for SQL Server 2016

Have you ever had a need to place some simple row level security on a SQL Server table? Well now you can do that in SQL Server 2016 by using row level security.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 6,216 reads
   Items 1 to 20 of 159    Older >>
 
Tags
json (10)    
dynamic data masking (8)    
editorial (7)    
polybase (6)    
stretch database (6)    
tempdb (6)    
temporal tables (6)    
ado.net (5)    
always encrypted (5)    
installation (5)    
query store (qs) (5)    
encryption (4)    
ezado (4)    
r services (4)    
reporting services (ssrs) (4)    
rest services (4)    
row-level security (rls) (4)    
sql server 2012 (4)    
sql server 2014 (4)    
t-sql (4)    
availability groups (ag) (3)    
columnstore index (3)    
integration services (ssis) (3)    
security (3)    
administration (2)    
aps (2)    
azure sql database (2)    
backup strategy (2)    
dbcc checkdb (2)    
development (2)    
disaster recovery (dr) (2)    
execution plans (2)    
in-memory oltp (2)    
performance (2)    
query plans (2)    
reporting (2)    
revolutionr (2)    
sql server 2008 r2 (2)    
sql server parallel data warehouse (2)    
alter column (1)    
always on (1)    
alwayson (1)    
analysis services (ssas) (1)    
analytics (1)    
azure (1)    
backup (1)    
backup to azure (1)    
build list (1)    
checkpoint (1)    
ci (1)    
cloud integration (1)    
collation (1)    
columnstore (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 (1)    
data security (1)    
data warehousing (1)    
database design (1)    
database weekly (1)    
database-scoped credential (1)    
date conversion (1)    
dax (1)    
dbcc (1)    
deploy (1)    
deterministic (1)    
distributed availability groups (1)    
dmvs (1)    
failover clustered instance (fci) (1)    
for json (1)    
hardware (1)    
hashbytes() (1)    
high availability (ha) (1)    
indatabase analytics (1)    
indexing (1)    
install (1)    
instant file initialization (ifi) (1)    
integrity check (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)    
product reviews (1)    
query store (1)    
r language (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 data tools (ssdt) (1)    
sql server integration services (1)    
sql server reporting services (1)    
sql toolbelt (1)    
sqlclr (1)    
statistics (data) (1)    
stretch (1)    
stretch database adviser (1)    
string_split (1)    
system-versioned tables (1)    
tabular model (1)    
tempdb performance tuning (1)    
temporal data (1)    
trace flag 1117 (1)    
trace flag 1118 (1)    
trace flags (1)    
transparent data encryption (tde) (1)    
user groups (1)