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
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
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
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
The Mastering Azure Data Studio SeriesThis is the index for a series of articles on Azure Data Studio (ADS), which will help you […] 10 janvier 2024 dans Sites anglophones par sqlservercentral.com
Adding Cookie Consent to SQL Server CentralTo comply with various regulatory requirements, we are adding a cookie consent form to the website. You will […] 10 janvier 2024 dans Sites anglophones étiqueté SQLServerCentral par sqlservercentral.com
Connecting SQL Server to SaaS applications with a Linked ServerThe post Connecting SQL Server to SaaS applications with a Linked Server appeared first on SQLServerCentral. 10 janvier 2024 dans Sites anglophones étiqueté linked server par sqlservercentral.com
An In-Depth Look at MIXED_PAGE_ALLOCATION and Changes in Page AllocationWhen it comes to managing data in SQL Server, efficient page allocation is crucial for performance and storage […] 10 janvier 2024 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
Machine learning K-Means applied to SQL Server dataIntroduction In this article, we will use K-Means applied to SQL Server using Python. We will learn what […] 8 janvier 2024 dans Sites anglophones étiqueté AI / Machine Learning (ML) / Python / SQL Server par sqlservercentral.com
New Power BI Explore this Data Feature: An Alternative to ...The post New Power BI Explore this Data Feature: An Alternative to Excel Pivot Tables appeared first on […] 5 janvier 2024 dans Sites anglophones étiqueté Power BI par sqlservercentral.com
Dijkstra's AlgorithmIntroduction This article celebrates a classic algorithm [1] of Dijkstra (1930 – 2002) which finds a path of […] 5 janvier 2024 dans Sites anglophones étiqueté Dijkstra / graphs / minimal path / t-sql par sqlservercentral.com
SQL Window Functions Series: NTILE()Continuing our journey through SQL’s handy window functions, we now tackle the NTILE() function. After exploring LAG(), LEAD(), […] 3 janvier 2024 dans Sites anglophones étiqueté #sql interview questions / Advanced Querying / Advanced SQL / Data / ntile / Performance / SQL / SQL Script / SQL Server / Window Functions par sqlservercentral.com
Kickstart the year with our free Livestream! Navigating the database ...The post Kickstart the year with our free Livestream! Navigating the database landscape in 2024 appeared first on […] 3 janvier 2024 dans Sites anglophones étiqueté Conferences, Classes, Events, and Webinars par sqlservercentral.com
Comparing Azure Analysis Services with On-Premises SQL Server Analysis ServicesThe post Comparing Azure Analysis Services with On-Premises SQL Server Analysis Services appeared first on SQLServerCentral. 1 janvier 2024 dans Sites anglophones étiqueté Analysis Services (SSAS) par sqlservercentral.com
Backup SQL Server on Linux Databases using SQL Server Agent ...The post Backup SQL Server on Linux Databases using SQL Server Agent on Windows appeared first on SQLServerCentral. 1 janvier 2024 dans Sites anglophones étiqueté Administration / Backup and restore / Database Administration / SQL Server on Linux par sqlservercentral.com
The Profiler Extension in Azure Data Studio (ADS)Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles […] 29 décembre 2023 dans Sites anglophones étiqueté Administration / Azure Data Studio / Database Administration / Tools for development par sqlservercentral.com
Understanding Maximum Server Memory in SQL SERVEREditor: For SQL developers looking to optimize their SQL Server’s performance, one crucial aspect to understand and implement […] 27 décembre 2023 dans Sites anglophones étiqueté Administration / Database Administration par sqlservercentral.com
Most Overlooked Features in Power BIThe post Most Overlooked Features in Power BI appeared first on SQLServerCentral. 27 décembre 2023 dans Sites anglophones étiqueté Power BI par sqlservercentral.com
Building Reports with Power BI vs Tableau from SQL Server ...The post Building Reports with Power BI vs Tableau from SQL Server Data appeared first on SQLServerCentral. 25 décembre 2023 dans Sites anglophones étiqueté Power BI par sqlservercentral.com
Docker Security Principles OverviewThe post Docker Security Principles Overview appeared first on SQLServerCentral. 25 décembre 2023 dans Sites anglophones étiqueté docker / Security par sqlservercentral.com
Creating a Hyperscale Database in Azure Using the Azure PortalData is the lifeblood of contemporary enterprises in the digital age. Managing and growing databases to fulfill these […] 22 décembre 2023 dans Sites anglophones étiqueté azsure sql database / Azure BLOB Storage / azure database / Azure SQL Database / Azure SQL Managed Instance / cloud database / Database Administration / database as a service / Hyperscale / Hyperscale database / Microsoft SQL Server / Microsoft SQL Server (MSSQL) / New database / SQL Server / SQL Server Instance par sqlservercentral.com
Sending resource alerts on Managed Instance using db_mailThe post Sending resource alerts on Managed Instance using db_mail appeared first on SQLServerCentral. 20 décembre 2023 dans Sites anglophones étiqueté Administration / Azure / Azure SQL Managed Instance / Cloud Computing / Database Administration / Managed Instances par sqlservercentral.com
Why Don't You Upgrade in Place?Ask a senior-level SQL Server or Windows administrator about doing in-place upgrades and you’ll likely get a negative […] 20 décembre 2023 dans Sites anglophones étiqueté SQL Server Upgrade / upgrading par sqlservercentral.com
Configuring an SSIS ForEach Loop for Multiple File TypesThe Problem The SSIS Foreach Loop component has a limitation when it comes to selecting different sets of […] 18 décembre 2023 dans Sites anglophones étiqueté ETL/SSIS/Azure Data Factory / Integration Services (SSIS) par sqlservercentral.com
Searching an Encrypted ColumnWhen encrypting a database column, equality searching can be preserved by using a deterministic encryption algorithm. A deterministic […] 15 décembre 2023 dans Sites anglophones étiqueté Encryption / Security / t-sql par sqlservercentral.com
Running Azure CosmosDB queries from SQL Server using ODBC driverThe post Running Azure CosmosDB queries from SQL Server using ODBC driver appeared first on SQLServerCentral. 15 décembre 2023 dans Sites anglophones étiqueté Azure Cosmos DB / CosmosDB / OpenRowSet par sqlservercentral.com
SQL GROUP BY Alias – An Oracle feature that would ...The post SQL GROUP BY Alias – An Oracle feature that would be great in SQL Server appeared […] 13 décembre 2023 dans Sites anglophones étiqueté t-sql par sqlservercentral.com
What is subsetting, what are the advantages, and how does ...The post What is subsetting, what are the advantages, and how does it make test data management easier? […] 11 décembre 2023 dans Sites anglophones étiqueté database testing / Test Data par sqlservercentral.com
Identify log write limits on Azure SQL Managed Instance using ...The post Identify log write limits on Azure SQL Managed Instance using QPI library appeared first on SQLServerCentral. 11 décembre 2023 dans Sites anglophones étiqueté Administration / Azure / Azure SQL Managed Instance / Database Administration par sqlservercentral.com
SQL Window Functions Series: LAG() and LEAD()In the realm of data analysis, being able to understand the relationships between sequential data points is paramount. […] 11 décembre 2023 dans Sites anglophones étiqueté #sql interview questions / Advanced SQL / Data / Database / Date Calculations / Date computation / DATEDIFF / LAG / LAG function / LEAD / OVER() / Performance / Performance and Tuning / Performance Tuning / Programming Language / SQL / SQL Compare / sql monitor / SQL Performance / SQL Prompt / SQL Script / SQL Server / t-sql / time series / TSQL / Window Functions par sqlservercentral.com
Window Function Basics – PARTITION BYOne of the things that I’ve done over the last year to improve my T-SQL skills is learn […] 8 décembre 2023 dans Sites anglophones étiqueté t-sql / Window Functions par sqlservercentral.com
How using a database monitoring tool helps DBAs create value ...The post How using a database monitoring tool helps DBAs create value for the whole organization appeared first […] 8 décembre 2023 dans Sites anglophones étiqueté monitoring par sqlservercentral.com
Learn Spark SQL Date and Time FunctionsThe post Learn Spark SQL Date and Time Functions appeared first on SQLServerCentral. 8 décembre 2023 dans Sites anglophones étiqueté Apache Spark par sqlservercentral.com
Plansplaining, part 20. SQL Graph (part 1)The post Plansplaining, part 20. SQL Graph (part 1) appeared first on SQLServerCentral. 6 décembre 2023 dans Sites anglophones étiqueté Execution Plan / Execution plans / Graph databases / Performance and Tuning / SQL Server Graph Database par sqlservercentral.com
GitHub Copilot – Our Best Ally to for T-SQLIntroduction Previously, we wrote about Copilot and showed how to install and work with it. A GitHub copilot […] 4 décembre 2023 dans Sites anglophones étiqueté Artificial Intelligence (AI) / Girhub Copilot / GitHub par sqlservercentral.com
Championing DevOps: A Panel WebinarThe post Championing DevOps: A Panel Webinar appeared first on SQLServerCentral. 4 décembre 2023 dans Sites anglophones étiqueté Conferences, Classes, Events, and Webinars par sqlservercentral.com
PowerShell Commands to Administer Virtual Machines on Amazon AWS – ...The post PowerShell Commands to Administer Virtual Machines on Amazon AWS – Part 2 appeared first on SQLServerCentral. 4 décembre 2023 dans Sites anglophones étiqueté AWS / Cloud Computing / PowerShell / Virtualization, containers, and k8s par sqlservercentral.com
Getting Started with DDL statements of Cassandra Query LanguageArticle Overview In this tutorial, we’ll learn the essential DDL concepts of Cassandra query language (CQL) and how […] 1 décembre 2023 dans Sites anglophones étiqueté CassandraDB / NoSQL par sqlservercentral.com
TABLOCK Hint can Negatively Impact SQL Server ConcurrencyThe post TABLOCK Hint can Negatively Impact SQL Server Concurrency appeared first on SQLServerCentral. 29 novembre 2023 dans Sites anglophones étiqueté Concurrency par sqlservercentral.com
Using the Import Extension in Azure Data StudioAzure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles […] 29 novembre 2023 dans Sites anglophones étiqueté Azure Data Studio / Tools for development par sqlservercentral.com
Working with Azure DocumentDB: SQL & NoSQL TogetherThe post Working with Azure DocumentDB: SQL & NoSQL Together appeared first on SQLServerCentral. 29 novembre 2023 dans Sites anglophones étiqueté Azure Cosmos DB / CosmosDB par sqlservercentral.com
Time Series Data Mining Example with T-SQL when Adding New ...The post Time Series Data Mining Example with T-SQL when Adding New Data appeared first on SQLServerCentral. 27 novembre 2023 dans Sites anglophones étiqueté Data Mining / t-sql par sqlservercentral.com
Ensuring a Single Row TableSingle row tables in data modeling Single row tables are a fact of our life as as a […] 27 novembre 2023 dans Sites anglophones étiqueté calculated columns / Database Design / Database Design and Implementation / Primary Key / Primary Key (PK) / single row table / SQL Server / t-sql par sqlservercentral.com
Black Friday returns to SQLServerFastThe post Black Friday returns to SQLServerFast appeared first on SQLServerCentral. 24 novembre 2023 dans Sites anglophones étiqueté Conferences, Classes, Events, and Webinars par sqlservercentral.com
Unpivoting Multiple Sets of Columns in SQL Server using CROSS ...The post Unpivoting Multiple Sets of Columns in SQL Server using CROSS APPLY appeared first on SQLServerCentral. 24 novembre 2023 dans Sites anglophones étiqueté APPLY / cross apply / t-sql / UNPIVOT par sqlservercentral.com
Advanced SQL Server installation using Powershell DSCIntroduction In the previous article, we learned how to install a SQL Server instance with basic parameters like […] 22 novembre 2023 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
Azure DocumentDB: Working with Microsoft's NoSQL Database in the CloudThe post Azure DocumentDB: Working with Microsoft's NoSQL Database in the Cloud appeared first on SQLServerCentral. 22 novembre 2023 dans Sites anglophones étiqueté Azure Cosmos DB / CosmosDB par sqlservercentral.com
“How do my peers do this?” The latest best practices ...The post “How do my peers do this?” The latest best practices for IT architects implementing a major […] 20 novembre 2023 dans Sites anglophones étiqueté State of the Business par sqlservercentral.com
What are Warehouses in Microsoft Fabric?The post What are Warehouses in Microsoft Fabric? appeared first on SQLServerCentral. 20 novembre 2023 dans Sites anglophones étiqueté Microsoft Fabric (Azure Synapse, Data Engineering, etc.) par sqlservercentral.com