Posts filed under: SQL Server

What is R ?

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 →

Analytics with the Power BI client JavaScript API

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 →

Introducing Microsoft SQL Server 2014

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 →

Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud, Preview 2

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

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

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 →

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...
Continue Reading →

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 with the available resources and tools. This topic introduces the...
Continue Reading →

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 LocalDB) I have updated the comparison table from the excellent...
Continue Reading →

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 was successfully established with the server, but then an error...
Continue Reading →

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 ...
Continue Reading →

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 embedded database development efforts, including scripting of...
Continue Reading →

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 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes...
Continue Reading →

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, select the project Step2: Add installer class O; ata ...
Continue Reading →

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 in online transactional processing (OLTP) and data-warehouse...
Continue Reading →

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 are using Power BI. See Power BI get down to...
Continue Reading →

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 you can transform and combine for easier analysis. ...
Continue Reading →
Show Buttons
Hide Buttons