SQL Server

Giving Feedback on Microsoft Data Platform Tools

As a data professional, there is a set of tools that you use on pretty much a […]

8 avril 2024 dans Sites anglophones étiqueté Editorials / Homepage / SQL Server par simple-talk.com

Check Azure SQL DB Space Used
A couple of days ago I was doing some cleaning on some Azure SQL DBs and shrinking some […]

29 mars 2024 dans Sites anglophones étiqueté Administration / Azure / Azure SQL / Azure SQL Database / Database Administration / Database Space / SQL Server / t-sql par sqlservercentral.com

SQL Server to PostgreSQL Database Schema Conversion

The post SQL Server to PostgreSQL Database Schema Conversion appeared first on SQLServerCentral.

13 mars 2024 dans Sites anglophones étiqueté migration / PostGreSQL / SQL Server par sqlservercentral.com

Friendly Deletes in SQL Server

One of the first things you learn when working with SQL Server, and other transactional based SQL […]

1 mars 2024 dans Sites anglophones étiqueté Blogs / DELETE Statement / Performance / SQL Server par simple-talk.com

SQL ConstantCare® Population Report: Winter 2023
The 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

Machine learning K-Means applied to SQL Server data
Introduction 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

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

Creating a Hyperscale Database in Azure Using the Azure Portal
Data 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

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

SQL Server: Optimize for Ad Hoc Workloads – use or ...
I used to believe this option was something almost absolute: it should be enabled as best practice. […]

6 décembre 2023 dans Sites anglophones étiqueté Blogs / optimization / SQL Server par simple-talk.com

Ensuring a Single Row Table

Single 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

The Real Problem with SQL Server’s Licensing Costs
At least once a month, a client has The Postgres Conversation™ with me. It happens at the end […]

13 novembre 2023 dans Sites anglophones étiqueté SQL Server par brentozar.com

Office Hours: “Read This” Edition

Sometimes when people post questions at https://pollgab.com/room/brento, the answer is just a link, nothing more, nothing less. It […]

10 novembre 2023 dans Sites anglophones étiqueté SQL Server par brentozar.com

SQL Server and Python Tutorial

Introduction In this article, we will see how to connect SQL Server with Python using the pyodbc library. […]

6 novembre 2023 dans Sites anglophones étiqueté Microsoft SQL Server / Python / SQL Server par sqlservercentral.com

Batch Execution Mode on a Rowstore in SQL Server 2022
Batch execution mode is a new optimization feature in SQL Server. In this article, we’ll explore how batch […]

30 octobre 2023 dans Sites anglophones étiqueté #sql server interview questions / Azure SQL / azure sql server / Batch Execution Mode on Rowstore in SQL Server 2022 / Database Performance / Microsoft SQL Server / Microsoft SQL Server 2022 / performance enhancement / Performance Tuning / SQL Server / SQL Server 2019 / SQL Server 2022 par sqlservercentral.com

Profiler and Server Side Traces

The post Profiler and Server Side Traces appeared first on SQLServerCentral.

29 septembre 2023 dans Sites anglophones étiqueté SQL Server par sqlservercentral.com

12 Office Hours Questions I Don’t Have Answers For

Hey, 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

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

Generate Test Data Sets for Testing SQL Server Database Applications

The 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

How to export data to SQL Server using Bard (Google ...
The article will explain how to export data to SQL Server with Bard can be challenging. Previously, we […]

28 août 2023 dans Sites anglophones étiqueté Artificial Intelligence (AI) / bard / MS SQL Server / SQL Server par sqlservercentral.com

Different Ways to Format Currency Output in SQL

The post Different Ways to Format Currency Output in SQL appeared first on SQLServerCentral.

28 août 2023 dans Sites anglophones étiqueté SQL Server / t-sql par sqlservercentral.com

Working with SQL Server Stored Procedures and .NET

The post Working with SQL Server Stored Procedures and .NET appeared first on SQLServerCentral.

21 août 2023 dans Sites anglophones étiqueté .NET / Microsoft SQL Server / SQL Server par sqlservercentral.com

Dive into RDS Custom for SQL Server – Leverage your ...

The post Dive into RDS Custom for SQL Server – Leverage your existing licenses and high availability appeared […]

14 août 2023 dans Sites anglophones étiqueté Amazon RDS / RDS SQL Server / SQL Server par sqlservercentral.com

Analyzing Prices of SQL Server Books, New & Used
While on a road trip, Richie stopped by a used bookstore (or would that be used book store?) […]

8 août 2023 dans Sites anglophones étiqueté SQL Server par brentozar.com

How to List First or Last n% Records Using NTILE() ...

The post How to List First or Last n% Records Using NTILE() in SQL Server appeared first on […]

4 août 2023 dans Sites anglophones étiqueté functions system / SQL Server par sqlservercentral.com

Installing SQL Server Integration Services

The post Installing SQL Server Integration Services appeared first on SQLServerCentral.

31 juillet 2023 dans Sites anglophones étiqueté SQL Server / SSIS par sqlservercentral.com

SQL Server vs Oracle Query Statistics to Improve Performance

The post SQL Server vs Oracle Query Statistics to Improve Performance appeared first on SQLServerCentral.

21 juillet 2023 dans Sites anglophones étiqueté Oracle / SQL Server par sqlservercentral.com

Sample Use Case for Using SQLCMD Utility Batch Files

The post Sample Use Case for Using SQLCMD Utility Batch Files appeared first on SQLServerCentral.

14 juillet 2023 dans Sites anglophones étiqueté DBA tips / DBA Tools / SQL Server / SQL Server Data Tools (SSDT) / t-sql par sqlservercentral.com

SQL Server Database Backup and Restore Failure Notifications

The post SQL Server Database Backup and Restore Failure Notifications appeared first on SQLServerCentral.

3 juillet 2023 dans Sites anglophones étiqueté SQL Server par sqlservercentral.com

SQL Server Resumable Index Operations
As the DBA, have you ever had to cancel an online rebuild or create index process on a […]

26 juin 2023 dans Sites anglophones étiqueté Database Administration / indexes / indexing / Microsoft SQL Server / New Feature of SQL Server / SQL Server / SQL Server Resumable Index Operations par sqlservercentral.com

Cheat Sheet for SQL Server DBAs – Monitoring Current Activity, ...

The post Cheat Sheet for SQL Server DBAs – Monitoring Current Activity, Blocking and Performance appeared first on […]

26 juin 2023 dans Sites anglophones étiqueté DBA / SQL Server par sqlservercentral.com

Troubleshoot SQL Server Deadlocks in Stored Procedures

The post Troubleshoot SQL Server Deadlocks in Stored Procedures appeared first on SQLServerCentral.

23 juin 2023 dans Sites anglophones étiqueté locking and blocking / SQL Server par sqlservercentral.com

ISJSON enhancements in SQL Server for valid JSON format for ...

The post ISJSON enhancements in SQL Server for valid JSON format for a Value, Array or Object appeared […]

19 juin 2023 dans Sites anglophones étiqueté JSON / SQL Server par sqlservercentral.com

Restarting MS SQL Server : bad or good idea ?
I am often appalled by the lack of knowledge of the database culture of computer scientists in general […]

6 juin 2023 dans Sites francophones étiqueté Performances / performnces / Sécurité / SQL Server par mssqlserver.fr

How to Filter a SQL Server Audit with a Predicate

The post How to Filter a SQL Server Audit with a Predicate appeared first on SQLServerCentral.

5 juin 2023 dans Sites anglophones étiqueté SQL Server / Uncategorized par sqlservercentral.com

SQL WHERE LIKE to Construct More Efficient Queries

The post SQL WHERE LIKE to Construct More Efficient Queries appeared first on SQLServerCentral.

2 juin 2023 dans Sites anglophones étiqueté Developer / queries / SQL / SQL Server par sqlservercentral.com

Breaking News: SQL Server 2022 Keeps Getting Worse.

<sigh> Okay, so, the last few Cumulative Updates have had known issues around broken remote queries using the […]

26 mai 2023 dans Sites anglophones étiqueté SQL Server par brentozar.com

Getting Started with Ensemble AI Models in SQL Server

The post Getting Started with Ensemble AI Models in SQL Server appeared first on SQLServerCentral.

26 mai 2023 dans Sites anglophones étiqueté AI / Artificial Intelligence (AI) / SQL Server par sqlservercentral.com

Cache SQL Server Data in a .NET Web Application

The post Cache SQL Server Data in a .NET Web Application appeared first on SQLServerCentral.

22 mai 2023 dans Sites anglophones étiqueté .NET / Data / Database Development / SQL Server par sqlservercentral.com

Benefits and Limitations of SCHEMABINDING Views in SQL Server

The post Benefits and Limitations of SCHEMABINDING Views in SQL Server appeared first on SQLServerCentral.

8 mai 2023 dans Sites anglophones étiqueté SQL Server par sqlservercentral.com

SQL Server et la redondance de zone sur Azure
L’actualité récente nous a encore montré que même un grand nom des acteurs du cloud public n’est pas […]

3 mai 2023 dans Sites francophones étiqueté Azure / HADR / Haute disponibilité / SQL Azure / SQL Server par conseilit.wordpress.com

Create an HTML Report on the Status of SQL Server ...
SQL Server jobs are an integral part of any SQL Server environment. These jobs run a predefined set […]

3 mai 2023 dans Sites anglophones étiqueté Microsoft SQL Server (MSSQL) / MS SQL Server Agent / query / SQL Server par sqlservercentral.com

9 février 2023 dans Sites francophones étiqueté auto-incréments / clonage d'une base / CREATE OR ALTER / historisation des données / identity / instantané de bases de données / Sécurité au niveau ligne / sequence / SQL Server / tables temporaires / tables temporelles / Transact SQL / type de données / Uncategorized / variables / vues indexées par mssqlserver.fr

The 20th Anniversary of the SQL Slammer Worm

Twenty years ago this month (next Wednesday to be exact), sysadmins and database administrators started noticing extremely high […]

18 janvier 2023 dans Sites anglophones étiqueté SQL Server par brentozar.com

Should You Use SQL Server 2022’s GREATEST and LEAST?
If you’ve been following along with this week’s posts on DATETRUNC and STRING_SPLIT, you’re probably going to think […]

22 décembre 2022 dans Sites anglophones étiqueté SQL Server par brentozar.com