https://www.developerfusion.com/t/sql-server/ Latest SQL Server developer content from Developer Fusion http://www.rssboard.org/rss-specification en-GB Mon, 16 Jul 2012 10:53:27 GMT Carl and Richard talk to J Sawyer about StreamInsight. Part of the SQL Server platform, StreamInsight is a stand-alone install that allows you to do complex event processing (CEP) applications. Complex Event Processing is a pattern of dealing highly parallel, high velocity data streams to do real. http://www.developerfusion.com/media/144625/j-sawyer-does-complex-event-processing-with-streaminsight/ http://www.developerfusion.com/media/144625/j-sawyer-does-complex-event-processing-with-streaminsight/ Mon, 16 Jul 2012 10:53:27 GMT James Crowley In this extract from Beginning Microsoft SQL Server 2012 Programming, the authors demonstrate how to create a 'simple' OLAP cube using the AdventureWorks database as the data source http://www.developerfusion.com/article/143031/building-your-first-data-cube/ http://www.developerfusion.com/article/143031/building-your-first-data-cube/ Fri, 11 May 2012 12:46:02 GMT Dan Maharry We have several spots open for top notch .NET / C# / MVC developers to join our team as we continue to change the face of online recruiting. The base technology set is Microsoft-centric (.NET / C# / SQL Server / MVC) http://www.developerfusion.com/job/134600/net-web-developer/ http://www.developerfusion.com/job/134600/net-web-developer/ Wed, 14 Dec 2011 14:24:02 GMT Chris Piazza Windows PowerShell transformed the way administrators and developers interact with Windows, allowing them to script administrative tasks and control Windows from the command line. It's now a daily timesaver for anyone working with Windows Server, Exchange Server, SQL Server, and other mission-critical tools. http://www.developerfusion.com/book/134299/windows-powershell-in-action-second-edition/ http://www.developerfusion.com/book/134299/windows-powershell-in-action-second-edition/ Thu, 08 Dec 2011 04:48:43 GMT Bruce Payette Feature-complete and production-ready database ready for user testing http://www.developerfusion.com/news/133327/sql-server-2012-release-candidate-arrives/ http://www.developerfusion.com/news/133327/sql-server-2012-release-candidate-arrives/ Mon, 28 Nov 2011 17:23:20 GMT Chris Alexander Split your apps between on-site and the cloud http://www.developerfusion.com/news/130794/sql-azure-data-sync-opens-up/ http://www.developerfusion.com/news/130794/sql-azure-data-sync-opens-up/ Mon, 17 Oct 2011 08:57:02 GMT Chris Alexander Big Data in the Cloud http://www.developerfusion.com/news/130253/apache-hadoop-coming-to-azure/ http://www.developerfusion.com/news/130253/apache-hadoop-coming-to-azure/ Thu, 13 Oct 2011 13:13:28 GMT Chris Alexander You learn a lot when thrown into a crisis situation, where everyone is looking to you for answers. The system is down, the CEO is pleading to you for answers as the each minute cuts the company’s bottom line. When you are in a hurry, you need some new ideas right away. This book is your helpful tool. When used correctly, you can determine solutions and even related solutions to simple (yet lesser known) areas of SQL Server. Learn what causes SQL tasks to wait or site in queues. http://www.developerfusion.com/book/128156/sql-wait-stats-joes-2-pros-sql-performance-tuning-techniques-using-wait-statistics-types-queues/ http://www.developerfusion.com/book/128156/sql-wait-stats-joes-2-pros-sql-performance-tuning-techniques-using-wait-statistics-types-queues/ Mon, 19 Sep 2011 12:54:14 GMT Pinal Dave, Rick Morelan Roger Hart looks back at Red Gate's inclusion of SQL Azure into its database applications, the issues they encountered and the solutions they created http://www.developerfusion.com/article/124751/to-the-cloud-moving-red-gate-tools-to-sql-azure/ http://www.developerfusion.com/article/124751/to-the-cloud-moving-red-gate-tools-to-sql-azure/ Tue, 23 Aug 2011 20:27:01 GMT Roger Hart Pro Access 2010 Development is a fundamental resource for developing business applications that take advantage of the features of Access 2010 and the many sources of data available to your business. In this book, you'll learn how to build database applications, create Web-based databases, develop macros and Visual Basic for Applications (VBA) tools for Access applications, integrate Access with SharePoint and other business systems, and much more. http://www.developerfusion.com/book/124153/pro-access-2010-development/ http://www.developerfusion.com/book/124153/pro-access-2010-development/ Sun, 14 Aug 2011 19:19:48 GMT Mark Collins In the age of Object Relational Mapping frameworks (ORMs) it seems unusual to ever get 'close to the metal' when it comes to persisting data. However, when you need to squeeze the last ounce of performance out of your app - it can make sense to go under the covers. http://www.developerfusion.com/article/122498/using-sqlbulkcopy-for-high-performance-inserts/ http://www.developerfusion.com/article/122498/using-sqlbulkcopy-for-high-performance-inserts/ Tue, 19 Jul 2011 10:53:44 GMT Mike Goatly Expert Oracle GoldenGate is a hands-on guide to creating and managing complex data replication environments using the latest in database replication technology from Oracle. GoldenGate is the future in replication technology from Oracle, and aims to be best-of-breed. GoldenGate supports homogeneous replication between Oracle databases. It supports heterogeneous replication involving other brands such as Microsoft SQL Server and IBM DB2 Universal Server. http://www.developerfusion.com/book/122470/expert-oracle-goldengate/ http://www.developerfusion.com/book/122470/expert-oracle-goldengate/ Mon, 18 Jul 2011 16:55:26 GMT Ben Prusinski, Steve Phillips, Richard Chung Improvements to the latest SQL Server release and juicy new previews http://www.developerfusion.com/news/122217/sql-server-denali-ctp3-and-2008-r2-sp1-land/ http://www.developerfusion.com/news/122217/sql-server-denali-ctp3-and-2008-r2-sp1-land/ Thu, 14 Jul 2011 09:18:16 GMT Chris Alexander The most common giveaway a user experiences when an enterprise application has been moved to the cloud is the sudden appearance of a username/password dialogue box. http://www.developerfusion.com/article/121561/integrating-active-directory-into-azure/ http://www.developerfusion.com/article/121561/integrating-active-directory-into-azure/ Mon, 04 Jul 2011 12:48:20 GMT Steve Plank The SQL developer needs to be able to create processes for the working database by using one of the many programming objects (like functions, stored procedures, constrains, or triggers). By creating objects that talk with SQL you simply the way other programs (like applications or web pages) can interconnect. These eternal programs only need to call on the names of your programming objects by name rather than needing to submit large pieces of advance code. http://www.developerfusion.com/book/121505/sql-programming-joes-2-pros-programming-development-for-microsoft-sql-server-2008-sql-exam-prep-series-70433-volume/ http://www.developerfusion.com/book/121505/sql-programming-joes-2-pros-programming-development-for-microsoft-sql-server-2008-sql-exam-prep-series-70433-volume/ Sat, 02 Jul 2011 16:13:02 GMT Rick A. Morelan Neil Mackenzie looks at where Windows Azure fits among the various cloud computing offerings in the wild today, and also at the four key areas of Azure that new developers will need to be aware of when they start their first project. http://www.developerfusion.com/article/119329/introduction-to-windows-azure-what-you-should-know/ http://www.developerfusion.com/article/119329/introduction-to-windows-azure-what-you-should-know/ Tue, 31 May 2011 12:16:04 GMT Neil Mackenzie This episode of Herding Code Kevin and Jon sit down with Geoff and Jarrod at MIX to talk about their experiences from helping to build the first StackOverflow site up through today’s fast paced world of StackExchanges and gold plated Lamborghinis. Note: We recorded in quietest spot we could find http://www.developerfusion.com/media/118443/herding-code-110-geoff-dalgas-and-jarrod-dixon-take-us-behind-the-scenes-at-stackexchange/ http://www.developerfusion.com/media/118443/herding-code-110-geoff-dalgas-and-jarrod-dixon-take-us-behind-the-scenes-at-stackexchange/ Sat, 07 May 2011 12:21:54 GMT James Crowley Nearly a year after announcement, Beta 2 finally arrives for business developers http://www.developerfusion.com/news/115800/visual-studio-lightswitch-reaches-beta-2/ http://www.developerfusion.com/news/115800/visual-studio-lightswitch-reaches-beta-2/ Fri, 25 Mar 2011 12:51:49 GMT Chris Alexander Get the critical, in-depth information you need to administer SharePoint 2010. Led by SharePoint MVPs and featuring insights from the SharePoint community and members of the SharePoint Team at Microsoft, you'll discover how to plan, design, deploy, and manage strategic solutions using SharePoint 2010, Microsoft SQL Server®, Windows PowerShell™, and other key technologies.The two books included in this kit are: *9780735627222 SharePoint® 2010 Administrator’s Pocket Consultant http://www.developerfusion.com/book/92668/microsoft-sharepoint-administrators-kit-microsoft-sharepoint-2010-administrators-pocket-consultant-microsoft-s/ http://www.developerfusion.com/book/92668/microsoft-sharepoint-administrators-kit-microsoft-sharepoint-2010-administrators-pocket-consultant-microsoft-s/ Tue, 01 Mar 2011 20:04:13 GMT Ben Curry, Bill English, Brian Alderman, Mark Ferraz Git deployment of web applications made easier than Azure http://www.developerfusion.com/news/94429/appharbor-aims-to-become-heroku-for-net-but-faces-stiff-competition/ http://www.developerfusion.com/news/94429/appharbor-aims-to-become-heroku-for-net-but-faces-stiff-competition/ Tue, 01 Mar 2011 20:04:13 GMT Chris Alexander