Paging Through a Query Result
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…
Retrieving Data Using a DataReader
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…
Entity Framework Development Workflows
Find out about the different ways you can use Entity Framework to access a relational database from your .NET application. Presented By: Rowan Miller
Different ways to Backup your Windows Azure SQL Database
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…
SQL Server Compact, SQLite, SQL Server Express or LocalDB ??
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…
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 – The handle is invalid.
During the development of solutions or the deployment using Visual studio, you might face the following error when using Entity Framework to connect to a SQL Server instance A connection…
SSIS ERROR – The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available
In order to fix the import issue from Excel file in a 64Bits environment using SSIS, just click project properties and turn the Run64BitRunTime to False. Good luck guys
SQL Server Compact and SQLite Toolbox
In this episode, Robert is joined by Erik Ejlskov Jensen, author of the SQL Server Compact & SQLite Toolbox extension for Visual Studio This extension adds several features to help your…
Differences Between SQL Server Compact and SQL Server
SQL Server Compact 3.5 SP2 SQL Server Compact 4.0 SQL Server SQL Server 2014 LocalDB Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes…
Install sql server database with visual studio setup
Generally, It is required to install sql server database with visual studio setup Here are the steps to install sql server database with setup using custom action. In Solution Explorer,…
Introducing Microsoft SQL Server 2014
Introducing Microsoft SQL Server 2014 Ross Mistry and Stacia Misner April 2014 125 pages In this book, the authors explain how SQL Server 2014 incorporates in-memory technology to boost performance…
Power BI – Microsoft Business Intelligence
Power BI by Function Power BI for Finance Learn more Power BI for Sales and Marketing Power BI for Operations and Logistics Power BI for HR See how our customers…
Discover with Power BI for Office 365
Easily discover and connect to data with Power Query New capabilities such as online search return relevant data sets from across your organization and from valuable public data sources, which…
The power of Microsoft Business Intelligence
Power BI includes new technologies in Excel that include Power Query, Power Map, Power View and Power Pivot The files for this presentation are here: http://sdrv.ms/1a2xTDj (Hurricane Sandy, Napoleon, Hans Rosling)
