geometry line endpoints identify the first and last described points. Reversing the same path exchanges them, while a closed line starts and ends together.
SQL SERVER – Check if Current Login is Part of Server Role Member
Clients sometimes forget to give me admin rights. IS_SRVROLEMEMBER(‘sysadmin’) checks if the current login is a Server Role Member: 1 means yes, 0 means no.
Replacing Profiler Traces With Extended Events
Replacing Profiler traces with Extended Events starts with the question, a focused event session, and a bounded target that avoids needless load.
Standard DBA Reports You Can Write in T-SQL
Standard DBA reports can use T-SQL to show backup age, database sizes, job failures, login changes, and errors in one weekly review.
SQL SERVER – Fix Error 9803. Invalid data for type “numeric” – Data Type Mapping
My present article talks about an error that you will encounter when connecting to Oracle database using OPENQUERY. Let us learn about how to fix error 9803.
Reading the SQL Server Support Lifecycle
Read the SQL Server support lifecycle for your exact release, distinguish mainstream and extended support, and plan before coverage ends.
LEFT Boundaries: Zero, Oversized Length and Missing Text
LEFT boundaries keep empty prefixes separate from missing values. Eight short Unicode cases expose zero, oversized and missing lengths. A separate invalid request shows why negative lengths need validation.