https://www.developerfusion.com/t/sql-server/media/view/video/ Video SQL Server Media from Developer Fusion http://www.rssboard.org/rss-specification en-GB Fri, 04 Mar 2011 11:32:00 GMT Amit Goyal and Michael Lisin discuss SQL Server 2008 R2 with Ted Neward. http://www.developerfusion.com/media/76319/sql-server-2008-r2/ http://www.developerfusion.com/media/76319/sql-server-2008-r2/ Mon, 01 Feb 2010 03:47:00 GMT James Crowley SQL Server expert Eric Johnson teaches "Accidental DBAs" the basic building blocks of SQL Server maintenance in a no-nonsense, approachable way.  Topics include installation, database overview, backing up and restoring databases and more. http://www.developerfusion.com/media/70809/sql-server-fundamentals-for-the-accidental-dba/ http://www.developerfusion.com/media/70809/sql-server-fundamentals-for-the-accidental-dba/ Mon, 16 Nov 2009 10:59:00 GMT James Crowley Irina Gorbach and Edward Melomed discuss new features in SQL Server 2008 Analysis Services. Learn how to build enterprise-class OLAP solutions with Analysis Services 2008 rapidly and efficiently. http://www.developerfusion.com/media/48397/microsoft-sql-server-2008-analysis-services-unleashed-video/ http://www.developerfusion.com/media/48397/microsoft-sql-server-2008-analysis-services-unleashed-video/ Fri, 17 Jul 2009 16:30:00 GMT James Crowley SQL Server 2008 has a new extension to the varbinary(max) datatype which allows you to store arbitrary large blobs "in the database" from the perspective of data access and backup but the actual data is stored in the filesystem.In this session we take a look at how we can use FileStream a. http://www.developerfusion.com/media/113716/sql-server-2008-reading-filestream-data/ http://www.developerfusion.com/media/113716/sql-server-2008-reading-filestream-data/ Fri, 04 Mar 2011 11:24:00 GMT James Crowley SQL Server 2008 has a new extension to the varbinary(max) datatype which allows you to store arbitrary large blobs "in the database" from the perspective of data access and backup but the actual data is stored in the filesystem.In this session we follow on from a previous video and take a loo. http://www.developerfusion.com/media/113719/sql-server-2008-writing-data-with-filestream/ http://www.developerfusion.com/media/113719/sql-server-2008-writing-data-with-filestream/ Fri, 04 Mar 2011 11:24:00 GMT James Crowley SQL Server 2008 has two facilities for monitoring changes to a table to facilitate (e.g.) loading of a data warehousing or building an online/offline application with syncronisation capabilities.In this video we take a look at "Change Tracking" which provides notification of net changes made http://www.developerfusion.com/media/113718/sql-server-2008-change-tracking/ http://www.developerfusion.com/media/113718/sql-server-2008-change-tracking/ Fri, 04 Mar 2011 11:24:00 GMT James Crowley SQL Server 2008 (and ADO.NET in .NET Framework V3.5) have a capability whereby you can pass a whole table of data into a stored procedure in one go. Rather than passing XML or a string, multi-valued parameters can be represented quite naturally.In this video, we take a quick look. http://www.developerfusion.com/media/113721/sql-server-2008-table-valued-parameters/ http://www.developerfusion.com/media/113721/sql-server-2008-table-valued-parameters/ Fri, 04 Mar 2011 11:24:00 GMT James Crowley Legendary "Hitchhiker's Guide to Visual Studio and SQL Server," author William R. Vaughn shares valuable lessons and advice on the latest development tools provided by Visual Studio and SQL Server - Part 1 of 2. http://www.developerfusion.com/media/48509/on-microsoft-sql-server-lessons-from-an-architect-with-william-r-vaughn-part-one/ http://www.developerfusion.com/media/48509/on-microsoft-sql-server-lessons-from-an-architect-with-william-r-vaughn-part-one/ Fri, 17 Jul 2009 16:30:00 GMT James Crowley Join host Ted Neward as he discusses scripting with "Adminstrator's Guide to SQL Server 2005" author Buck Woody in part 2 of this series. http://www.developerfusion.com/media/48535/on-microsoft-sql-server-2005-database-administration-with-buck-woody-part-2/ http://www.developerfusion.com/media/48535/on-microsoft-sql-server-2005-database-administration-with-buck-woody-part-2/ Fri, 17 Jul 2009 16:30:00 GMT James Crowley Join host Ted Neward as he discusses scripting with "Adminstrator's Guide to SQL Server 2005" author Buck Woody in part 1 of this series. http://www.developerfusion.com/media/48540/on-microsoft-sql-server-2005-database-administration-with-buck-woody-part-1/ http://www.developerfusion.com/media/48540/on-microsoft-sql-server-2005-database-administration-with-buck-woody-part-1/ Fri, 17 Jul 2009 16:30:00 GMT James Crowley Windows Workflow Foundation comes with its own persistence service that uses SQL Server. However, it is also possible to build your own, and in this session we explore the basics of achieving that. http://www.developerfusion.com/media/113856/windows-workflow-foundation-building-persistence-services/ http://www.developerfusion.com/media/113856/windows-workflow-foundation-building-persistence-services/ Fri, 04 Mar 2011 11:32:00 GMT James Crowley This Screencast shows you how to configure your ASP.NET 2.0 Web application to connect to SQL Server 2005 by using Windows authentication. In addition, this Screencast presents an authorisation pattern for restricting your application's identity within the database. http://www.developerfusion.com/media/113882/aspnet-database-connection/ http://www.developerfusion.com/media/113882/aspnet-database-connection/ Fri, 04 Mar 2011 11:32:00 GMT James Crowley A new feature in SQL Server 2005 allows us to install triggers on Data Definition Language (e.g. when a table is created). This session takes a look. http://www.developerfusion.com/media/113932/working-with-triggers-on-data-definition-language/ http://www.developerfusion.com/media/113932/working-with-triggers-on-data-definition-language/ Fri, 04 Mar 2011 11:32:00 GMT James Crowley Wally talks about the basics of Sql Server 2005 CLR Objects. http://www.developerfusion.com/media/9773/sql-server-2005-clr-objects-basics/ http://www.developerfusion.com/media/9773/sql-server-2005-clr-objects-basics/ Wed, 11 Oct 2006 09:05:00 GMT James Crowley Legendary "Hitchhiker's Guide to Visual Studio and SQL Server," author William R. Vaughn shares valuable lessons and advice on the latest development tools provided by Visual Studio and SQL Server, in part two of this two-part video series. http://www.developerfusion.com/media/11465/sql-server-lessons-from-an-architect-part-2/ http://www.developerfusion.com/media/11465/sql-server-lessons-from-an-architect-part-2/ Wed, 17 Oct 2007 00:00:00 GMT James Crowley Join host Ted Neward as he discusses the SQL server 2005 database administration with "VB Script, WMI, and ADSI" author Don Jones, in part two of this video series. http://www.developerfusion.com/media/11482/inside-scripting-vbscript-wmi-and-adsi-unleashed-part-2/ http://www.developerfusion.com/media/11482/inside-scripting-vbscript-wmi-and-adsi-unleashed-part-2/ Tue, 18 Sep 2007 00:00:00 GMT James Crowley Irina Gorbach and Edward Melomed discuss new features in SQL Server 2008 Analysis Services. Learn how to build enterprise-class OLAP solutions with Analysis Services 2008 rapidly and efficiently. http://www.developerfusion.com/media/11488/microsoft-sql-server-2008-analysis-services-unleashed/ http://www.developerfusion.com/media/11488/microsoft-sql-server-2008-analysis-services-unleashed/ Wed, 17 Dec 2008 00:00:00 GMT James Crowley Amit Goyal discusses Michael Lisin's book, Microsoft SQL Server 2008 Reporting Services, the comprehensive guide to SQL Server 2008 Reporting Services. Learn about the latest features. http://www.developerfusion.com/media/11508/microsoft-sql-server-2008-reporting-services/ http://www.developerfusion.com/media/11508/microsoft-sql-server-2008-reporting-services/ Thu, 08 Jan 2009 00:00:00 GMT James Crowley Join host Ted Neward as he discusses the SQL server 2005 database administration with "VB Script, WMI, and ADSI" author Don Jones, in part one of this video series. http://www.developerfusion.com/media/11517/inside-scripting-vbscript-wmi-and-adsi-unleashed-part-1/ http://www.developerfusion.com/media/11517/inside-scripting-vbscript-wmi-and-adsi-unleashed-part-1/ Tue, 18 Sep 2007 00:00:00 GMT James Crowley Join host Ted Neward as he discusses scripting with "Administrator's Guide to SQL Server 2005" author Buck Woody in part two of this video series. http://www.developerfusion.com/media/11531/sql-server-2005-database-administration-part-2/ http://www.developerfusion.com/media/11531/sql-server-2005-database-administration-part-2/ Tue, 18 Sep 2007 00:00:00 GMT James Crowley