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.
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.
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.
What Is Compatibility Level in SQL Server?
Compatibility level in SQL Server is a per-database setting, and upgrading the server does not change it. Why a restored database keeps the old level, what the setting really controls, and how to raise it without breaking a report.