Sites anglophones


Kafka Integration with HDInsight

Publié le 9 mai 2018 sur sqlservercentral.com
 

Microsoft HDInsight is the cloud service that deploys and provisions Hadoop clusters on the Azure cloud. It’s a completely managed, open source analytics service to support enterprise needs and supports a wide variety of scenarios with the help of open …

Azure – Which One to Get – Standard Disks or Premium Disks

Publié le 9 mai 2018 sur journey to sqlauthority
 

During Comprehensive Database Performance Health Check, I have recently a very interesting experience with an Azure. In this blog post, we will discuss which disks are preferred for performance – Standard Disks or Premium Disks. Well, honest …

The DeWitt Clause: Why You Rarely See Database Benchmarks

Publié le 8 mai 2018 sur brentozar.com
 

Back in the early 1980s, Dr. David DeWitt – who you might know from past PASS Summit keynotes, formerly of Microsoft (LinkedIn) – was working on measuring database performance. His team wrote a benchmark, ran it against Oracle, and Oracle d …

utPLSQL 3.0 – How To Have Your Cake and Eat It

Publié le 8 mai 2018 sur simple-talk.com
 

This article was originally published on mikesmithers.wordpress.com. “You can’t have your cake and eat it!” This seems to be a regular refrain from the EU in the ongoing Brexit negotiations. The also seem to be a bit intolerant o …

Join the leading experts in data governance and SQL Server at Redgate’s SQL Privacy Summit

Publié le 8 mai 2018 sur sqlservercentral.com
 

The GDPR is almost here and, just one week before it’s launch, Redgate is hosting the first SQL Privacy Summit in London. The schedule of presentations, panel discussions and workshops has been created to help SQL Server professionals ensure thei …

SQL Server From .Net: Connecting Visual Studio Community Edition to SQ

Publié le 8 mai 2018 sur sqlservercentral.com
 

This is a short description of how to connect the free Visual Studio Community Edition to the free SQL Server Express edititon.

SQL Server From .Net: Connecting Visual Studio Community Edition

Publié le 8 mai 2018 sur sqlservercentral.com
 

This is a short description of how to connect the free Visual Studio Community Edition to the free SQL Server Express edititon.

SQL SERVER – How to Find Free Log Space in SQL Server?

Publié le 8 mai 2018 sur journey to sqlauthority
 

One of the most popular question on this blog is about how to shrink the log file. I have previously written about that subject on the following blogs. However, today we are not going to talk about Shrinking the log file but rather going to talk a …

When Query Plans Lie Part 1

Publié le 7 mai 2018 sur brentozar.com
 

Freaking Out Brent Is a full time job. Some days I can get him to hit the desk drawer tequila, and other days I crash and burn. This day was so monumental I almost hired someone to do an action movie narration of this blog post. Let’s Start Easy …

Availability Groups Bug with Indexed Views

Publié le 7 mai 2018 sur brentozar.com
 

The short story: if you drop an index on an indexed view, queries on the Always On Availability Groups replicas that point to that indexed view will cause memory dumps. The long story: to reproduce – AND DO NOT DO THIS IN PRODUCTION – on th …

So what is data mapping and why is it the key to GDPR compliance?

Publié le 7 mai 2018 sur sqlservercentral.com
 

The GDPR brings new responsibilities for organizations which need to store and process personal data. Plan for it in the right way, however, and the journey to compliance will be a lot easier.

Friday the 13th

Publié le 7 mai 2018 sur sqlservercentral.com
 

Looking forward to the next few ones of these scary days?

SQL SERVER – Restore Database Wizard in SSMS is Very Slow to Open

Publié le 7 mai 2018 sur journey to sqlauthority
 

Recently I was hired for my On Demand (55 minutes) Service by an organization and they had a very interesting situation. To be very honest, I was initially lost for few moments when they described this situation to me and wanted me to solve their …

How to Search Special Characters in Table Column? – Interview Question of the Week #172

Publié le 6 mai 2018 sur journey to sqlauthority
 

Question: How to Search Special Characters in Table Column? Answer: This is a very interesting question and lets us discuss the same today. However, before you try out the solution in this blog post, I would suggest you check with other members in your …

SQL Server – Performance Comparison of Function Trim and LTRIM(RTRIM)

Publié le 5 mai 2018 sur journey to sqlauthority
 

While delivering SQL Server Performance Tuning Practical Workshop I recently received a question which is related to performance comparison of Function Trim and LTRIM/RTRIM. Regarding the trim function, I have previously blogged in the follow …


Pages :