Sites anglophones


IT/Dev Connections 2017 Draws to Successful Close

Publié le 26 octobre 2017 sur sqlmag.com
 

Today marks the end of the 2017 IT/Dev Connections in San Francisco. Over the course of the last 4 days we had almost 200 sessions covering topics encompassing a broad swath of products, services, and concepts across the information technology landscap …

New class: IEBISec on Securing Your BI Platform

Publié le 26 octobre 2017 sur sqlskills.com - paul randall
 

We’ve added a second brand-new class to our Spring line-up in Chicago: Immersion Event on Securing Your BI Platform. It’s a 2-day class, taught by MVP and industry expert Stacia Varga, presented on May 3-4, 2018. By …

New class: IEBIStrat on Developing a BI and Analytics Strategy

Publié le 26 octobre 2017 sur sqlskills.com - paul randall
 

We’ve added a brand-new class to our Spring line-up in Chicago: Immersion Event on Developing a BI and Analytics Strategy. It’s a 3-day class, taught by MVP and industry expert Stacia Varga, presented on April 30 …

Let’s mix things up with a new way to learn.

Publié le 26 octobre 2017 sur brentozar.com
 

Because learning SQL Server is painful, we’ve been experimenting with new topics, new guest instructors, new ways of talking to other students during class, and much more. On October 30, I’m going to unveil our new live class lineup coverin …

Google’s ‘Quantum Supremacy’ Moment May Not Mean What You Think

Publié le 26 octobre 2017 sur sqlmag.com
 

Even those bullish on technology, including Google itself, think it will be another decade before either error-corrected or error-free quantum computing is possible.

SQL Monitor Quick Tip: Using the SQL static code analysis performance rules

Publié le 26 octobre 2017 sur sqlservercentral.com
 

This quick tip will review how SQL Monitor 7 has incorporated SQL Code Guard’s built-in set of Performance Rules for static code analysis. These rules are designed to highlight SQL syntax that could potential cause performance problems, and so in …

Distributed Computing Principles & SQL-on-Hadoop Systems

Publié le 26 octobre 2017 sur sqlservercentral.com
 

A look at SQL-On-Hadoop systems like PolyBase, Hive, Spark SQL in the context Distributed Computing Principles and new Big Data system design approach like the Lambda Architecture.

Data Starvation – Balance Your SQL Server – Part 2

Publié le 26 octobre 2017 sur journey to sqlauthority
 

In Part 1 I covered how much data your SQL Server should be processing and the effects if it isn’t.  Here we check to make sure that you’re achieving that speed. Let us continue learning about data starvation in this blog post. We will …

Distributed Computing Principles and SQL-on-Hadoop Systems

Publié le 26 octobre 2017 sur sqlservercentral.com
 

Introduction In a recent SQL-on-Hadoop article on Hive ( SQL-On-Hadoop: Hive-Part I), I was asked the question « Now that Polybase is part of SQL Server, why wouldn’t you connect directly to Hadoop from SQL Server?  » My simple answer will be « Because of …

FAQs: Windows Server 1709; Fixing Windows Store on WIndows 10; DHCP Scopes

Publié le 25 octobre 2017 sur sqlmag.com
 

Three times a week (Monday/Wednesday/Friday), John Savill tackles your most pressing IT questions. Read through the FAQ archives, or send him your questions via email.

SQL Server 2017 CU1 is Available

Publié le 25 octobre 2017 sur sqlskills.com - glen berry
 

On October 24, 2017, Microsoft released SQL Server 2017 Cumulative Update 1, which is Build 14.0.3006.16. This CU has 68 hot fixes by my count, which is a fairly high count. This shows that Microsoft has been busy fixing issues that have shown up since …

Improved parentheses formatting in SQL Prompt 8.1

Publié le 25 octobre 2017 sur sqlservercentral.com
 

The SQL Prompt team have made some improvements to parentheses formatting in the latest version of the tool – here are the details of what’s changed and why.

Stairway to Database Design Level 5: Procedures

Publié le 25 octobre 2017 sur sqlservercentral.com
 

Joe Celko tackles the subject of the Stored Procedure and its place in database design. What he writes is food for thought, even for experienced database developers.

Learn PowerBI and Advanced Analytics – Instructor-Led and Self Paced Training

Publié le 25 octobre 2017 sur journey to sqlauthority
 

If you are reading this blog, you must be aware that I focus on relational database and also in particular for SQL Server Performance Tuning. I always believed that any system in the world can use more performance. Well, while I focused on relational d …

First Responder Kit Release: Precon Precogs

Publié le 24 octobre 2017 sur brentozar.com
 

This release comes to you from a hotel room in Chicago: The land of fiscal insolvency and one shooting per hour. It’s pretty nice, otherwise. This release is to get the pre-precon important stuff in. As much as I’d like to push all the rece …


Pages :