Sites anglophones

PASS Summit is back! Looks inside the 2016 edition #Summit16

Publié le 31 août 2016 sur

The PASS Summit is back! This year, the most important event around the world for Microsoft Data Platform will be held again in Seattle (WA) from 25 to 28 October 2016 and it will be preceded from two pre-conference days from 24 to 25 October 2016.I wr …

Data Mining Algorithms – Logistic Regression

Publié le 31 août 2016 sur

It’s been awhile since I wrote the last blog on the data mining / machine learning algorithms. I described the Neural Network algorithm. In addition, it is a good time to write another post in order to remind the readers of the two upcoming semin …

Temporal Data Part 3 – Reporting Out Current and Historical Information

Publié le 31 août 2016 sur

With the introduction of temporal table support in SQL Server 2016 Microsoft also added some additional functionality that makes it easy for you to join the current and history records of a system-versioned table. Greg Larsen shows you some of the diff …

What are your BI pain points?

Publié le 31 août 2016 sur

Although Redgate develops a comprehensive set of tools for SQL Server developers and DBAs, its support for BI developers has so far been limited. With your help this may be set to change. They’re embarking on research to better understand the problems …

Stairway to Columnstore Indexes Level 9: Batch Mode Execution

Publié le 31 août 2016 sur

In this level, Hugo explains what batch mode execution is, how it differs from row mode execution, and what its limitations are.

SQL SERVER – Database Disaster Recovery Process

Publié le 31 août 2016 sur journey to sqlauthority

Many SQL Server DBAs are from time to time confronted with a disaster caused by unintentional or malicious changes on their database. Whatever the nature or intention of these changes are, they can cause great issues whether it was the data loss or a s …

Building a Desktop Workstation for SQL Server Development and Testing (August 2016)

Publié le 30 août 2016 sur - glen berry

Back in March of 2014, I wrote a fairly long blog post called Building a Workstation for SQL Server 2014 Development and Testing, with an updated version in September of 2015, both of which still generate quite a bit of hits and e-mail. Since it is now …

Learn T-SQL with the StackOverflow Database

Publié le 30 août 2016 sur

Background: a company came to us with a request: they had a lot of smart people who wanted to learn the basics of T-SQL in a day. Could we build an intro-to-T-SQL course that didn’t suck? Well, sure – as long as we could …

What’s New in SQL Server 2016 Analysis Services

Publié le 30 août 2016 sur

When Microsoft first included OLAP Services (the precursor of today’s SQL Server Analysis Services) in SQL Server 7, the company totally changed the enterprise database landscape. The introduction of OLAP Services marked the first time that OLAP …

Calculating odds ratio with T-SQL and R

Publié le 30 août 2016 sur

Simple steps towards understanding what is an Odds Ratio, and how do we arrive at it using TSQL and R scripts.

Formatting SQL Code – Part the Second

Publié le 30 août 2016 sur

When you’re formatting SQL Code, your objective is to make the code as easy to read with understanding as is possible, in a way that errors stand out. The extra time it takes to write code in an accessible way is far less than the time saved by the poo …

SQL SERVER – Whitepaper – Optimizing SQL Server Network Performance

Publié le 30 août 2016 sur journey to sqlauthority

I have blogged before regarding how to Identify Application vs Network Performance Issues using SQL Server Dynamic Management Views (DMV). You do have some further diagnostics as well as optimizations you can perform to drill down into the network issu …

BI Awareness and Adoption Tactics That Work, with Lestor Meadows of Kimberly-Clark

Publié le 29 août 2016 sur

Mico Yuk BI Brainz Analytics on Fire Podcast Episode 16 Welcome to another exciting episode of Analytics on Fire! This week’s topic comes from one of our customers, Kimberly-Clark. Lestor Meadows, Senior Manager of Global BI Delivery for Kimberly …

Announcing SSIS Catalog Compare v1.0

Publié le 29 août 2016 sur

We’re proud to announce the release of SSIS Catalog Compare v1.0 ! SSIS Catalog Compare compares the contents of two SSIS Catalog instances, surfacing SSIS project-related configurations metadata in treeview controls. Data Integration Lifecycle M …

[Video] Office Hours 2016/08/24 (With Transcriptions)

Publié le 29 août 2016 sur

This week, Richie and Erik discuss in-place instance upgrades, availability groups, the cloud, job security, business intelligence and user adoption, and much more! Here’s the video on YouTube: You can register to attend next week …

Pages :