SQL SERVER – Drivers for PHP, JDBC, ODBC and OLE DB

A driver is software that allows your computer to communicate with hardware, devices or other software. Without drivers, the software or hardware you connect to your computer will not work properly.

Here is the list of the drivers which are available for SQL Server to connect from multiple applications and programming language.

Microsoft JDBC Driver 4.0 for SQL Server
The JDBC driver can access many of the features including database mirroring; the xml, user-defined, and large-value data types; and it supports the new “snapshot” transaction isolation.

Microsoft Drivers for PHP for SQL Server
The Microsoft Drivers for PHP for SQL Server API includes support for Windows Authentication, transactions, parameter binding, streaming, metadata access, and error handling.

Microsoft ODBC Driver for SQL Server
The Microsoft ODBC Driver for SQL Server is comprised of an ODBC driver for Windows and an ODBC driver for Linux.

Microsoft OLE DB Provider for DB2 Version 4.0
The Data Provider takes advantage of Microsoft SQL Server data access architecture together with a Microsoft network client for DB2 that functions as a Distributed Relational Database Architecture (DRDA) application requester. The Data Provider converts the Microsoft Component Object Model (COM) OLE DB commands and data types to DRDA protocol code points and data formats.

Reference: Pinal Dave (http://blog.sqlauthority.com)

About these ads

SQL – Download Database Cheat Sheet for MongoDB, NuoDB, MySQL for FREE

In the new database world there are so many different solutions, vendors and options available that it is super hard to figure out which database is the right solution for us. First of all the world of the big data itself is very confusing. It is so hard to figure out from where to start and where to stop. There are so many tutorials out but none of them addresses the need of the absolute beginner.

Now the same thing goes to the next level when one has to select the right database for their organization and there is no clear guidance. I was discussing the same thing with the NuoDB folks last month. The NuoDB is a great product, but it is extremely important to know where exactly NuoDB stands when compared with other product. Interesting enough the smart folks at NuoDB has come up with a Cheat Sheet which compares NuoDB with the other industry known database.

The best part is that even though we do not have enough time for learning all the other database in depth, it is totally possible to take 60 seconds of the time and see the comparison of the features in this cheatsheet.

Download “The Decision Maker’s Cheat Sheet” to compare NuoDB, MySQL and MongoDB on:

SQL / ACID transactions
Distributed Multi-version Concurrency Control (MVCC)
Elastic scale-out performance
Integration with existing tools and frameworks
Geo-distributed data management

Reference: Pinal Dave (http://blog.sqlauthority.com)

SQL SERVER – List of All the Samples Database Available to Download for FREE

It is pretty much very common to have a sample database for any database product. Different companies keep on improving their product and keep on coming up with innovation in their product. To demonstrate the capability of their new enhancements they need the sample database. Microsoft have various sample database available for free download for their SQL Server Product. I have collected them here in a single blog post.

Download an AdventureWorks Database
The AdventureWorks OLTP database supports standard online transaction processing scenarios for a fictitious bicycle manufacturer (Adventure Works Cycles). Scenarios include Manufacturing, Sales, Purchasing, Product Management, Contact Management, and Human Resources.

Coconut Dal
Coconut Dal is a lightweight data access layer, for use in projects where the Entity Framework cannot be used or Microsoft’s Enterprise Library Data Block is unsuitable. Anyone who is handwriting ADO.NET should use a library instead and Coconut Dal might be the answer. 

DataBooster – Extension to ADO.NET Data Provider
The dbParallel DataBooster library is a high-performance extension to ADO.NET Data Provider, includes two aspects: 1) A slimmed down API encapsulation which simplified the most common data access operations (DbConnection -> DbCommand -> DbParameter -> DbDataReader) into a single class DbAccess, to help application with a clean DAL, avoid over-packing and redundant-copy of data transfer. 2) A booster for writing mass data onto database. Base on a rational utilization of database concurrency and a effective utilization of network bandwidth.

Tabular AMO 2012
The sample is made of two project parts. The first part is a library of functions to manage tabular models -AMO2Tabular V2-. The second part is a sample to build a tabular model -AdventureWorks Tabular AMO 2012- using the AMO2Tabular library; the created model is similar to the ‘AdventureWorks Tabular Model 2012.

SQL Server Analysis Services Product Samples
SQL Server Analysis Services provides, a unified and integrated view of all your business data as the foundation for all of your traditional reporting, online analytical processing (OLAP) analysis, Key Performance Indicator (KPI) scorecards, and data mining.

Analysis Services Samples for SQL Server 2008 R2
This release is dedicated to the samples that ship for Microsoft SQL Server 2008R2. For many of these samples you will also need to download the AdventureWorks family of databases.

SQL Server Reporting Services Product Samples
This project contains Reporting Services samples released with Microsoft SQL Server product. These samples are in the following five categories: Application Samples, Extension Samples, Model Samples, Report Samples, and Script Samples. If you are interested in contributing Reporting Services samples, please let us know by posting in the developers’ forum.

Reporting Services Samples for SQL Server 2008 R2
This release is dedicated to the samples that ship for Microsoft SQL Server 2008 R2 PCU1. For many of these samples you will also need to download the AdventureWorks family of databases.

SQL Server Integration Services Product Samples
This project contains Integration Services samples released with Microsoft SQL Server product. These samples are in the following two categories: Package Samples and Programming Samples. If you are interested in contributing Integration Services samples, please let us know by posting in the developers’ forum.

Integration Services Samples for SQL Server 2008 R2
This release is dedicated to the samples that ship for Microsoft SQL Server 2008R2. For many of these samples you will also need to download the AdventureWorks family of databases.

Windows Azure SQL Reporting Admin Sample
The SQLReportingAdmin sample for Windows Azure SQL Reporting demonstrates the usage of SQL Reporting APIs, and manages (add/update/delete) permissions of SQL Reporting users.

Windows Azure SQL Reporting ReportViewer-SOAP API usage sample
These sample projects demonstrate how to embed a Microsoft ReportViewer control that points to reports hosted on SQL Reporting report servers and how to use SQL Reporting SOAP APIs in your Windows Azure Web application.

Enterprise Library 5.0 – Integration Pack for Windows Azure
This NuGet package contains a zip file with the source code for the Enterprise Library Integration Pack for Windows Azure. 

Reference: Pinal Dave (http://blog.sqlauthority.com)

SQL SERVER – Microsoft SQL Server 2014 CTP1 Product Guide

Today in User Group meeting there were lots of questions related to SQL Server 2014. There are plenty of people still using SQL Server 2005 but everybody is curious about what is coming in SQL Server 2014.  Microsoft has officially released SQL Server 2014 CTP1 Product Guide. You can easily download the product guide and explore various learning around SQL Server 2014 as well explore the new concepts introduced in this latest version.

This SQL Server 2014 CTP1 Product Guide contains few interesting White Papers, a Datasheet and Presentation Deck.

Here is the list of the white papers:

  • Mission-Critical Performance and Scale with SQL Server and Windows Server
  • Faster Insights from Any Data
  • Platform for Hybrid Cloud
  • SQL Server In-Memory OLTP Internals Overview for CTP1
  • SQL Server 2014 CTP1 Frequently Asked Questions for TechEd 2013 North America

Here is the list of slide decks:

  • SQL Server 2014 Level 100 Deck
  • SQL Server 2014 Mission Critical Performance LEvel 300 Deck
  • SQL Server 2014 Faster Insights from Any Data Level Level 300 Deck
  • SQL Server 2014 Platform for Hybrid Cloud Level 100 Deck

I have earlier downloaded the Product Guide and I have yet not completed reading everything SQL Server 2014 has to offer. If you want to read what are the features which I am going to use in SQL Server 2014, you can read over here.

Download Microsoft SQL Server 2014 CTP1 Product Guide

Reference: Pinal Dave (http://blog.sqlauthority.com)

SQLAuthority News – Download PowerPivot or PowerView enabled Workbook Optimizer – Download SQL Server Connector for Apache Hadoop

Earlier this week Microsoft have released two very interesting downloads which got my attention. Haddop, PowerPivot and PowerView all three are not directly related to traditional RDBMS but their important is growing in the industry as big data is taking over market.

The Microsoft SQL Server SQOOP Connector for Hadoop is now part of Apache SQOOP 1.4 and we are not providing a separate download anymore. Please note that Microsoft’s HDInsight service includes the connector as well. Linux (for Hadoop setup) and Windows (with SQL Server 2008 R2 installed). Both are required to use the SQL Server-Hadoop Connector.

With SQL Server-Hadoop Connector, you import data from:

  • tables in SQL Server to delimited text files on HDFS
  • tables in SQL Server to SequenceFiles files on HDFS
  • tables in SQL Server to tables in Hive
  • result of queries executed on SQL Server to delimited text files on HDFS
  • result of queries executed on SQL Server to SequenceFiles files on HDFS
  • result of queries executed on SQL Server to tables in Hive

With SQL Server-Hadoop Connector, you can export data from:

  • delimited text files on HDFS to SQL Server
  • sequenceFiles on HDFS to SQL Server
  • hive Tables

Download instruction for SQL Server Connector for Apache Hadoop

The Workbook Size optimizer for Excel can better compress data inside workbooks that use PowerPivot or PowerView if this data comes from external data sources. The best size compression can be achieved for workbooks based on SQL Server databases and there are a few tricks we can do for other SQL datasources as well. The optimizer will install as an add in to excel and will provide you with a nice wizard to better compress the size of your workbook. Using the optimizer you can often get more than 1,000,000 rows datasets in a workbook under 10 MB, share it in SharePointOnline and interact with it using the Excel Web App in any browser.

Download PowerPivot or PowerView enabled Workbook Optimizer

(Courtesy Microsoft Downloads)

Reference: Pinal Dave (http://blog.sqlauthority.com)

 

SQL SERVER – Three Important Documentation to download – Standards Support, Protocol, Data Portability

SQL Server Standards Support Documentation

If you are new to the documentation set or new to Microsoft SQL Server, reading the SQL Server system overview document will help familiarize you with the organization of the documentation set as well as with SQL Server concepts and how the protocols relate to each other.

The SQL Server standards support documentation provides detailed support information for certain standards that are implemented in Microsoft SQL Server.

Download Now

Microsoft SQL Server Protocol Documentation

The Microsoft SQL Server protocol documentation provides technical specifications for Microsoft proprietary protocols that are implemented and used in Microsoft SQL Server 2008. This whitepaper provides an overview of the client and server protocols used by Microsoft SQL Server. It covers protocols that are commonly shared by SQL Server components and protocols that are used only by specific SQL Server components. Where appropriate, the document describes the relationships between protocols and provides example scenarios to show how they are used.

Download Now

Microsoft SQL Server Data Portability Documentation

The SQL Server data portability documentation explains various mechanisms by which user-created data in SQL Server can be extracted for use in other software products. These mechanisms include import/export functionality, documented APIs, industry standard formats, or documented data structures/file formats. This whitepaper provides an overview of the client and server protocols used by Microsoft SQL Server. It covers protocols that are commonly shared by SQL Server components and protocols that are used only by specific SQL Server components. Where appropriate, the document describes the relationships between protocols and provides example scenarios to show how they are used.

Download Now

Reference: Pinal Dave (http://blog.sqlauthority.com)

SQL SERVER – Download Microsoft PowerPivot for Excel 2010 and PowerPivot in Excel 2013 Samples

Learning any technology is easy when we have good documentation and sample database to play along with. When I have to learn any new technology, my first action is to install the trial software and look for sample database next. Once I get sample database, I try to find a video tutorial about the technology and continue to learn onwards.

Recently Microsoft has released the samples for PowerPivot in Excel. This is excellent as this gives opportunity to developer to play with the sample and learn all the features without worrying about building a sample which can work with all the features. PowerPivot empowers users of all levels to access and mashup data from virtually any source. Users can create their own compelling reports and analytical applications, easily share insights, and collaborate with colleagues through Microsoft Excel and SharePoint.

If you open a sample for PowerPivot for Excel 2010 in PowerPivot in Excel 2013, you will get a notification stating you must upgrade the data model in the workbook. You cannot open a sample for PowerPivot in Excel 2013 data model in PowerPivot for Excel 2010. In sample database there are two different files 1) PowerPivotExamplesExcel2010.zip and 2) PowerPivotExamplesExcel2013.zip

Each sample file contains three Business Intelligence samples:

  • PowerPivot Healthcare Audit.xlsx
  • PowerPivot Tutorial Sample.xlsx
  • LCA BI – Financial Report Usage.xlsx

Download Microsoft PowerPivot for Excel 2010 and PowerPivot in Excel 2013 Samples

Reference: Pinal Dave (http://blog.sqlauthority.com)