Sites anglophones


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

Publié le 29 décembre 2016 sur sqlservercentral.com
 

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 …

Internal Query Processor Error with ColumnStore Indexes

Publié le 29 décembre 2016 sur sqlservercentral.com
 

SQL Server 2016 does not allow computed columns to co exist with columnstore indexes and clustered btree indexes on same table.

SQL SERVER – Why Does Encrypted Column Show NULL on Subscriber?

Publié le 29 décembre 2016 sur journey to sqlauthority
 

While I was online on Skype last night, one of my old customers pinged me and wanted to know my opinion of a special issue which he was facing when Encrypted Column Show NULL on Subscriber. He said that they have a replication setup between SQL Se …

SQL Server 2014 Cumulative Updates (December 2016)

Publié le 28 décembre 2016 sur sqlblog.com
 

The SQL Server Tiger Team has released the following Cumulative Updates for SQL Server 2014.Cumulative Update 3 per SQL Server 2014 SP2KB 3204388 Download Build number: 12.0.5537.0 SQL Release Services Blog post Cumulative Update 10 per SQL Server …

SQL Server 2014 CU3 for SP2 and CU10 for SP1 are Available

Publié le 28 décembre 2016 sur sqlblog.com
 

Just an FYI for those of you on SQL Server 2014 SP2 that there is a new CU available for download can can be found here . Also if you are still on SP1 for SQL Server 2014 you can get CU10 as well here. https://www.microsoft.com/en-us/download/details.a …

Build Me A Build: What Would You Do?

Publié le 28 décembre 2016 sur brentozar.com
 

We already know what I’d do In my last post, I talked about the desktop I’m building with my hardware budget for this year (and, uh, some of next year’s, too…). Based on awesome feedback from you all, I made a few changes to th …

Common questions about Azure SQL Data Warehouse

Publié le 28 décembre 2016 sur sqlservercentral.com
 

This article compiles some common questions and answers about Azure SQL Data Warehouse.

Oracle to SQL SERVER Migration – Triggers Used While Migration

Publié le 28 décembre 2016 sur journey to sqlauthority
 

I am a big supporter of working on something that I get used. This is a trend I see that most of us are used to. When was the last time you switched loyalty from one phone to another? I know most of us have multiple devices that we use, but rarely that …

2016: the year in books

Publié le 27 décembre 2016 sur sqlskills.com - paul randall
 

Back in 2009 I started posting a summary at the end of the year of what I read during the year (see my posts from 2009, 2010, 2011, 2012, 2013, 2014, 2015) and people have been enjoying it, so here I present the 2016 end-of-year post. I …

The Recording for SSIS Academy: Using the SSIS Catalog, Day 1 is Available

Publié le 27 décembre 2016 sur sqlblog.com
 

The recording for SSIS Academy: Using the SSIS Catalog , Day 1 is now available (registration required)! This delivery of SSIS Academy continues live Wednesday and Thursday (28, 29 Dec 2016). You can learn more about SSIS Execution and Monitoring Wedne …

The Recordings for SSIS Academy: Using the SSIS Catalog are Available

Publié le 27 décembre 2016 sur sqlblog.com
 

The recordings for SSIS Academy: Using the SSIS Catalog, Day 1 , Day 2 , and Day 3 are now available (registration required)! Day 1 focused on creating the SSIS Catalog and SSIS deployment. Day 2 focused on SSIS Execution and Monitoring Wednesday. SSIS …

Intel Processor Architecture 2020

Publié le 27 décembre 2016 sur sqlblog.com
 

There is an article on WCCFtech , that a new Intel processor architecture to succeed the lake processors (Sky, Cannon, Ice and Tiger) will be « faster and leaner » and more interestingly might not be entirely compatible with older software. The original …

Build your Cloud Analytics Solution from an Azure Template

Publié le 27 décembre 2016 sur sqlmag.com
 

Quickly generate building blocks needed for analytics using templates Cloud computing presents a unique platform for generating complex analytics solutions quickly. With the use of pre-build solution templates, Azure provides an easy mechanism to get s …

[Video] Office Hours 2016/12/21 (With Transcriptions)

Publié le 27 décembre 2016 sur brentozar.com
 

This week, Erik and Richie discuss latency, partition tables, SOS_SCHEDULER_YIELD, alerts, nolock, and what people look for in Senior DBA. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscr …

SQL Server v.Next – Linux Installation Step by Step

Publié le 27 décembre 2016 sur sqlservercentral.com
 

An introduction to SQL Server for Red Hat Linux Administrators with a step by step installation. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix t …


Pages :