Sites anglophones


 

Database Feature Toggles

Publié le 19 février 2024 sur simple-talk.com
 

In software development the concept of feature toggles are used to selectively turn on and off features. They are, for example, used to restrict some newly introduced features to a select group to see how these features work. While this concept has bee …

 

Tutorial: Using the hierarchyid Data Type

Publié le 19 février 2024 sur sqlservercentral.com
 

The post Tutorial: Using the hierarchyid Data Type appeared first on SQLServerCentral.

[Video] Office Hours: Ask Me Anything About Microsoft Databases

Publié le 16 février 2024 sur brentozar.com
 

Post your database questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss on the stream. If you’d like to be alerted when I live stream these, follow me on Twitch. Here’s what we discussed today: …

JQ – Tool for Querying JSON documents using the CLI

Publié le 16 février 2024 sur sqlservercentral.com
 

In my role as a Data Engineer, I have an ever-increasing need for Querying JSON documents using the CLI (command line interface) in these ways: Filtering the output from a cloud CLI to just the useful information Extracting the output from an API Evalu …

 

Functions and Procedures: Learning PostgreSQL with Grant

Publié le 15 février 2024 sur simple-talk.com
 

One of the most useful constructs in SQL Server is the stored procedure. It gives you a way to do several things. First up, you can store code within the database. Next, you can parameterize queries so that you’re not hard coding or generating ad …

 

Query Exercise: Finding Long Values Faster

Publié le 15 février 2024 sur brentozar.com
 

Our developers have come to us with a problem query that isn’t as fast as they’d like. Using any Stack Overflow database:CREATE INDEX DisplayName ON dbo.Users(DisplayName); GO SELECT * FROM dbo.Users WHERE LEN(DisplayName) > 35; It has a …

Improving Cardinality Estimation: Answers & Discussion

Publié le 14 février 2024 sur brentozar.com
 

Your challenge for last week was to take this Stack Overflow database query to show the top-ranking users in the most popular location:CREATE INDEX Location ON dbo.Users(Location); GO CREATE OR ALTER PROC dbo.GetTopUsersInTopLocation AS SELECT TOP 200 …

Attention SQLBits 2024 Attendees!

Publié le 14 février 2024 sur sqlservercentral.com
 

Get ready to soar into SQLBits 2024 with us in Farnborough, UK March 19th – 23rd! Join keynote speaker, Asad Khan, General Manager of SQL, along with leading SQL experts from Microsoft including, Bob Ward, Rie Merrit, Buck Woody, Muazma Zahid, and Erin …

Scientific Calculations in Power BI – Cube, Square, Logarithms, Powers, Inverse and more

Publié le 14 février 2024 sur sqlservercentral.com
 

The post Scientific Calculations in Power BI – Cube, Square, Logarithms, Powers, Inverse and more appeared first on SQLServerCentral.

The Last Ticket/Issue I Closed #TSQL2sday

Publié le 13 février 2024 sur brentozar.com
 

For this month’s T-SQL Tuesday, I asked y’all to write about the most recent ticket or issue that you closed. (If you want to see other peoples’ posts, you can check out the comments on that invite post, or wait til next week and I …

SQL ConstantCare® Population Report: Winter 2023

Publié le 12 février 2024 sur brentozar.com
 

The short story: SQL Server 2019 continues its utter domination of the Microsoft data platform landscape this quarter. The long story: ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adop …

 

Leave it better than you found it

Publié le 12 février 2024 sur simple-talk.com
 

This is for the folks who still have to log into remote machines and do work manually on the box. Yes, we still exist, and we will for as long as we’re still using physical servers in data centers and even IaaS. Not everyone has transitioned to s …

 

Writing SQL Server code with AI using GitHub Copilot

Publié le 12 février 2024 sur sqlservercentral.com
 

Introduction In this article, we will see how to work with GitHub Copilot. GitHub copilot is an interesting plug-in that generates code using AI. The technology is from Microsoft and OpenAI. We will show how to install Copilot, and how to generate SQL …

Planning a Database Testing Strategy for Flyway

Publié le 12 février 2024 sur sqlservercentral.com
 

The post Planning a Database Testing Strategy for Flyway appeared first on SQLServerCentral.

 

Automating BCP with PowerShell

Publié le 9 février 2024 sur simple-talk.com
 

I was talking with a good friend that has an environment with terabytes of information and to create a homolog or dev environment to him is a pain. He comes to me with a solution : A PowerShell script that gets only the first 1000 lines of each table, …

 


Pages :