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
Django's ORM vs. Raw SQL: When to Use WhichWhen it comes to building websites, how you work with your database can make a huge difference in […] 26 janvier 2024 dans Sites anglophones étiqueté Software Development par sqlservercentral.com
Top-Down and Bottom-Up Approaches in Microsoft FabricNikola Ilic, best known as Data Mozart, published a great article and video about how to make […] 25 janvier 2024 dans Sites anglophones étiqueté Azure / BI / Homepage / Microsoft Fabric / Power BI / Semantic Model par simple-talk.com
Query Exercise: Find Tagged Questions Faster.For this week’s Query Exercise, we’re going to start with an existing query that has performance problems from […] 25 janvier 2024 dans Sites anglophones étiqueté Query Exercises par brentozar.com
Finding the Best Time for Maintenance: Answers & DiscussionYour Query Exercise was to find the best time to do database maintenance by querying the Users table, […] 24 janvier 2024 dans Sites anglophones étiqueté Query Exercise Answers par brentozar.com
Code Visibility: Browsing through Flyway Migration FilesThe post Code Visibility: Browsing through Flyway Migration Files appeared first on SQLServerCentral. 24 janvier 2024 dans Sites anglophones étiqueté flyway par sqlservercentral.com
Save 5% on SQLBits Registration with BRENT5.Going to the SQLBits conference in March? Whether you’re registering in-person or attending virtually, save 5% on your […] 23 janvier 2024 dans Sites anglophones étiqueté SQLBits par brentozar.com
State of the Database Landscape Results 2024Every year, Redgate surveys technologists to ask a big question (through lots of little questions, naturally.) This […] 23 janvier 2024 dans Sites anglophones étiqueté Career / Databases / Homepage / stateofdatabaselandscapesurvey par simple-talk.com
Querying MongoDB DocumentsMongoDB provides an efficient environment for storing document data at scale. However, most of your interactions with […] 22 janvier 2024 dans Sites anglophones étiqueté Homepage / NoSQL par simple-talk.com
Understanding the Importance of Data Lineage in Modern Data ManagementThe post Understanding the Importance of Data Lineage in Modern Data Management appeared first on SQLServerCentral. 22 janvier 2024 dans Sites anglophones étiqueté data lineage / Master Data Management (MDM) par sqlservercentral.com
Configuration of Azure SQL Database AuditingEnhance the security, compliance, and monitoring capabilities of your database system with Azure SQL Database Auditing, a feature-rich […] 22 janvier 2024 dans Sites anglophones étiqueté azure database / azure database auditing / azure sql server / sql server auditing / Uncategorized par sqlservercentral.com
[Video] Office Hours: The Question is Not the Problem EditionI answer your top-voted Azure SQL DB and SQL Server questions from https://pollgab.com/room/brento and lose my temper about […] 19 janvier 2024 dans Sites anglophones étiqueté Videos par brentozar.com
The Importance of RetentionIt is always an afterthought. New objects are created that start off small and current. New feature […] 19 janvier 2024 dans Sites anglophones étiqueté Database Administration / Homepage / T-SQL Programming par simple-talk.com
Buy on-demand access for Summit 2023 todayThe post Buy on-demand access for Summit 2023 today appeared first on SQLServerCentral. 19 janvier 2024 dans Sites anglophones étiqueté Conferences, Classes, Events, and Webinars par sqlservercentral.com
Leveraging AI Tools for SQL QueriesSome of the many benefits that AI offers include task automation, increased productivity, and increased efficiency. As an […] 19 janvier 2024 dans Sites anglophones étiqueté Artificial Intelligence (AI) par sqlservercentral.com
Query Exercise: Find the Best Time for MaintenanceIf we’ve gotta take the database down for maintenance – perhaps a version upgrade, perhaps upgrading our own […] 18 janvier 2024 dans Sites anglophones étiqueté Query Exercises par brentozar.com
Find Posts with the Wrong CommentCount: Answers & DiscussionYour Query Exercise was to find denormalization accuracy problems: checking the accuracy of a reporting column, Posts.CommentCount. There […] 17 janvier 2024 dans Sites anglophones étiqueté Query Exercise Answers par brentozar.com
We’re Starting to Automate Testing for the First Responder Kit.Brent says: It’s really funny how the world works. I wrote what you see below in December 2023 […] 16 janvier 2024 dans Sites anglophones étiqueté First Responder Kit par brentozar.com
Working on Technology Off the ClockI have always spent time learning relational databases on my own, non-work time. As the years have […] 16 janvier 2024 dans Sites anglophones étiqueté Blogs / Editorials par simple-talk.com
A Simple Method to Load Excel DataProblem When we need to load data from Excel sheets to a SQL Server table, we typically use […] 15 janvier 2024 dans Sites anglophones étiqueté ETL/SSIS/Azure Data Factory / Integration Services (SSIS) par sqlservercentral.com
[Video] Office Hours: Ask Me Anything About the Microsoft Data ...Forgive the hoarse voice – I’m recovering from something COVID-ish. I went through your top-voted questions from https://pollgab.com/room/brento […] 12 janvier 2024 dans Sites anglophones étiqueté Videos par brentozar.com
Dimensional Modelling Case Study Part 1 – Age GroupBackground Age plays an important role in medicine and medical research. A patient’s ages is commonly grouped into […] 12 janvier 2024 dans Sites anglophones étiqueté Data Warehouse / database modelling / Dimensions par sqlservercentral.com
Query Exercise: Find Posts with the Wrong CommentCountFor 2024, I’m trying something new: weekly homework challenges! For this week’s query challenge, we’re going to do […] 11 janvier 2024 dans Sites anglophones étiqueté Query Exercises par brentozar.com