Sites anglophones

New Drop If Exists Syntax in SQL Server 2016

Publié le 1 septembre 2016 sur

When writing T-SQL code, we often write code to check if the database object exists first and then take some action. In this tip John Miner covers the new and easier way to do this in SQL Server 2016.

FIX: The unattended execution account cannot be set at this time

Publié le 1 septembre 2016 sur

I ran into this one today and it’s the in the category of things that I’m likely to run into again one day so it’s worth recording it here. I was trying to configure an unattended execution account for SQL Server Reporting Services 20 …

SQL SERVER – Delete All Waiting Workflows in MSCRM to Speed Up Microsoft Dynamics

Publié le 1 septembre 2016 sur journey to sqlauthority

Last week, during performance tuning consultancy, I faced a very interesting situation when customer’s Microsoft Dynamics CRM was extremely slow. After quickly researched we found that they have a very high number of Mass Waiting Task Workflows i …

The DIY guide for local-global aggregation

Publié le 31 août 2016 sur

If you have read the title, you will not be surprised when I tell you that this blog is about a thing called “local-global aggregation”, and on how to do that yourself. So let’s start with the two obvious questions: what the heck is l …

What Every Accidental DBA Needs to Know Now: #2 Restores

Publié le 31 août 2016 sur

Preface read more

The SQL of Textonyms

Publié le 31 août 2016 sur

Textonyms When you typed in words on a mobile phone’s digital pad to ‘text’ someone, there was always the possibility of a particular combination of digits being ambiguous in that it corresponds to more than one word. Either you had …

Upcoming SQL Server 2018 Features

Publié le 31 août 2016 sur

If you think that’s big, you should see the size of the drink I happened to be in Seattle this week after finishing up an Alaska cruise, and I had the chance to sit down with some of the PMs responsible for upcoming SQL Server features. It turns …

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 …

Pages :