Meet Claude, the new AIIntroduction to Claude This time we will meet Claude, a new AI technology. Previously, we talk about ChatGPT, […] 26 février 2024 dans Sites anglophones étiqueté AI / Artificial Intelligence (AI) / Claude par sqlservercentral.com
Upgrade SQL Server on your workstationLately, I’ve seen many people struggling to upgrade their workstation to the latest version of SQL Server. […] 26 février 2024 dans Sites anglophones étiqueté Database Administration / Homepage par simple-talk.com
[Video] Office Hours: Hot Tub EditionToday’s Office Hours comes from a very different office! I climbed into the hot tub to review your […] 23 février 2024 dans Sites anglophones étiqueté Videos par brentozar.com
What Every DBA Should Know about Always On Readable SecondariesThis article aims to demonstrate the lesser-known impact of Always On Readable secondaries. In this article, we will […] 23 février 2024 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
Redgate Summit: The Database LandscapeThe post Redgate Summit: The Database Landscape appeared first on SQLServerCentral. 23 février 2024 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
Query Exercise: Find Recent SuperstarsFor this week’s Query Exercise, we’re working with the Stack Overflow database, and our business users have asked […] 22 février 2024 dans Sites anglophones étiqueté Query Exercises par brentozar.com
Finding Long Values Faster: Answers & DiscussionIn last week’s Query Exercise, our developers had a query that wasn’t going as fast as they’d like: […] 21 février 2024 dans Sites anglophones étiqueté Query Exercise Answers par brentozar.com
Dynamically Create Tables in Power BI with DAX FunctionsThe post Dynamically Create Tables in Power BI with DAX Functions appeared first on SQLServerCentral. 21 février 2024 dans Sites anglophones étiqueté DAX / Power BI par sqlservercentral.com
Forget the Models, Your Data is the Secret Sauce for ...Credit: Image generated by Google Bard Generative AI (GenAI) models like GPT, Gemini, PaLM, DALL-E, and others offer […] 21 février 2024 dans Sites anglophones étiqueté Artificial Intelligence (AI) / Automation / Database / embeddings / generative ai / LLM / Machine Learning / Machine Learning (ML) / SQL Prompt / vector databases par sqlservercentral.com
#TSQL2sday Roundup: The Most Recent Issues You Closed.For this month’s TSQLTuesday, I asked y’all to describe the most recent issues you closed. If you ask […] 20 février 2024 dans Sites anglophones étiqueté development par brentozar.com
Database Feature TogglesIn software development the concept of feature toggles are used to selectively turn on and off features. […] 19 février 2024 dans Sites anglophones étiqueté Homepage / Software Delivery par simple-talk.com
Tutorial: Using the hierarchyid Data TypeThe post Tutorial: Using the hierarchyid Data Type appeared first on SQLServerCentral. 19 février 2024 dans Sites anglophones étiqueté HierarchyID par sqlservercentral.com
[Video] Office Hours: Ask Me Anything About Microsoft DatabasesPost your database questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss on the […] 16 février 2024 dans Sites anglophones étiqueté Videos par brentozar.com
JQ – Tool for Querying JSON documents using the CLIIn my role as a Data Engineer, I have an ever-increasing need for Querying JSON documents using the […] 16 février 2024 dans Sites anglophones étiqueté JSON par sqlservercentral.com
Functions and Procedures: Learning PostgreSQL with GrantOne of the most useful constructs in SQL Server is the stored procedure. It gives you a […] 15 février 2024 dans Sites anglophones étiqueté Homepage / PlanetPostgreSQLGrantFritchey / PostGreSQL par simple-talk.com
Query Exercise: Finding Long Values FasterOur developers have come to us with a problem query that isn’t as fast as they’d like. Using […] 15 février 2024 dans Sites anglophones étiqueté Query Exercises par brentozar.com
Improving Cardinality Estimation: Answers & DiscussionYour challenge for last week was to take this Stack Overflow database query to show the top-ranking users […] 14 février 2024 dans Sites anglophones étiqueté Query Exercise Answers par brentozar.com
Attention SQLBits 2024 Attendees!Get ready to soar into SQLBits 2024 with us in Farnborough, UK March 19th – 23rd! Join keynote […] 14 février 2024 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
Scientific Calculations in Power BI – Cube, Square, Logarithms, Powers, ...The post Scientific Calculations in Power BI – Cube, Square, Logarithms, Powers, Inverse and more appeared first on […] 14 février 2024 dans Sites anglophones étiqueté Power BI par sqlservercentral.com
The Last Ticket/Issue I Closed #TSQL2sdayFor this month’s T-SQL Tuesday, I asked y’all to write about the most recent ticket or issue that […] 13 février 2024 dans Sites anglophones étiqueté t-sql par brentozar.com
SQL ConstantCare® Population Report: Winter 2023The short story: SQL Server 2019 continues its utter domination of the Microsoft data platform landscape this quarter. […] 12 février 2024 dans Sites anglophones étiqueté SQL Server par brentozar.com
Leave it better than you found itThis is for the folks who still have to log into remote machines and do work manually […] 12 février 2024 dans Sites anglophones étiqueté Database Administration / Homepage par simple-talk.com
Writing SQL Server code with AI using GitHub CopilotIntroduction In this article, we will see how to work with GitHub Copilot. GitHub copilot is an interesting […] 12 février 2024 dans Sites anglophones étiqueté AI / Artificial Intelligence (AI) / Copilot / GitHub / t-sql par sqlservercentral.com
Planning a Database Testing Strategy for FlywayThe post Planning a Database Testing Strategy for Flyway appeared first on SQLServerCentral. 12 février 2024 dans Sites anglophones étiqueté database testing / flyway / software testing / Testing par sqlservercentral.com
Automating BCP with PowerShellI was talking with a good friend that has an environment with terabytes of information and to […] 9 février 2024 dans Sites anglophones étiqueté Homepage / PowerShell par simple-talk.com
[Video] Office Hours: Lumberjack EditionOn a chilly January day, I went through your top-voted questions from https://pollgab.com/room/brento. Yes, it actually gets cold […] 9 février 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Fun with PowershellThe post Fun with Powershell appeared first on SQLServerCentral. 9 février 2024 dans Sites anglophones étiqueté PowerShell par sqlservercentral.com
Use a Table Variable for Logging Entries that Need to ...Introduction Table variables are special types of local variables that can be used to store data temporarily, similar […] 9 février 2024 dans Sites anglophones étiqueté t-sql par sqlservercentral.com
LangChain Prompt Templates with OpenAI LLMsThe post LangChain Prompt Templates with OpenAI LLMs appeared first on SQLServerCentral. 9 février 2024 dans Sites anglophones étiqueté Artificial Intelligence (AI) / Databricks par sqlservercentral.com
Query Exercise: Improving Cardinality EstimationYour challenge for this week is to tune a query. Say Stack Overflow has a dashboard that shows […] 8 février 2024 dans Sites anglophones étiqueté Query Exercises par brentozar.com
Database Changes to Find Tagged Questions Faster: Answers and DiscussionIn the last Query Exercise discussion, we hit a performance wall when we were trying to quickly find […] 7 février 2024 dans Sites anglophones étiqueté Query Exercise Answers par brentozar.com
Dimensional Modeling Case Study Part 2 – Days DimensionIntroduction In our second case study on dimensional modelling, we delve into the intricacies of managing time-related dimensions, […] 7 février 2024 dans Sites anglophones étiqueté Data Warehousing / database modelling par sqlservercentral.com
#TSQL2sday Invitation: Describe the Most Recent Issue You Closed.T-SQL Tuesday is a monthly blogothon where we get together and write about a different topic. I’m hosting […] 6 février 2024 dans Sites anglophones étiqueté Professional Development par brentozar.com
Resolving the MERGE statement attempted to UPDATE or DELETE the ...The post Resolving the MERGE statement attempted to UPDATE or DELETE the same row more than once error […] 5 février 2024 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
Announcing the first Microsoft Fabric Community Conference!We are excited to welcome attendees to the 1st Microsoft Fabric Community Conference (previously known as the Data […] 5 février 2024 dans Sites anglophones étiqueté Conferences, Classes, Events, and Webinars / Microsoft Fabric (Azure Synapse, Data Engineering, etc.) par sqlservercentral.com
Fixing the Synapse Error « Available workspace capacity exceeded error (Livy ...If you are working with Notebooks in Azure Synapse Analytics and multiple people are using the same Spark […] 5 février 2024 dans Sites anglophones étiqueté ADS notebooks / Apache Spark / Azure Synapse Analytics / Livy Session / Microsoft Fabric (Azure Synapse, Data Engineering, etc.) / Spark / Spark SQL par sqlservercentral.com
Deploying Azure SQL Database Using an ARM TemplateProvisioning infrastructure in a timely and reliable manner is essential for agile development. One well-liked method that lets […] 2 février 2024 dans Sites anglophones étiqueté Administration / ARM template / Azure / Azure SQL / Azure SQL Database / Azure SQL Managed Instance / azure sql server / SQL Database / t-sql / TEMPLATE par sqlservercentral.com
Adding an AI Policy for AuthorsIn the last few months, we’ve noticed quite a bit of content submitted that seems overly structured in […] 2 février 2024 dans Sites anglophones étiqueté SQLServerCentral par sqlservercentral.com
Office Hours: PowerBI & Fabric Q&A with Eugene MeidingerToday’s Office Hours has a different topic. Eugene Meidinger dropped by to answer your business intelligence questions. Follow […] 1 février 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Who’s Hiring in the Microsoft Data Platform Community? February 2024 ...Is your company hiring for a database position as of February 2024? Do you wanna work with the […] 1 février 2024 dans Sites anglophones étiqueté Who's Hiring par brentozar.com
Feature Flags in Data ProjectsMy motivation for writing this summary was an interaction with a project owner that didn’t understand why […] 1 février 2024 dans Sites anglophones étiqueté ADF / Blogs / CI/CD / Feature Flags / Power BI / SSIS / SSRS par simple-talk.com
Finding Tagged Questions Faster: Answers & DiscussionYour query exercise was to take this Stack Overflow query to find the top-voted questions for any given […] 31 janvier 2024 dans Sites anglophones étiqueté Query Exercise Answers par brentozar.com
Gracefully Handle Errors using TRY CATCH Logic in SQL Server ...The post Gracefully Handle Errors using TRY CATCH Logic in SQL Server Stored Procedures appeared first on SQLServerCentral. 31 janvier 2024 dans Sites anglophones étiqueté Error Handling / t-sql / TRY..CATCH par sqlservercentral.com
Install SSMS using Powershell DSCIntroduction In the previous article, we have seen how to install the SQL Server database engine using Powershell […] 31 janvier 2024 dans Sites anglophones étiqueté Management Studio (SSMS) / PowerShell par sqlservercentral.com
Free Video Training: Estimation and Statistics by Dave BallantyneIt’s hard to find good 400-500 level SQL Server training at any price, let alone free. Dave Ballantyne’s […] 30 janvier 2024 dans Sites anglophones étiqueté statistics / Videos par brentozar.com
Lancement de la chaine YouTube Data ChouetteNous avons démarré une nouvelle chaîne YouTube pour les passionnés de données : https://www.youtube.com/@DataChouette Apprenez, explorez et […] 29 janvier 2024 dans Business Intelligence / Sites anglophones étiqueté CSA / DataChouette / Microsoft Fabric / youtube par www.pulsweb.fr
Server Dashboards in Azure Data StudioAzure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles […] 29 janvier 2024 dans Sites anglophones étiqueté Tools for development par sqlservercentral.com
Adding a new AI usage policy to Simple-TalkI used to think plagiarism was my worst thing to deal with as an editor. That is […] 26 janvier 2024 dans Sites anglophones étiqueté Blogs par simple-talk.com
What PowerBI Questions Do You Have for Eugene Meidinger?Eugene Meidinger, aka SQLGene.com, makes Power BI concepts easy and accessible. He’s got a free introduction to Power […] 26 janvier 2024 dans Sites anglophones étiqueté Data Science par brentozar.com
State of the Database Landscape 2024: Shifting skills to match ...The post State of the Database Landscape 2024: Shifting skills to match constant demands appeared first on SQLServerCentral. 26 janvier 2024 dans Sites anglophones étiqueté Career Growth par sqlservercentral.com