Sites anglophones


 

Writing your 2024 PASS Data Community Summit Submission

Publié le 5 mars 2024 sur simple-talk.com
 

It is time again for the PASS Data Community Summit Call For Speakers. Some of you are very ready. You have a presentation idea that has percolated since at least last October. You have asked friends and coworkers if it is a good idea. You may have pre …

 

[Video] Office Hours From the Future

Publié le 5 mars 2024 sur brentozar.com
 

To answer today’s questions from https://pollgab.com/room/brento, I strapped on my Apple Vision Pro and recorded my persona as if we were on a FaceTime or Zoom call together. It’s delightfully creepy, as if I’m AI Brent from the Futur …

 

Serverless Authentication methods in web apps.

Publié le 5 mars 2024 sur simple-talk.com
 

Serverless authentication methods refer to approaches for managing user identity and access without the need for traditional server-based authentication systems. Instead of relying on a dedicated server, authentication tasks are outsourced to cloud-bas …

 

Read This Before Your Users Install SSMS 20

Publié le 4 mars 2024 sur brentozar.com
 

SQL Server Management Studio 20 Preview 1 is out, and the new connection dialog has a big change: When you click Connect, you’re likely going to get an error: The fastest fix is to click the Encryption dropdown, and change it to Optional: And the …

Dynamically Move Multiple Tables in Bulk using Azure Data Factory ForEach and Lookup Activities

Publié le 4 mars 2024 sur sqlservercentral.com
 

The post Dynamically Move Multiple Tables in Bulk using Azure Data Factory ForEach and Lookup Activities appeared first on SQLServerCentral.

 

The Value of Conference Speaking

Publié le 4 mars 2024 sur simple-talk.com
 

Editor note: The call for speakers is open at on the Pass Data Community Summit 2024 Site, so join Jason in throwing your hat into the ring for this year’s Summit coming up in Seattle November 4-8! My Power BI Speaking Tour: This is the Way Over …

 

Evolving Role of Data Professionals in Artificial Intelligence Era

Publié le 4 mars 2024 sur sqlservercentral.com
 

This image is generated by Google Gemini Introduction The way we work is about to change drastically. Generative AI tools like Gemini, ChatGPT and their underlying large language models (LLMs) have reached unprecedented levels of sophistication. From m …

 

Building MongoDB Aggregations

Publié le 1 mars 2024 sur simple-talk.com
 

This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the items in the series, click here. In the previous article in this series, I discussed how to use a find statement to retrieve data from a MongoDB collection. Howev …

 

Updated First Responder Kit and Consultant Toolkit for February 2024

Publié le 1 mars 2024 sur brentozar.com
 

New this month: better sp_BlitzIndex performance on databases with tens of thousands of objects, sp_DatabaseRestore can run test scripts, and David Wiseman and Sean Killeen implemented basic automated testing for the First Responder Kit. Wanna watch me …

 

Friendly Deletes in SQL Server

Publié le 1 mars 2024 sur simple-talk.com
 

One of the first things you learn when working with SQL Server, and other transactional based SQL systems, is that set based operations perform best. If you are querying data, a cursor pulling individual rows doesn’t perform as well as a single q …

 

Live webinar: How to excel at managing multiple database platforms

Publié le 1 mars 2024 sur sqlservercentral.com
 

The use of multiple database platforms is on the rise, however, managing them can be challenging, with issues such as data integration, monitoring and a requirement for greater skill diversity. So how can you thrive in this environment? Join industry e …

A Few Best Practices for Strong SQL Server Security

Publié le 1 mars 2024 sur sqlservercentral.com
 

Databases serve as the critical infrastructure for numerous applications. They safeguard essential data that fuels both business operations and strategic decision-making. Given the significance of this role, safeguarding your database is a top priority …

Query Exercise: Finding Sister Locations to Help Each Other

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

For this week’s query exercise, let’s start with a brief query to get a quick preview of what we’re dealing with:SELECT TOP 100 Location, COUNT(*) AS Population, AVG(Reputation) AS AvgReputation FROM dbo.Users GROUP BY Location ORDER …

 

Find and Replace Text in Strings in T-SQL

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

String manipulation is an inevitable task for developers and data professionals alike. Despite all the best efforts to normalize databases, eventually we are faced with some sort of text-based data stored within a relational database and need to extrac …

 

Find Recent Superstars: Answers & Discussion

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

Your query exercise for this week was to write a query to find users created in the last 90 days, with a reputation higher than 50 points, from highest reputation to lowest. Because everyone’s Stack Overflow database might be slightly different, …


Pages :