Sites anglophones


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

Publié le 26 novembre 2018 sur sqlservercentral.com
 

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 simple-talk.com
 

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 brentozar.com
 

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 sqlservercentral.com
 

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

SQL SERVER – Finding User Who Dropped Database Table

Publié le 23 novembre 2018 sur journey to sqlauthority
 

Though I mainly focus on SQL Server Performance Tuning as my primary consulting engagement, there are moments when I am asked questions from my regular clients which are not related to SQL Server Performance and they still expect me to answer. I think …

Congratulations to the Scholarship Class of 2019.

Publié le 22 novembre 2018 sur brentozar.com
 

To celebrate the holiday season each year, we give back to those who spend the entire year giving back in their own communities. We go looking for data professionals who make a difference, and we try to make a difference in their lives too. This year, …

Feedback of #PASSSummit 2018 for My Performance Tuning Sessions

Publié le 22 novembre 2018 sur journey to sqlauthority
 

Earlier this month, I had an opportunity to present on SQL Server Performance Tuning at the largest gathering of the SQL Server Professionals in Seattle. I was fortunate to present a day-long pre-conference training and 75 conference sessions. I was tr …

A Lot of Your SQL Servers Are Unsupported.

Publié le 21 novembre 2018 sur brentozar.com
 

I’m almost afraid to look into the SQL ConstantCare® client base to see the answer to this, but let’s put on a pair of rubber gloves and go find out. SQL Server 2016: <1% out of support. I LOVE YOU PEOPLE. However, you’ve had t …

Executing Integration Services Packages in the Azure-SSIS Integration Runtime

Publié le 21 novembre 2018 sur sqlservercentral.com
 

n this tip we will explain how you can deploy, execute and schedule SSIS packages in the Azure cloud.

Azure Data Studio Takes SQL Operations Studio to the Next Level

Publié le 21 novembre 2018 sur sqlmag.com
 

Microsoft seems to be closing the gap between Azure Data Studio and SQL Server Management Studio, making the former a viable alternative for developers and DBAs alike.

SQLBits 2019: Pre-Con – 21 Essential Scripts: Performance Tuning for EVERYONE

Publié le 21 novembre 2018 sur journey to sqlauthority
 

If you are going to go to SQLBits 2019, you want to come to my pre-con about 21 Essential Scripts: Performance Tuning for EVERYONE. This pre-con contains best of my material and goes beyond what you conventionally know about any topic. It is no-no …

Going to SQLBits in 2019? Come to my pre-con!

Publié le 20 novembre 2018 sur brentozar.com
 

My Favorite Conference I love SQLBits, and not just because it gets me out of the country for a week. It’s about the best conference a training buck can buy. There’s tons of great technical material without a lot of the marketing schtick th …


Pages :