Free SQL Server 2012 eBook from Microsoft Press

Get your free Microsoft Press eBook, Introducing Microsoft SQL Server 2012 by visiting this link to get your PDF version today – http://blogs.msdn.com/b/microsoft_press/archive/2012/03/15/free-ebook-introducing-microsoft-sql-server-2012.aspx This book was written by former MVP turned Microsoft employee Ross Mistry and current MVP Stacia Misner. Enjoy!

Read more
Which SQL Client versions are connecting to my instance?

Without fully restating what’s already published, please read this MSDN Blog Post for more details on how to determine which SQL Client version is connecting to a SQL instance. Basically, SELECT CAST(protocol_version as BINARY(4)) FROM sys.dm_exec_connections will tell you which version is connecting to your instance based on the TDS protocol appendix document, http://msdn.microsoft.com/en-us/library/dd339982(PROT.13).aspx. SQL […]

Read more
SSIS 2012 – SSIS Environment Variables String Limit

UPDATE: 2012-02-24 – The bug I submitted on this has been closed as “won’t fix.” I had asked the team to enforce this limitation in the GUI instead of throwing a somewhat cryptic error. Sorry. When creating environments in the new SSIS catalog, you are able to define environment variables. When creating string variables, you […]

Read more