Tag Archives: MSTechEd

MSTechEd2011–SQL Development with Juneau (DEV207)

Video Link: http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/DEV207 Developing Databases is Hard The presentation started off by listing some of the issues facing databases developers as reported to Microsoft. Are these the only issues, or even the most important issues facing developers? I guess it … Continue reading

Posted in Database and BI, Tooling | Tagged , , | Leave a comment

MSTechEd 2011 – TSQL in SQL 2008R2 and Denali (DBI318)

Video Link: http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/DBI318 Important T-SQL features in 2008R2 New date data types including: Date DateTime2 DateTimeOffset Time Merge – “Performs insert, update, or delete operations on a target table based on the results of a join with a source table. … Continue reading

Posted in Database and BI, Technology | Tagged | Leave a comment