Sites anglophones

A Big Deal : SQL Server 2016 Service Pack 1

Publié le 13 décembre 2016 sur

Microsoft has made a bold change with SQL Server 2016 Service Pack 1 : Many Enterprise features are now available in lower editions. Read on for details.

Generate Deadlock Summary Information

Publié le 13 décembre 2016 sur

This article will show you how to extract a summary of tables affected by deadlocks.

SQL SERVER – Error After Cluster Patching – Error: 5184, Severity: 16, State: 2

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

During my last consulting engagement, I was pulled by my client to consider an issue which they were facing. They informed that they have applied service pack on one of their clustered environment and since than SQL Server is not coming online. I asked …

Backups – are you missing the point?

Publié le 13 décembre 2016 sur

It’s a common question “Do you have a backup?” But it’s the wrong question. Very relevant for this month’s T-SQL Tuesday, hosted by Ken Fisher (@sqlstudent144), on the topic of backups. I think the question should be …

SSIS Catalog Browser Update

Publié le 12 décembre 2016 sur

SSIS Catalog Browser has been updated! Catalog Browser is part of the DILM Suite of utilities designed to assist enterprises with Data Integration Lifecycle Management (DILM). And it’s free. Catalog Browser provides a rich view of SSIS Catalog co …

Questions About the Use of PowerShell That you were Too Shy to Ask.

Publié le 12 décembre 2016 sur

What is the point of PowerShell? What are PowerShell’s antecedents? Where did it come from? Why didn’t Windows have a powerful scripting language like Korn? Why did it take so long to get PowerShell? How did PowerShell come about? Why is th …

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

Publié le 12 décembre 2016 sur

This week, Brent, Tara, Erik, and Richie discuss replicating TRUNCATE TABLE command between nodes, how to cope with social isolation that comes with working from home, database shrinking, how to improve log wait times, how to figure out the mac stop an …

Creating a Spark dataframe containing only one column

Publié le 12 décembre 2016 sur

I’ve been doing lots of Apache Spark development using Python (aka PySpark) recently, specifically Spark SQL, and one thing I’ve found very useful to be able to do for testing purposes is create a Spark SQL dataframe from literal values. Th …

Your Professional Development and the PASS Organization

Publié le 12 décembre 2016 sur

There are so many ways of keeping your technical skills and knowledge up-to-date. There are books, articles, conferences, video courses and so on, but nothing beats discussion and debate with professional people in other organisations facing a similar …

Creating SSRS Tabular Reports with Sparklines and Charts

Publié le 12 décembre 2016 sur

Learn how to add a sparkline and line chart to your SQL Server 2014 Reporting Services reports.

SQL SERVER – Clustered Instance Online Error – SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]

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

While I was playing with SQL Cluster in my lab, I restarted the VMs and found that I was not able to bring SQL Server online. As always I was looking for error message, but there was nothing interesting. Let us see in this blog post how to fix Clustere …

Special Icon on System-Versioned Table in SQL Server 2016 – Interview Question of the Week #101

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

Question: I just installed SQL Server 2016 developer version and new samples database WideWorldImports, upon expanding the tables, I noticed a special icon on the System-Versioned table which looks like a watch. What does this special icon which looks …

SQL SERVER – Unable to create login AlwaysOn availability group secondary replica

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

One of my clients reported a usual behavior of the AlwaysOn availability group. He informed me that he is trying to add a login on the secondary replica in the AlwaysOn AG environment but it is failing with below error: Msg 3906, Level 16, State 1, Lin …

Vote Now to Pick the GroupBy Conference Lineup

Publié le 9 décembre 2016 sur

Voting closes soon at GroupBy, the new free online conference where YOU pick the lineup. Here’s the sessions up for votes – there’s a lot of them, so maybe focus on rating the sessions you find the most interesting – quantity of …

Some Tips for Minimising the Pain of HTML Input Forms

Publié le 9 décembre 2016 sur

HTML Input forms are, by their nature, tiresome for the user of any website. However, with some attention to detail and a dash of JavaScript, it is possible to reduce the drudgery of form-filling to the minimum and minimise mistakes. Dino explains four …

Pages :