Sites anglophones


I’m on the KasperOnBI Podcast Talking About Careers and the Future of SQL Server

Publié le 13 mai 2021 sur brentozar.com
 

I sat down with Microsoft’s Kasper de Jonge this month for an hour-long conversation about how I got started speaking, careers, and the future of SQL Server: You can also listen on Spotify and Apple Podcasts. In the podcast, we talk about my Epic …

Conditional DELETE and INSERT in PostgreSQL

Publié le 12 mai 2021 sur sqlservercentral.com
 

Introduction We are comfortable with inserting/deleting record(s) into/from a table. But we sometimes get confused when we need to insert or delete records conditionally from a table. Let us look at an example. Example scenario Suppose we have a table, …

Automating Azure DevOps with Logic Apps

Publié le 12 mai 2021 sur sqlservercentral.com
 

The post Automating Azure DevOps with Logic Apps appeared first on SQLServerCentral.

Take our survey to win a $500 Amazon gift card

Publié le 12 mai 2021 sur sqlservercentral.com
 

The post Take our survey to win a $500 Amazon gift card appeared first on SQLServerCentral.

 

Oracle Sequences: RAC

Publié le 11 mai 2021 sur simple-talk.com
 

The series so far: Oracle sequences: The basics Oracle sequences: RAC In my first article on Sequences, I reviewed the fundamental reason why Oracle Corp. introduced the mechanism (i.e. synthetic/surrogate keys) and the mechanical threats (cache size a …

 

Free Video: Deadlocks: Let’s Do One, Understand It, and Fix It

Publié le 11 mai 2021 sur brentozar.com
 

You keep getting warnings and emails about deadlocks, but let’s be honest: you’re not really sure how they happen or what to do about it. In this one-hour session from the SQLBits conference, I will show one, use sp_BlitzLock to analyze it, …

SQL Server Sequence Numbers

Publié le 10 mai 2021 sur sqlservercentral.com
 

The post SQL Server Sequence Numbers appeared first on SQLServerCentral.

Understanding CRUD Operations on Tables with B-tree Indexes, Page-splits, and Fragmentation

Publié le 10 mai 2021 sur sqlservercentral.com
 

Introduction Every DML transaction reads the data before it makes any changes. Not only during a SELECT query, but when you run any DML statement, insert, update, or delete, SQL Server first fetches a bunch of pages into the buffer pool locating the de …

Running Dynamic Code Quality Checks on Flyway Databases: Table Smells

Publié le 10 mai 2021 sur sqlservercentral.com
 

The post Running Dynamic Code Quality Checks on Flyway Databases: Table Smells appeared first on SQLServerCentral.

DevOps as a bludgeon

Publié le 7 mai 2021 sur sqlservercentral.com
 

The post DevOps as a bludgeon appeared first on SQLServerCentral.

Getting Started with MLflow in Azure Databricks

Publié le 7 mai 2021 sur sqlservercentral.com
 

The post Getting Started with MLflow in Azure Databricks appeared first on SQLServerCentral.

What’s the Buggiest Feature in SQL Server?

Publié le 6 mai 2021 sur brentozar.com
 

Not the one you like the least, or the one that requires the most work. What’s the one that you can’t use because it’s just flat out busted? For me, it’s SSMS’s Live Query Statistics, aka live query plans. The idea is …

You are cordially invited to attend 2021 Virtual Data.SQL.Saturday.LA event!

Publié le 5 mai 2021 sur sqlservercentral.com
 

The post You are cordially invited to attend 2021 Virtual Data.SQL.Saturday.LA event! appeared first on SQLServerCentral.

Insurance price prediction using Machine Learning (ML.NET)

Publié le 5 mai 2021 sur sqlservercentral.com
 

The post Insurance price prediction using Machine Learning (ML.NET) appeared first on SQLServerCentral.

Finding Dependencies in SQL Server Databases using SQL Dependency Tracker

Publié le 5 mai 2021 sur sqlservercentral.com
 

The post Finding Dependencies in SQL Server Databases using SQL Dependency Tracker appeared first on SQLServerCentral.


Pages :