Posts filed under: SQL Server

Happy Learning SSIS. SSIS 2008 Series:Introduction to SSIS 2008 SSIS 2008 Series: Transferring data from File to Database SSIS 2008 Series: The For-Each Enumerator SSIS 2008 series:Introduction to variables SSIS 2008 Series:Using Webservices in SSIS Packages ...
Continue Reading →
Studying for the Microsoft Certified Solutions Associate MCSA) certification for SQL Server 70-461 exam - http://spr.ly/6187j1sc 70-462 exam - http://spr.ly/6188j1sY 70-463 exam - http://spr.ly/6189j1sl ...
Continue Reading →
To help supplement your MCSA: SQL Server 2012 training, Microsoft Learning presents this series of video reviews of exam objectives and tips, led by Microsoft Certified Trainers -More database certification exam prep resources- Exam Prep Videos: ...
Continue Reading →
To help supplement your MCSA: SQL Server 2012 training, Microsoft Learning presents this series of video reviews of exam objectives and tips, led by Microsoft Certified Trainers -More database certification exam prep resources- Exam Prep Videos: ...
Continue Reading →
To help supplement your MCSA: SQL Server 2012 training, Microsoft Learning presents this series of video reviews of exam objectives and tips, led by Microsoft Certified Trainers -More database certification exam prep resources- Exam Prep Videos: ...
Continue Reading →
This series is the result of effort from a lot of different people. Here is a list of those responsible for getting this series produced and online. by Microsoft Learning – Certification and Training   Episode 1 SQL Saturday.Dublin, Ireland...
Continue Reading →
Kits for you, including: SharePoint 2013, Office 2013, Office 365, Duet 2.0, Azure, Cloud, Windows Phone, Lync, Dynamics CRM, and more. Microsoft Dynamics GP 2010 Guides: Financials Microsoft Dynamics CRM 2011 User's Guide Microsoft Lync Server 2010 Resource Kit Tools...
Continue Reading →
R is a programming language and an open-source statistical computing environment used for statistical computing. Derived from the language S (for statistics), R is a GNU project and as such is free software that compiles and runs on a wide...
Continue Reading →
See how you can add contextual analytics to your application by using the new Power BI client JavaScript API. With the JavaScript API, you can easily make application analytics responsive to your application workflows so your users can achieve more....
Continue Reading →
Ross Mistry and Stacia Misner In this book, the authors explain how SQL Server 2014 incorporates in-memory technology to boost performance in online transactional processing (OLTP) and data-warehouse solutions. They also describe how it eases the transition from on-premises solutions...
Continue Reading →
Stacia Varga, Denny Cherry, and Joseph D’Antoni With Microsoft SQL Server 2016, a variety of new features and enhancements to the data platform deliver breakthrough performance, advanced security, and richer, integrated reporting and analytics capabilities. In this Preview 2 ebook,...
Continue Reading →
Paging through a query result is the process of returning the results of a query in smaller subsets of data, or pages. This is a common practice for displaying results to a user in small, easy-to-manage chunks. The DataAdapter provides a facility...
Continue Reading →
Retrieving data using a DataReader involves creating an instance of the Command object and then creating a DataReader by calling Command.ExecuteReader to retrieve rows from a data source. The following example illustrates using a DataReader where readerrepresents a valid DataReader and command represents a valid Command object. reader = command.ExecuteReader(); You use the Read method...
Continue Reading →
  Find out about the different ways you can use Entity Framework to access a relational database from your .NET application. Presented By: Rowan Miller...
Continue Reading →
Windows Azure SQL database Backup and Restore Strategy: Overall Introduction: Backing up and restoring data is different in Windows Azure SQL Database than an on-premise SQL Server and must work with the available resources and tools. This topic introduces the...
Continue Reading →
Now that SQL Server 2014 and SQL Server Compact 4 has been released, some developers are curious about the differences between SQL Server Compact 4.0 and SQL Server Express 2014 (including LocalDB) I have updated the comparison table from the excellent...
Continue Reading →
Show Buttons
Hide Buttons