Sites anglophones

Data Privacy – Are Your Database Processes Fully Compliant?

Publié le 28 novembre 2018 sur journey to sqlauthority

This year has been filled with data privacy and protection concerns. From the introduction of the General Data Protection Regulation (GDPR) and the exposure of data breaches at Cambridge Analytica, Facebook and Under Armour, to new legislation springin …

Getting Sneaky With Forced Parameterization

Publié le 27 novembre 2018 sur

Silly Rules I’ve blogged about some of the silly rules about where Forced Parameterization doesn’t work. One rule that really irked me is this one: The TOP, TABLESAMPLE, HAVING, GROUP BY, ORDER BY, OUTPUT…INTO, or FOR XML clause …

Converting Binary Numbers To Hex

Publié le 27 novembre 2018 sur

A short piece looking at how you might convert binary numbers into hexadecimal in T-SQL.

SQL Server Auditing for HIPAA and SOX – Part 4

Publié le 27 novembre 2018 sur

Regulations may require that you audit exactly who does what in your databases. Robert Sheldon explains how SQL Server can help you meet those requirements with its built-in auditing capabilities.

Cyber Monday special on 2019 live, online classes 6-pack – save $199 per class!

Publié le 27 novembre 2018 sur - paul randall

It’s Cyber Monday today, and now that you’ve finished picking up great deals for your personal life, how about a great deal for your professional life? From now through 12pm PST on Thursday, November 28th 2018, the first 25 people to regist …

SQL SERVER – 5061: FIX Error: ALTER DATABASE failed because a lock could not be placed on database ‘Database Name’. Try again later.

Publié le 27 novembre 2018 sur journey to sqlauthority

Every consulting engagement is different and I get to learn new things. In this blog post, I will share what I learned during my recent Comprehensive Database Performance Health Check. During health check to demonstrate one of the scenarios we had crea …

Not So Forced Parameterization

Publié le 26 novembre 2018 sur

Asking The Wrong Question Sometimes, when you wanna turn on a feature, you spend so much time wondering if you should, you don’t bother asking if it’ll even work when you do. There are a long list of things that are incompatible with Forced …

Monitoring Azure Health Status Using Azure Portal – Part 1

Publié le 26 novembre 2018 sur

In this tip we look at how you can monitor Azure health to know if there are any issues that may interupt your services running on Azure.

Data Migration Assistant tool for Azure SQL DB/Azure VM Assessment

Publié le 26 novembre 2018 sur

Data Migration Assistant (DMA) to Check for SQL Server Compatibility Issues and Perform assessment when Migrating to Azure SQL Database or to SQL Server on an Azure Virtual machine.

SQL SERVER – OLE DB Provider ‘Microsoft.ACE.OLEDB.12.0’ for Linked Server ‘(null)’ Returned Message ‘Unspecified Error’

Publié le 26 novembre 2018 sur journey to sqlauthority

There are many situations where you have to create a linked server to Microsoft Excel and read data from there. While doing that, I encountered an error and in this blog, we would discuss how to fix OLE DB provider ‘Microsoft.ACE.OLEDB.12.0 …

Transferring Data with JSON in SQL Server

Publié le 25 novembre 2018 sur

JSON has two distinct uses, to transmit data and to store it. They are best considered separately. When you use JSON to store data, you are generally forced down the route of using a special-purpose database, though SQL Server is happy to accommodate J …

[Video] Office Hours 2018/11/21 (With Transcriptions)

Publié le 25 novembre 2018 sur

This week, Brent, Tara, and Erik discuss update statistics, how soon it is safe to use a new version of SQL Server, VMs vs physical servers, backups, disabling TCP Chimney Offset in VMware, SQL Server on Linux, performance troubleshooting, most valuabl …

How to Grow All Files in a File Group Equally? – TRACE FLAG 1117 – Interview Question of the Week #201

Publié le 25 novembre 2018 sur journey to sqlauthority

Question: How to Grow All Files in a File Group Equally? Answer: If you are a regular reader of this blog, you would have read my earlier blog post writing about this subject over here: SQL Server 2016 – Introducing AutoGrow and Mixed_P …

SQL SERVER – Huge Size of SSISDB – Catalog Database SSISDB Cleanup Script

Publié le 24 novembre 2018 sur journey to sqlauthority

In recent past, while doing Comprehensive Database Performance Health Check I encountered an interesting issue. In this blog, I am sharing my knowledge about how to clean up the SSISDB database using the script. Before you try this, make sure you …

Soundex – Experiments with SQLCLR Part 3

Publié le 23 novembre 2018 sur

Acknowledging fundamental design flaws lead to a more flexible, maintainable phonetic framework

Pages :