Sites anglophones


Understanding the HPE Superdome X Data Center Footprint

Publié le 14 septembre 2016 sur sqlmag.com
 

Upgrading your IT infrastructure is always a big deal. When you’re planning to implement a new server in your data center, you need to be aware of the system’s physical size and implementation characteristics, as well as the system’s …

How We Architected Paste The Plan

Publié le 14 septembre 2016 sur brentozar.com
 

If you’ve ever heard the Away From the Keyboard, a podcast that I co-host with Cecil Phillip, you’ll quickly discover that I love hearing stories about how products are created. Now I get to tell you the story of how Paste The Pla …

BLANK and Boolean functions like IF in #dax

Publié le 14 septembre 2016 sur sqlblog.com
 

A recent change in the DAX language transformed the behavior of IF statement, so that it should not return BLANK but only TRUE/FALSE if the results should be logical expressions. In that case, the BLANK is transformed in a FALSE condition. For example, …

Best Practices For Building Alerts for Using APIs with SQL Server

Publié le 14 septembre 2016 sur sqlservercentral.com
 

Tim Smith shares some ideas about how to handle and alert on irregular data coming from APIs when loading your database.

Stairway to U-SQL Level 8: Joining Tables in U-SQL

Publié le 14 septembre 2016 sur sqlservercentral.com
 

U-SQL provides a number of ways to join data sources together. This articles introduces the joins available and how you can use them.

SQL SERVER – How to Downgrade SQL Server Edition?

Publié le 14 septembre 2016 sur journey to sqlauthority
 

One of a unique advantage of freelancing is learning more and more. I get a chance to hear some of the real word problem and it gives me immense pleasure to provide a feasible solution to them. In this blog post we will discuss How to Downgrade SQ …

You’ve been doing cloud for years…

Publié le 14 septembre 2016 sur sqlblog.com
 

This month’s T-SQL Tuesday is hosted by Jeffrey Verheul (@devjef) and is on the topic of Cloud. I seem to spend quite a bit of my time these days helping people realise the benefit of the Azure platform, whether it be Machine Learning for doing s …

24 Hours of PASS – Locking and Blocking Q&A

Publié le 13 septembre 2016 sur sqlblog.com
 

Thanks to everyone who attended my 24HOP session on Wednesday, September 7. My favorite part is always the Q&A. I wish there was more time to do live Q&A, but because there’s not, I get to turn it into a blog post! My session was a snippe …

Where Can I Download a Specific SQL Server Cumulative Update?

Publié le 13 septembre 2016 sur sqlskills - jonathan kehayas
 

Microsoft has made a lot of changes to their servicing model for SQL Server over the years, specifically moving more towards Cumulative Updates and away from Service Packs as a means to deliver updates and fixes to SQL Server. Today I needed to replace …

Announcing PasteThePlan.com: An Easier Way to Share Execution Plans

Publié le 13 septembre 2016 sur brentozar.com
 

Since the dawn of man, people have struggled with sharing execution plans with each other for performance tuning. Now, it’s easy. First, get yourself a plan: Get the estimated execution plan by hitting control-L or clicking Query, Display Estimat …

Restore Gene Version 6 – User Guide

Publié le 13 septembre 2016 sur sqlservercentral.com
 

Read about the Restore Genie and the new support for fork points, Azure and Multiple Concurrent Restores.

SQL SERVER – Columnstore Index Cannot be Created When Computed Columns Exist

Publié le 13 septembre 2016 sur journey to sqlauthority
 

Explorations working with SQL Server never stop and I get an opportunity to learn something every other day. Today I thought of bringing pout some learning that happened to me by accident. As I was not sure and assumed certain things, these came as a s …

Learn to Use sp_Blitz, sp_BlitzCache, sp_BlitzFirst, and sp_BlitzIndex with These Tutorial Videos

Publié le 12 septembre 2016 sur brentozar.com
 

There have been so many improvements lately to our First Responder Kit scripts that it was time to update our tutorial videos. Each of these is about ten minutes long and shows how to use ’em: How to Use sp_Blitz for a Health Check How to Use sp_ …

Creating Partition on Existing tables and Rolling Partitions

Publié le 12 septembre 2016 sur sqlservercentral.com
 

this article describes about creating partitions on our existing Tables and also gives details about how to create rolling partition to support new data

Real-time Operational Analytics in SQL Server 2016 – Part 1

Publié le 12 septembre 2016 sur sqlservercentral.com
 

Arshad Ali takes a look at traditional analytics architecture, the challenges it faces, and how the newly introduced Real-time Operational Analytics feature overcomes those challenges.


Pages :