Enterprise vs EnterpriseCore Edition for SQL Server on Linux production ...Recently, in one of the meetings with our CSS team (support) we realized that our customers might not be […] 29 septembre 2023 dans Sites Microsoft par MS Tech Community
Profiler and Server Side TracesThe post Profiler and Server Side Traces appeared first on SQLServerCentral. 29 septembre 2023 dans Sites anglophones étiqueté SQL Server par sqlservercentral.com
Sending Multiple Attachments in Email from Azure Data Factory PipelineIntroduction The problem statement is to send email from Azure Data Factory Pipeline with one or more attachments […] 29 septembre 2023 dans Sites anglophones étiqueté Azure Data Factory / Email / ETL/SSIS/Azure Data Factory par sqlservercentral.com
T-SQL Fundamentals: Controlling DuplicatesWhen people start learning a new field, for example T-SQL, it’s tempting to spend very little time […] 28 septembre 2023 dans Sites anglophones étiqueté Homepage / SummitSpeaker2023ItzikBenGan / T-SQL Programming / Theory and design par simple-talk.com
Protect SQL Server 2014 workloads with Azure flexibilitySQL Server has brought reliability and security to mission-critical workloads for 30 years. SQL Server 2022, released November […] 28 septembre 2023 dans Sites Microsoft étiqueté SQL Server 2022 par SQL Server Blog
[Video] Office Hours at the Munch Museum in OsloWhile in Norway for Data Saturday Oslo, I set up my camera gear by the Munch Museum to […] 28 septembre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
Microsoft Fabric and the Delta Tables SecretsMicrosoft Fabric storage uses OneLake and Delta Tables, the core storage of all Fabric objects, as explained […] 27 septembre 2023 dans Sites anglophones étiqueté Blogs / Data Lake / Delta / lakehouse / Microsoft Fabric / Power BI par simple-talk.com
[Video] Office Hours at Dyrhólaey Overlooking Puffins & Black Sand ...Got Azure SQL DB and SQL Server questions? Post them at https://pollgab.com/room/brento and I’ll answer the top-voted ones. […] 27 septembre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
Introduction to Using Bitbucket and CI/CD for Your AppThe post Introduction to Using Bitbucket and CI/CD for Your App appeared first on SQLServerCentral. 27 septembre 2023 dans Sites anglophones étiqueté CI/CD / DevOps and Continuous Delivery (CI/CD) par sqlservercentral.com
The pros and cons of multicloud networkingThe post The pros and cons of multicloud networking appeared first on SQLServerCentral. 27 septembre 2023 dans Sites anglophones étiqueté Cloud Computing par sqlservercentral.com
It’s Probably Time to Upgrade Your Cloud VMs.If you’ve been in Azure or Amazon for a few years, you’re probably on old, slow hardware. In […] 26 septembre 2023 dans Sites anglophones étiqueté Cloud Computing par brentozar.com
Best practices N° 4 – configuration de l'instance SQLEtape importante de configuration post-installation, à minima retoucher les paramètres de l’instance : Mémoire maximale Compression et checksum […] 25 septembre 2023 dans Sites francophones par blog.datafly.pro
SQL Server Row Level Security Deep Dive. Part 5 – ...As mentioned in previous sections, RLS is an addition to security and should not be used as […] 25 septembre 2023 dans Sites anglophones étiqueté BenJohnston_RLS / Blogs / RLS / Side-channel attack par simple-talk.com
Restore With Standby; A Review and A Lesson LearnedThere are features of SQL Server I use often and consider to understand reasonably well, features I know […] 25 septembre 2023 dans Sites anglophones étiqueté Backup and restore / SQL Server Upgrade / upgrading par sqlservercentral.com
AI-900: Microsoft Azure AI Fundamentals Certification Exam Tips and TricksThe post AI-900: Microsoft Azure AI Fundamentals Certification Exam Tips and Tricks appeared first on SQLServerCentral. 25 septembre 2023 dans Sites anglophones étiqueté azure ai / Certification / Professional Development par sqlservercentral.com
MySQL joinsTables in a MySQL database are commonly related to one another, often in multiple ways, and it […] 25 septembre 2023 dans Sites anglophones étiqueté Homepage / MySQL / stateofdatabaselandscapesurvey par simple-talk.com
Best practices N° 3 : configurer les historiquesSQL Server ne conserve par défaut que 6 archives du journal d’erreur, et l’historique des travaux de l’agent […] 24 septembre 2023 dans Sites francophones par blog.datafly.pro
Best practices N° 2 : configurer database mail, les notifications ...Etre notifié par mail en cas de problème, c’est indispensable ! Ici, nous configurons Database Mail, étape importante […] 23 septembre 2023 dans Sites francophones par blog.datafly.pro
Analyze and Tune SQL Server StatisticsOver the years, SQL Server Statistics have been discussed in countless blog posts, articles, and presentations, and […] 22 septembre 2023 dans Sites anglophones étiqueté Database Administration / Homepage par simple-talk.com
Best practices N° 1 : tâches de maintenanceA l’installation d’une instance SQL Server, il y a au minimum quelques « best practices » à appliquer. Cette série […] 22 septembre 2023 dans Sites francophones par blog.datafly.pro
How Would You Design This: Scheduling ClassesOne of the challenges for many database developers is coming up with a good design that not only […] 22 septembre 2023 dans Sites anglophones étiqueté Database Design / How would you design this par sqlservercentral.com
New Amazon X2iedn High-Memory InstancesAmazon just announced new X2iedn instance types for Amazon RDS SQL Server. They’re a sweet deal for people […] 21 septembre 2023 dans Sites anglophones étiqueté Amazon Web Services (AWS) par brentozar.com
Azure Data Studio 1.46 and New FeaturesWe’re rolling towards conference season and the Azure Data Studio engineers have been working hard on two things: […] 20 septembre 2023 dans Sites Microsoft par MS Tech Community
Microsoft Fabric: Checking and Fixing Tables V-Order OptimizationDownload the notebook used on this blog I explained in a previous article how the Tables in […] 20 septembre 2023 dans Sites anglophones étiqueté Blogs / data platform / Delta / lakehouse / Microsoft Fabric / Power BI par simple-talk.com
[Video] Office Hours at Svínafellsjökull Glacier in IcelandGot Azure SQL DB and SQL Server questions? Post them at https://pollgab.com/room/brento and I’ll answer the top-voted ones. […] 20 septembre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
How Effective Is Your Data Load Monitoring in SQL and ...As organizations load an increasing amount of data from different sources into their data warehouses, monitoring these data […] 20 septembre 2023 dans Sites anglophones étiqueté ETL / ETL/SSIS/Azure Data Factory / Extract, Transform, Load (ETL) / Python par sqlservercentral.com
GPT Base, GPT-3.5 Turbo & GPT-4: What's the difference?The post GPT Base, GPT-3.5 Turbo & GPT-4: What's the difference? appeared first on SQLServerCentral. 20 septembre 2023 dans Sites anglophones étiqueté Artificial Intelligence (AI) par sqlservercentral.com
12 Office Hours Questions I Don’t Have Answers ForHey, you! You look smart. Here are highly-upvoted questions that fellow readers submitted at https://pollgab.com/room/brento that I don’t […] 19 septembre 2023 dans Sites anglophones étiqueté SQL Server par brentozar.com
Interactive Data Analytics With PowerShell, SQL, and ChatGPT (Sample Script)Learn about the integration of PowerShell, SQL Server data, and ChatGPT for interactive data analytics. 19 septembre 2023 dans Sites anglophones par sqlmag.com
Alternatives To SQL-2022 Built-in function GREATESTIf you haven’t already heard, SQL 2022 has introduced a new built-in system function called GREATEST. Simply […] 18 septembre 2023 dans Sites anglophones étiqueté Homepage / stateofdatabaselandscapesurvey / T-SQL Programming par simple-talk.com
Azure SQL Edge Update – September 2023Today, I am providing an update on the supported configurations of Azure SQL Edge, the version of SQL […] 18 septembre 2023 dans Sites Microsoft par MS Tech Community
PostgreSQL 101: A guide to PostgreSQL documentation & useful resourcesThe post PostgreSQL 101: A guide to PostgreSQL documentation & useful resources appeared first on SQLServerCentral. 18 septembre 2023 dans Sites anglophones étiqueté Conferences, Classes, Events, and Webinars / PostGreSQL par sqlservercentral.com
GENERATE_SERIES() Breaks Minimal Loggingtl;dr The title says it all. Prologue One of the keys to my personal learning is that, very […] 18 septembre 2023 dans Sites anglophones étiqueté bulk logged / Data Generation / Database Performance / GENERATE_SERIES() / Jeff Moden / Minimal Logging / software testing / t-sql / T-SQL Programming / Test Data / Transact SQL par sqlservercentral.com
SQL Server Execution Plan Issues when using TOP Clause and ...The post SQL Server Execution Plan Issues when using TOP Clause and Various Parameters appeared first on SQLServerCentral. 18 septembre 2023 dans Sites anglophones étiqueté Performance Tuning / SQL Server par sqlservercentral.com
Meetup du Club Power BI, pilote de la saison 8, ...Le 11 septembre 2023, le Club Power BI a organisé un nouveau meetup titré « Pilote de la […] 17 septembre 2023 dans Sites francophones étiqueté 2023 / Club Power BI / Evènements / Nouveautés / Power BI par blog.pgeiger.net
SQL Server Row Level Security Deep Dive. Part 4 – ...One of the primary reasons to implement RLS is to facilitate reporting and ease the administrative burden. […] 17 septembre 2023 dans Sites anglophones étiqueté BenJohnston_RLS / Blogs / Power BI / RLS / SSRS par simple-talk.com
How To Filter SQL Server Data in Windows PowerShellExplore techniques for filtering SQL Server data using both PowerShell and SQL queries. 15 septembre 2023 dans Sites anglophones par sqlmag.com
Cumulative Update #8 for SQL Server 2022 RTMThe 8th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft […] 15 septembre 2023 dans Sites Microsoft par MS Tech Community
Backup and Restore SQL Database to Azure Blob StorageSQL databases are crucial for businesses, so it’s critical to back them up. A dependable and affordable option […] 15 septembre 2023 dans Sites anglophones étiqueté Azure / Azure BLOB Storage / BACKUP / Backup and restore / MS SQL Server / Restore backup par sqlservercentral.com
Generate Test Data Sets for Testing SQL Server Database ApplicationsThe post Generate Test Data Sets for Testing SQL Server Database Applications appeared first on SQLServerCentral. 15 septembre 2023 dans Sites anglophones étiqueté SQL Server / Testing par sqlservercentral.com
Announcing SQLBits 2024: 19-23 March, Near LondonI hate picking favorites, but I gotta be honest: SQLBits is my favorite conference. Sure, like any conference, […] 14 septembre 2023 dans Sites anglophones étiqueté SQLBits par brentozar.com
Microsoft Fabric: Using notebooks and table partitioning to convert files ...When Microsoft Fabric was born, the only method to convert files to tables was using notebooks. Nowadays […] 13 septembre 2023 dans Sites anglophones étiqueté Data Lake / data platform / lakehouse / Microsoft Fabric / notebook / Power BI / Uncategorized par simple-talk.com
[Video] Office Hours at Breiðamerkursandur, Diamond BeachPost your Azure SQL DB and SQL Server questions at https://pollgab.com/room/brento and upvote the ones you’d like to […] 13 septembre 2023 dans Sites anglophones étiqueté Videos par brentozar.com
“Oops, I Lost My Indexes in Azure SQL DB.”I got an interesting request for consulting, and I’m going to paraphrase it: We were using Azure SQL […] 12 septembre 2023 dans Sites anglophones étiqueté Azure SQL DB / Backup and Recovery par brentozar.com
How To Visualize SQL Server Data in PowerShell (With Sample ...Learn how to use data from a SQL Server database to create graphs and charts in PowerShell. A […] 11 septembre 2023 dans Sites anglophones par sqlmag.com
What’s Faster: IN or OR? Columnstore EditionPinal Dave recently ignited a storm of controversy when he quizzed readers about which one of these would […] 11 septembre 2023 dans Sites anglophones étiqueté Columnstore Indexes / Execution plans par brentozar.com
Webinar: The Impact of the Cloud on DatabasesThe post Webinar: The Impact of the Cloud on Databases appeared first on SQLServerCentral. 11 septembre 2023 dans Sites anglophones étiqueté Webinar / Webinars par sqlservercentral.com
How to create a SQL Server presentation in 5 minutes ...Introduction This SQLServerCentral article shows how to create a SQL Server presentation in 5 minutes using AI. AI […] 11 septembre 2023 dans Sites anglophones étiqueté AI / Artificial Intelligence (AI) / gamma / Powerpoint / Presentation / Presentations par sqlservercentral.com
Working with NULL Values in SQLThe post Working with NULL Values in SQL appeared first on SQLServerCentral. 11 septembre 2023 dans Sites anglophones étiqueté NULL par sqlservercentral.com
SQL Server Row Level Security Deep Dive. Part 3 – ...Previous sections gave a brief introduction to RLS, including some common use cases. They also showed how […] 10 septembre 2023 dans Sites anglophones étiqueté BenJohnston_RLS / Blogs / RLS / RLS Performance / RLS Troubleshooting par simple-talk.com