Sites anglophones


SQL SERVER – Msg 19062, Level 16, State 1. Could Not Create a Trace File. Error = 0x80070005

Publié le 23 novembre 2016 sur journey to sqlauthority
 

One of my clients reported a strange problem and I learned something new from it. Here is the conversation where we discussed how to fix error 19062 – could not create a trace file. <EMAIL> Hi Pinal I have a stored procedure which is execut …

Curious – How does STRING_SPLIT (2016) handle empty/NULL Input?

Publié le 22 novembre 2016 sur sqlblog.com
 

If you haven’t seen STRING_SPLIT, it is pretty awesome, and something we have all been working with for many years, which you can read about in Erland Sommarskog’s great article here along with many other concepts involved in sending in a set of data t …

The Brighter Side of SQL Server’s future

Publié le 22 novembre 2016 sur brentozar.com
 

Believe it or not, I sometimes like things SP1 for 2016 has a bunch of cool new tricks: I’m pretty psyched on the Wait Stats stuff in actual execution plans. I hope it eventually comes in some form to cached plans, or at least Query Store plans, …

Encryption Primer Session

Publié le 22 novembre 2016 sur sqlblog.com
 

For the November meeting, I was honored to be invited to speak at the Minneapolis PASS user group here in the Twin Cities. I put together a bit of an unconventional session covering the basics of hashing and encryption, but as an introduction for DBAs. …

SQL Saturday #567 Slovenia: Please Attend or Unregister

Publié le 22 novembre 2016 sur sqlblog.com
 

We would like to make an appeal to all of you who are registered to the PASS SQL Saturday #567 Slovenia event: please come. Please remember that this conference was made possible because of the speakers, who are using their time and come on their own e …

Configuring Integration Services in a SQL Server 2016 Cluster

Publié le 22 novembre 2016 sur sqlservercentral.com
 

In this post I will show a procedure to configure Integration Services in a SQL Server 2016 Cluster.

Why Would I Ever Need to Partition My Big ‘Raw’ Data?

Publié le 22 novembre 2016 sur sqlservercentral.com
 

Whether you are running an RDBMS, or a Big Data system, it is important to consider your data-partitioning strategy. As the volume of data grows, so it becomes increasingly important to match the way you partition your data to the way it is queried, to …

SQL SERVER – Database Mirroring Error -The Specified Network Name is No Longer Available

Publié le 22 novembre 2016 sur journey to sqlauthority
 

Have you ever seen a situation where SQL Server mirroring is impacted because of external factors? One of my customers reported several of the following errors in the SQL Server ERRORLOG SQL SERVER – Where is ERRORLOG? Various Ways to Find E …

Microsoft Announces Enterprise Edition Features Across all Editions of SQL Server 2016

Publié le 21 novembre 2016 sur sqlmag.com
 

Major announcements from Scott Guthrie of Microsoft at the 2016 Connect Conference concerning enterprise edition features availability and SQL Server on Linux. read more

Initial Thoughts on 2016 SP1

Publié le 21 novembre 2016 sur brentozar.com
 

A really odd choice I’ve talked a bit about my annoyance with hardware limits for Standard Edition here and here. If you’re a bunch of SQL-savvy developers who understand the Enterprise Edition features that are now available in 2016 SP1, g …

DAX Editor 2.0 finally available: it is a must have for #ssas #tabular #dax developers

Publié le 21 novembre 2016 sur sqlblog.com
 

The SQL Server Data Tools (SSDT) editor for Tabular models has been improved in the recent updates. For example, the Tabular Model Explorer enables you to quickly jump between the entities of your model organized in a hierarchical way. However, when it …

Service Broker Error Handling

Publié le 21 novembre 2016 sur sqlservercentral.com
 

How to handle errors raised during Service Broker Queue Processing.

Implementing a custom sort

Publié le 21 novembre 2016 sur sqlservercentral.com
 

Rob Farley discusses some solutions and gotchas for implementing a custom sort using ORDER BY in T-SQL queries.

SQL SERVER – Best Practices About SQL Server Service Account and Password Management

Publié le 21 novembre 2016 sur journey to sqlauthority
 

One of my clients posted a question to me about management of SQL Server service account. Since it was a nice learning for me, I am sharing my discussion via this blog post. Let us see the Best Practices About SQL Server Service Account and Passwo …

SQL Nexus 5.5.0.1

Publié le 21 novembre 2016 sur sqlblog.com
 

  The SQL Nexus set of utilities are some of the most under utilized tools available to the SQL Server community. I used and touted the RML utility for many years to help people analyze trace information very fast and easily. Eventually XE traces …


Pages :