@DATA_SAPIENS profile picture
SQLpro @DATA_SAPIENS

Database Architect and SQL Server Expert (MVP since 2004) and author of many books about SQL language and Microsoft SQL Server. My own company is SQL Spot.

Joined January 2017
  • Tweets 13
  • Following 47
  • Followers 31
Photos and videos
SQLpro@DATA_SAPIENS
7 Jan 2021
Whats difference a RDBMS make ? #sqlserver and #postgresql in terms of performances for the DBA First of a collection of papers... linkedin.com/pulse/postgresq…

PostGreSQL vs Microsoft SQL Server - Comparison part 1 - DBA queries

2021-01-07 In this new year (2021) I will publish a collection of paper comparing SQL Server to PostGreSQL. Some of my customer wanted to go from one to the other.

linkedin.com
1
SQLpro@DATA_SAPIENS
24 Apr 2017
Découvrez le profil freelance de Frédéric Brouard, Expert Microsoft SQL Server #hopwork hopwork.fr/profile/fredericb…
SQLpro@DATA_SAPIENS
25 Jan 2017
#TemporalTable with #SQLServer - MS Cloud Summit 2017 PARIS linkedin.com/pulse/temporal-… on @LinkedIn
SQLpro@DATA_SAPIENS
17 Jan 2017
Une série de tutoriels en français sur l’optimisation #SQLServer blogs.technet.microsoft.com/…
SQLpro@DATA_SAPIENS
17 Jan 2017
Index metadata for #SQLServer (sp_helpindex improved)" linkedin.com/pulse/index-met… on @LinkedIn
SQLpro@DATA_SAPIENS
13 Jan 2017
"How to write a generic #AuditTrail for #SQLServer" linkedin.com/pulse/how-write… on @LinkedIn

How to write a generic audit trail for SQL Server

ATTENTION : article en français / this paper is in french language. Date de publication / Publishing date : 2017-01-13 The audit trail is an audit to track events that happens in a system.

linkedin.com
SQLpro@DATA_SAPIENS
12 Jan 2017
"SQL: Solving the LIKE '%foo%' with Performances in #SQLserver" linkedin.com/pulse/sql-solvi… on @LinkedIn

SQL: Solving the LIKE '%foo%' with Performances

ATTENTION : article en français / this paper is in french language. Date de publication / Publishing date : 2017-01-05 The purpose of this paper is to show how obtaining a maximum of performances...

linkedin.com
SQLpro@DATA_SAPIENS
12 Jan 2017
"Determine the bounding box of geometryspatial indexes in #SQLServer " linkedin.com/pulse/automatic… on @LinkedIn
SQLpro@DATA_SAPIENS
12 Jan 2017
"Determine the "bounding box" of geometry-type spatial indexes on #SQLServer" linkedin.com/pulse/automatic… on @LinkedIn
SQLpro@DATA_SAPIENS
12 Jan 2017
"Automatically determine the "bounding box" of geometry-type spatial indexes #SQLServer" linkedin.com/pulse/automatic… on @LinkedIn
SQLpro@DATA_SAPIENS
12 Jan 2017
"Automatically determine the "bounding box" of geometry-type spatial indexes in #SQLServer" linkedin.com/pulse/automatic… on @LinkedIn
SQLpro@DATA_SAPIENS
12 Jan 2017
"Generating INSERTs from an existing #SQLServer table" linkedin.com/pulse/generatin… on @LinkedIn
SQLpro@DATA_SAPIENS
12 Jan 2017
"Unlocking a frozen #SQLServer instance" linkedin.com/pulse/unlocking… on @LinkedIn
Load more