Estimated and actual execution plans answer different questions; compare compiled choices with runtime rows, warnings, and resource use.
Azure SQL Database and SQL Server: What Changes
Compare Azure SQL Database with SQL Server, including jobs, cross-database access, monitoring, backup control, and operational responsibilities.
Getting SQL Server Data Into Power BI
Power BI can read SQL Server through Import or DirectQuery; stable views, folding, and workload checks keep the database responsive.
SQL SERVER – Check the Isolation Level with DBCC useroptions
What isolation level is your session using? Run DBCC useroptions to see it, along with dateformat, datefirst, language and other SET options.
Multi-Language Text: A Table Design for Translations
Multi-language text separates product identity from translated names. This test setup checks requested, fallback, and base names, Unicode text, duplicate tags, missing rows, and a precise blank policy.
ISNULL Versus COALESCE: Return Length Can Change
ISNULL versus COALESCE can preserve different string widths. Make the intended replacement type explicit before characters are truncated.
SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions
Snapshot Isolation has been in SQL Server since 2005, yet many shops still skip it. A simple example shows how it can reduce blocking transactions.
SQLAuthority News – Professional Development and Community
Hyderabad Techies asked me to open their 16-day online event, TECH THUNDERS, with a keynote. My first talk on Professional Development, in just 15 minutes.
Indexing Foreign Keys
Indexing foreign keys can speed joins and parent deletes when child-side indexes are missing; learn how to find gaps and test write tradeoffs.
What a DBA Actually Does All Day
Understand what a DBA does across incidents, prevention, projects, and automation, with practical checks that connect daily work to business risk.










