What happens when you convert DATE and TIME in SQL Server 2008 to DATETIME? A quick demo shows the midnight and 1900 surprise.
SQLAuthority News – SQL Server Technology Evangelists and Evangelism
Am I an evangelist, a mentor or a founder? A funny talk from my public training about SQL Server Technology Evangelists and what my title really is.
Estimated and Actual Execution Plans
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.