Sites anglophones

Presenting on Concurrency Three Times This Month…Though Not Concurrently

Publié le 16 mars 2016 sur

Tomorrow night, March 15, I will be at the Hampton Roads SQL Server User Group’s March meeting, then at SQL Saturday Richmond on Saturday the 19th, then finally back at home on the 25th for my home user group in Nashville (which I haven’t s …

SQL SERVER – Mirroring Error 1412 – The remote copy of database has not been rolled forward to a point in time that is encompassed in the local copy of the database log. (Microsoft SQL Server, Error:)

Publié le 16 mars 2016 sur journey to sqlauthority

With mirroring gone as deprecated feature, I have tried to keep away from exploring into what has been happening in this space. But what can I do when customers still use them? The challenges for consulting is pushing the boundaries of my comfort zone …

The SQL Server 2016 Query Store: Forcing Execution Plans using the Query Store

Publié le 16 mars 2016 sur

The SQL Server 2016 Query Store can give you valuable performance insights by providing several new ways of troubleshooting queries, studying their plans, exploring their context settings, and checking their performance metrics. However, it can also di …

Database Lifecycle Management for ETL Systems

Publié le 16 mars 2016 sur

Few databases are self-contained. They take data from other sources, and publish them to downstream consumers of data. These ETL processes tend to grow in an unplanned organic way and so tand to cause trouble both in production and in deployment. Datab …

T-SQL Window Function Speed Phreakery: The FIFO Stock Inventory Problem

Publié le 16 mars 2016 sur

Sometimes, in the quest for raw SQL performance, you are forced to sacrifice legibility and maintainability of your code, unless you then document your code lavishly. Phil Factor’s SQL Speed Phreak challenge produced some memorable code, but can SQL fe …

SQL Server 2016 Documentation Survey

Publié le 15 mars 2016 sur

The SQL Server product team wants to hear from you. Here’s your chance to say what you expect from documentation. Hurry – the survey closes on March 18.…(read more)

SQL Server Diagnostic Information Queries for March 2016

Publié le 15 mars 2016 sur - glen berry

This month, I have one new query in the SQL Server 2016 set, along with additional comments and documentation in the SQL Server 2012, 2014 and 2016 sets. Rather than having a separate blog post for each version, I have just put the links for all six ma …

Splitting Strings: SQL Server 2016 To The Rescue!

Publié le 15 mars 2016 sur

Hold me now! Richie had to break out the fainting couch when I read the release notes for SQL Server 2016 RC0. Why? WHY? Because of one thing. One thing I have watched so many people butcher and bungle over the years (even myself, in about 2009). New B …

Sparse Columns in SQL Server : Impact on Time & Space

Publié le 15 mars 2016 sur

Erin Stellato (@erinstellato) looks into sparse columns in SQL Server – the changes to space requirements and the impact on the write portion of your workload.

Documenting SQL Server with PowerShell: PosH VC

Publié le 15 mars 2016 sur

Virtual Chapter meeting, Mar 16, 12pm EST. Documentation is mostly overlooked and only comes up when a problem arises. What if you’d have a tool or method to generate documentation for all your database servers? In this session, Sander Stad will show y …

The Basics of Masking Data in SQL Server 2016

Publié le 15 mars 2016 sur

Learn the basics of how Dynamic Data Masking can be used to obfuscate data in SQL Server 2016+.

SQL SERVER – The Need for Data Tier Elasticity in Cloud Computing

Publié le 15 mars 2016 sur journey to sqlauthority

Many application workloads are characterized by resource use that varies over time. Usage peaks can vary depending on the time of the day, week, or month, and outside events. Even a big sport game or an online sale can bring usage spikes. With traditio …

Creating a Date Dimension in a Tabular Model

Publié le 15 mars 2016 sur

As well as its multidimensional model, SQL Server Analysis Services (SSAS) now has a tabular model of database that either runs in-memory or in DirectQuery mode. The in-memory analytics engine allows the users of Excel or Power View to base reports on …

Building Your Business with Quality Data

Publié le 14 mars 2016 sur

Your contact data is valuable, but is it up to its full potential? Without the proper maintenance, the quality of your data quickly decreases–so quickly that 50% of databases deteriorate after only two years. It is an absolute necessity to maintain yo …

Why most of you should leave Auto-Update Statistics on

Publié le 14 mars 2016 sur

Oh God, he’s talking about statistics again Yeah, but this should be less annoying than the other times. And much shorter. You see, I hear grousing. Updating statistics was bringin’ us down, man. Harshing our mellow. The statistics would ju …

Pages :