SQL Server

SQL Server – Beware of server role securityadmin! Using privilege elevation to become sysadmin

April 18th 2022
0
Database SQL Server Security

SQL Server and Azure SQL Database: How to Identify Key Lookup occurrences through the plancache

April 14th 2022
0
Performance tuning Maintenance Azure SQL Database Database SQL Server

SQL Server - How to identify all missing indexes (Missing indexes) of a database

April 7th 2022
0
Maintenance DMVs and Catalog Views Database SQL Server Performance tuning

Azure SQL Database – STRING_SPLIT function finally gets parameter to include number of positions

November 5th, 2021
0
Query Development Database SQL Server News

How to Fix SQL Server Data Tools (SSDT) Installation Error 2017 – Setup Failed: Incorrect function (0x80070001)

October 4th, 2021
4
Business Intelligence (BI) Errors

SQL Server – How to list the largest tables and indexes in the database and show the size of each

October 1th, 2021
0
Maintenance Monitoring Database SQL Server

SQL Server – How to identify timeout or broken connections using Extended Events (XE) or SQL Profiler (Trace)

September 29th, 2021
0
Query Development Database SQL Server

SQL Server – Using TRANSLATE to replace multiple REPLACE

September 28th, 2021
0
Query Development Database SQL Server

SQL Server - How to identify the store closest to the customer (or the distance between 2 locations) from the zip code (without API)

SQL Server – How to filter and separate the number and text of a string