Sites anglophones


Orchestrating Azure Databricks Notebooks with Azure Data Factory

Publié le 19 octobre 2020 sur sqlservercentral.com
 

The post Orchestrating Azure Databricks Notebooks with Azure Data Factory appeared first on SQLServerCentral.

Connecting to SQL Server with MuleSoft AnyPoint 3.9

Publié le 19 octobre 2020 sur sqlservercentral.com
 

I usually write about SQL Server, but I thought I’d share my experience of using SQL Server from MuleESB. If you haven’t used Mule before, it’s an open-source ESB (enterprise service bus), which also has a paid-for Enterprise version. I’ve been using i …

How to Turn Off Query Store…in an emergency

Publié le 16 octobre 2020 sur SQLSkills.com - Erin Stellato
 

Have you ever tried to turn off Query Store when there was an issue, and you thought the problem might be related to Query Store, and the ALTER DATABASE statement was blocked?  And then you couldn’t do anything but wait?  Me too.  …

Building SQL ConstantCare®: What Database Growths Do You Care About?

Publié le 16 octobre 2020 sur brentozar.com
 

SQL ConstantCare® alerts you when your databases have unusual growths. No, not like that one on your neck. And you should really get that checked out. No, I’m talking about a database that suddenly jumps in size, making you suspicious about w …

Updated First Responder Kit and Consultant Toolkit for October 2020

Publié le 15 octobre 2020 sur brentozar.com
 

In preparation for this month’s new Fundamentals of Columnstore class, sp_BlitzIndex has a few cool new tricks! I’ll show you how to use ’em for free in the upcoming How I Use the First Responder Kit class, too. Columnstore indexes ar …

Getting Started with Gremlin

Publié le 15 octobre 2020 sur sqlservercentral.com
 

Apache TinkerPop is an open source graph computing framework. A graph computing network is a set of vertices and edges in the network. If we compare a graph database to traditional relational databases, we can assume that every row in a table of a rela …

Bringing Data Catalog into your CI/CD pipeline

Publié le 15 octobre 2020 sur sqlservercentral.com
 

The post Bringing Data Catalog into your CI/CD pipeline appeared first on SQLServerCentral.

Top 5 SSMS Time Saving Tips

Publié le 15 octobre 2020 sur sqlservercentral.com
 

The post Top 5 SSMS Time Saving Tips appeared first on SQLServerCentral.

Free Webcast on Thursday: Avoiding Deadlocks with Query Tuning

Publié le 14 octobre 2020 sur brentozar.com
 

To fix blocking & deadlocks, you have 3 tools: Have enough indexes to make your queries fast, but not so many that they slow down delete/update/insert operations. (I cover that in the Mastering Index Tuning class.) Use the right isolation level for …

Databases Are Like Walk-In Coolers. #tsql2sday

Publié le 13 octobre 2020 sur brentozar.com
 

In the back of a restaurant, there’s a walk-in cooler (or a few of ’em.) When a chef needs to make something, she goes into the walk-in cooler, gathers the necessary ingredients, and then comes out to the kitchen to do the cooking. She does …

Free Live Fundamentals Classes, Registration Open Now

Publié le 12 octobre 2020 sur brentozar.com
 

Well, this quarantine just isn’t letting up, so it’s time for another round of free training. I’m running 3 free live classes on October 26-28: October 26: Fundamentals of Index Tuning – 9AM-5 Eastern – …

Automate MSBI deployments Using PowerShell

Publié le 10 octobre 2020 sur sqlservercentral.com
 

Microsoft BI tools are widely used in Business Intelligence (BI) projects nowadays due to their end to end BI capabilities and lower licensing costs. We work in an agile world where the application teams are making use of various tools, like Jenkins, t …

Woohoo! We Hit 25,000 YouTube Subscribers.

Publié le 10 octobre 2020 sur brentozar.com
 

As I finished this weekend’s live stream, I noticed that we crossed a big number. The Brent Ozar Unlimited YouTube channel now has over 25,000 subscribers. Well, that’s kinda awesome. I’ve had a great time doing all kinds of free live …

ALTER Procedures When Using Query Store

Publié le 8 octobre 2020 sur SQLSkills.com - Erin Stellato
 

When I talk about Plan Forcing I always discuss how users should ALTER procedures when using Query Store, and not use DROP and CREATE. This is valid beyond Plan Forcing cases; it’s a best practice I recommend however you are using Query Store. Ev …

What Is the SQL Server CEIP Service?

Publié le 8 octobre 2020 sur brentozar.com
 

The CEIP Service is the Customer Experience Improvement Program that sends telemetry data back to Microsoft. When you install Microsoft SQL Server, the CEIP Service is installed too. You can’t disable it during installation: it shows up in your s …


Pages :