Posts filed under: SQL Server

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 Originally posted 2016-08-29 20:49:17....
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 →
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 was successfully established with the server, but then an error...
Continue Reading →
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 ...
Continue Reading →
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 embedded database development efforts, including scripting of...
Continue Reading →
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 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes...
Continue Reading →
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, select the project Step2: Add installer class O; ata ...
Continue Reading →
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 in online transactional processing (OLTP) and data-warehouse...
Continue Reading →
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 are using Power BI. See Power BI get down to...
Continue Reading →
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 you can transform and combine for easier analysis. ...
Continue Reading →
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) ...
Continue Reading →
Applies to: SQL Server 2012 SQL Server 2012 Books Online Applies to: SQL Server 2012 SQL Server 2012 Books Online Applies to: SQL Server 2012 SQL Server 2012 Books Online Applies to: SQL Server 2012 SQL Server 2012 Books Online...
Continue Reading →
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 →
Show Buttons
Hide Buttons