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

Content with tag SQL Server 2016 Rss

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

SQL Server 2016 Just Runs Faster - DBCC

By Steve Jones 2017/02/10 | Category: dbcc
Rating: (not yet rated) |  Discuss |   Briefcase | 1,070 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,284 reads

The New SQL Server 2016 Edition Limits

There are some changes to memory limits in SQL Server 2016 SP1 Standard Edition.  Read more...
By Steve Jones 2017/01/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 128 reads

SQL Server 2016 Build List

A list of all builds for SQL Server 2016. Updated with CU3 for SP1 and CU6 for RTM.  Read more...
By Site Owners 2017/01/25 | Source: SQLServerCentral.com | Category: sql server 2016
Rating: |  Discuss |   Briefcase | 1,226 reads

Columnstore Indexes and Computed Columns in SQL Server 2016

You can’t do everything with a columnstore index — but SQL Server’s optimizer can get pretty creative so it can use a columnstore index in ways you might not expect. Kendra Little explains.  Read more...
By Additional Articles 2017/01/25 | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 3,750 reads

Getting Started with R Services in SQL Server 2016 – Part 2

SQL Server 2016 brings native support for doing advanced analytics, using R Services, in the database itself. Arshad Ali takes a look at a detailed conceptual execution flow, executing R scripts from SQL Server Management Studio and other R client tools.  Read more...
By Additional Articles 2017/01/23 | Source: Database Journal | Category: r services
Rating: (not yet rated)  Rate this |   Briefcase | 3,539 reads

What's New in Reporting Services 2016 Service Pack 1

SQL Server 2016 was been released the first of June 2016, but at the recent Connect event Microsoft announced the first service pack. Aside from numerous fixes, this service pack also comes packed with some notable enhancements for Reporting Services. Koen Verbeeck gives you an overview of these enhancements.  Read more...
By Additional Articles 2017/01/19 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 4,691 reads

SQL Server 2016 Enterprise Edition Performance Advantages

Glenn Berry uses a few specific examples to demonstrate the performance benefits you can get from SQL Server 2016 SP1 Enterprise Edition.  Read more...
By Additional Articles 2017/01/10 | Source: SQL Server Performance | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 4,711 reads

Memory Limits in SQL Server 2016 SP1

Aaron Bertrand explains a few details about the memory limits in SQL Server 2016 Service Pack 1 that make this upgrade even more compelling.  Read more...
By Additional Articles 2017/01/02 | Source: SQLPerformance.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 3,742 reads

Getting Started with R Services in SQL Server 2016 – Part 1

SQL Server 2016 brings native support to advanced analytics in the database itself, using R Services. In this article, Arshad Ali explains what R is, what the on-premise advanced analytics options from Microsoft are, and shows how to get started using R Services with SQL Server 2016.  Read more...
By Additional Articles 2016/12/29 | Source: Database Journal | Category: r services
Rating: (not yet rated)  Rate this |   Briefcase | 4,104 reads

HASHBYTES limits

By Steve Jones 2016/12/21 | Category: sql server 2016
Rating: (not yet rated) |  Discuss |   Briefcase | 879 reads

A Big Deal : SQL Server 2016 Service Pack 1

Microsoft has made a bold change with SQL Server 2016 Service Pack 1 : Many Enterprise features are now available in lower editions. Read on for details.  Read more...
By Additional Articles 2016/12/13 | Source: SQLPerformance.com | Category: sql server 2016
Rating:  Rate this |   Briefcase | 10,080 reads

SQL Server 2016 SP1 Features

By Steve Jones 2016/12/09 | Category: sql server 2016
Rating: (not yet rated) |  Discuss |   Briefcase | 1,110 reads

EzAdo Part 4

EzAdo is a very simple api built to exploit some new features of SQL 2016. It combines software, convention, and creativity to get more done in less time.  Read more...
By Alan Hyneman 2016/11/29 | Source: SQLServerCentral.com | Category: ado.net
Rating: |  Discuss |   Briefcase | 730 reads

How to Change an Analysis Services Instance to Tabular Mode

In this post I will show a procedure to change Analysis Services instance to tabular mode in SQL Server 2016 if you accidentally setup SQL Server Analysis Services to multi-dimensional mode instead of Tabular mode   Read more...
Rating: |  Discuss |   Briefcase | 718 reads

Experience SQL Server 2016 in Microsoft Luxembourg’s Intelligent Office

The SQL Server Luxembourg User Group invites you to join us at our next event, in Microsoft’s new Intelligent Offices, for Tom van Zele’s SQL 2016 presentation. Tom’s road-show session highlights SQL Server 2016’s new features: End-to-end mobile BI, advanced analytics, cloud integration and lots of other new stuff will be addressed.   Read more...
By Additional Articles 2016/11/28 (first published: 2016/11/28) | Source: SQLServerCentral.com | Category: sql server 2016
Rating:  Rate this |   Briefcase | 3,104 reads

What's New in SQL Server Reporting Services 2016

Koen Verbeeck provides an overview of the new features and capabilities found in SQL Server Reporting Services 2016.  Read more...
By Additional Articles 2016/11/25 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 4,695 reads

Experience SQL Server 2016 in Microsoft Luxembourg’s Intelligent Office

The SQL Server Luxembourg User Group invites you to join us at our next event, in Microsoft’s new Intelligent Offices, for Tom van Zele’s SQL 2016 presentation. Tom’s road-show session highlights SQL Server 2016’s new features: End-to-end mobile BI, advanced analytics, cloud integration and lots of other new stuff will be addressed.   Read more...
By Additional Articles 2016/11/28 (first published: 2016/11/28) | Source: SQLServerCentral.com | Category: sql server 2016
Rating:  Rate this |   Briefcase | 3,104 reads
<< Newer    Items 21 to 40 of 162    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)    
query plans (3)    
security (3)    
administration (2)    
aps (2)    
azure sql database (2)    
backup strategy (2)    
dax (2)    
dbcc checkdb (2)    
development (2)    
disaster recovery (dr) (2)    
execution plans (2)    
in-memory oltp (2)    
performance (2)    
r language (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 subscriptions (1)    
data security (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)    
extended events (xe) (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)    
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 integration services (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)    
trace flag 1117 (1)    
trace flag 1118 (1)    
trace flags (1)    
transparent data encryption (tde) (1)    
user groups (1)