Sites anglophones


Balancing Performance and Readability

Publié le 20 mars 2018 sur sqlservercentral.com
 

Developers need to consider not only system performance when writing code, but also how readability impacts code maintenance.

Different Ways to Import JSON Files into SQL Server

Publié le 20 mars 2018 sur sqlservercentral.com
 

Nat Sundar explains the different ways to load JSON data into SQL Server, along the way also covering the use OpenRowset and OpenJSON functions to manage JSON data effectively.

SQL SERVER – FIX: Msg 3231 – The Media Loaded on “Backup” is Formatted to Support 1 Media Families, but 2 Media Families are Expected According to the Backup Device Specification

Publié le 20 mars 2018 sur journey to sqlauthority
 

While preparing for a demo for my upcoming session, I encountered an interesting error. I thought I have written a blog about it, but I was wrong. My earlier blog was about a different error which looks very similar. Here is my earlier blog for error 3 …

Azure SQL Managed Instances and Database Corruption

Publié le 19 mars 2018 sur brentozar.com
 

Disclaimer: I love Azure SQL Managed Instances (MIs) so far. They’re really cool, and I’m having a fun time playing with them. I’m about to describe a bug, and I’m sure this bug will be fixed soon, so it shouldn’t stop you …

Building SQL ConstantCare®: The Serverless Architecture

Publié le 19 mars 2018 sur brentozar.com
 

Our new SQL Constant Care® is an online service that analyzes your SQL Server’s diagnostic data, then gives you personalized advice on what you should do to make your database app faster and more reliable. I blogged about the vision …

Simplifying Availability Group Troubleshooting

Publié le 19 mars 2018 sur sqlskills - jonathan kehayas
 

The AlwaysOn_health event session in Extended Events is intended to make analyzing problems with Availability Groups possible after they have occurred.  While this event session goes a long way towards making it possible to piece together the puzz …

1.4.6 March version with SSMS integration and many other improvements

Publié le 19 mars 2018 sur gregory-boge.fr
 

Only fews days before the birth of my son, I wanted to provide this new version in March. So what’s new ? Open in SSMS Sometimes, you’re in Kankuru and you want to check something in SSMS. I do it almost everyday ! And in SSMS I always forg …

What is the State of My Transparent Data Encrypted Database?

Publié le 19 mars 2018 sur sqlservercentral.com
 

When using Transparent Data Encryption, you might wonder “What is the state of my transparent data encrypted database?” Read on to learn the many different states that a transparent data encrypted database might go through.

Set-Based String Splitting table function

Publié le 19 mars 2018 sur sqlservercentral.com
 

Describe and provide a set-based method that takes a multiple character split term and returns as a table How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find …

Masking Dates in a Non-Production Database

Publié le 19 mars 2018 sur sqlservercentral.com
 

All too often there’s a reluctance to use masked data since it’s perceived to be just X’s and N’s and therefore not useable. That’s not the case if you use Redgate’s Data Masker tool.

SQL SERVER – How to Download SQL Server Native Client?

Publié le 19 mars 2018 sur journey to sqlauthority
 

Many times, there are some strange requests which I heard from my clients. I try to help my client with the answers and write a blog so that others can find the answers easily. Let us learn about SQL Server Native Client today. Question: How to downloa …

[Video] Office Hours 2018/3/17 (With Transcriptions)

Publié le 18 mars 2018 sur brentozar.com
 

This week, Brent, Tara, and Richie discuss VLF issues, SSAS tabular performance support, certification tests, query documentation tools, what to do when the executive team doesn’t value your contribution as a DBA, and more. Here’s the video …

How to Find SQL Server Deprecated Features Used by the Application? – Interview Question of the Week #165

Publié le 18 mars 2018 sur journey to sqlauthority
 

There are many applications which are developed using an older version of SQL Server. As there are new releases happening, there are features, command, and syntax which are marked as deprecated features and might get removed in future version of SQL Se …

PASS Marathon GDPR Edition: Recordings now available!

Publié le 17 mars 2018 sur sqlblog.com
 

You have certainly already heard about the new European Regulation 679/2016, better known as GDPR, on the protection of personal data. GDPR is the acronym of General Data Protection Regulation, companies and professionals are required, by May 25 ( …

Azure SQL DB Managed Instances: Transactional Replication

Publié le 17 mars 2018 sur brentozar.com
 

I knew Brent and Erik wouldn’t touch replication, so I figured I’d give it a whirl. My good, old friend replication I have a love-hate relationship with replication. Mostly hate due to latency and errors, but it does serve its purpose. Befo …


Pages :