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.
SQL SERVER – List All the DMV and DMF on Server
“How many DMV and DVF are there in SQL Server 2008?” – this question was asked to me in one of the recent SQL Server Training.