Sites anglophones


Using Triggers to Replace Scalar UDFs on Computed Columns

Publié le 20 octobre 2020 sur brentozar.com
 

Your database is riddled with computed columns whose definition includes a scalar user-defined function. Even up to & including SQL Server 2019, which boasts faster scalar function processing, any table that includes a scalar function cause all acc …

Great Power(Shell)…Great Responsibility

Publié le 20 octobre 2020 sur sqlservercentral.com
 

Whenever I’m spreading PowerShell love (here with you mainly in the form of dbatools), now and then I try to remind people that this is so powerful for the good, but also for the bad stuff. Normally I say « Now, the good work can scale…however, rememb …

The Curious Case of… resolving call stack symbols on SQL Server 2019

Publié le 19 octobre 2020 sur sqlskills.com - paul randall
 

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …

Latches and spinlocks whitepapers have moved

Publié le 19 octobre 2020 sur sqlskills.com - paul randall
 

Last month I was looking for the spinlocks whitepaper and discovered that both it and the latches whitepaper had disappeared from the Microsoft website. I contacted my good friend Pedro Lopes in the Product Group and he arranged for them to be integrat …

Exploring errors to reveal unauthorized information

Publié le 19 octobre 2020 sur simple-talk.com
 

Maintaining a secure environment is very hard. There are so many threats that can be exploited that it demands a specialized security team to continuously evaluate, monitor, and audit the many known and unknown threats. SQL Server is just another proce …

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 …


Pages :