A quick trick with the SQL Server 2012 CONCAT function: three SQL experts suggested within minutes that it works with the PRINT statement too.
SQL SERVER – A Quick Trick about SQL Server CONCAT function
A quick trick from a Virtual Tech Days demo: adding a string to GETDATE() throws an error. CAST fixes it, and SQL Server 2012 CONCAT does it more simply.
SQLAuthority News – Community Service and Public Speaking Engagements
On the last day of 2010 I look back at my community service and public speaking engagements: TechEds, PASS, Virtual Tech Days and many community events.
SQL SERVER – History of SQL Server Database Encryption
Michael Coles, co-author of Expert SQL Server 2008 Encryption, let me share his history of SQL Server database encryption, starting from SQL Server 2000.
SQL SERVER – One Thing All DBA Must Know
The one thing all DBA must know is to backup database fully. I also answer reader questions on the best time for a backup and how often to take one.