SQL Authority News – Microsoft Whitepaper – SQL Server 2014 and Windows Azure Blob Storage Service: Better Together

azureblog SQL Authority News   Microsoft Whitepaper   SQL Server 2014 and Windows Azure Blob Storage Service: Better TogetherMicrosoft has released SQL Server 2014 earlier this month and now have released very long but interesting white paper on Windows Azure Blog Storage Services. SQL Server Data Files in Windows Azure feature is available in all editions of SQL Server 2014. This feature is enabled by default and at free of cost. This feature makes SQL Server 2014 hybrid cloud database as it provides native support for database files stored as Windows Azure Blobs. If you notice this is a big leap forward where data stored locally as well as on a cloud are accessed by SQL Server 2014 at the same time. You can also host SQL Server Instance in Azure cloud and it can also use the Windows Azure Blobs just like on-premises SQL Server.

Let me give you another example, if you have a situation that you have stored your database files in the cloud as well as backup on Windows Azure Cloud. Now if you want to restore your backup you do not have to bring that back to on-premises before restoring it. You can just restore your data directly from Windows Azure Storage to your SQL Server 2014 instance in a Virtual Machine. It will remove the necessity to do lots of data movement between cloud and on-premises servers.

This white paper discusses exactly the same feature very much in detailed. This white paper has over 116 pages and the size of the word file is 2.5 MB. However, after a long time I have found a Whitepaper which explains concepts from the beginning and walks users step by step with the examples. The appendix file to this Whitepaper contains all the necessary code as well as very interesting reference material. I think I am going to spend my entire weekend reading and learning from this Whitepaper.

Image included in this blog post is courtesy to the same white paper and it explains the story of entire white paper in just one image. Brilliant.

Download the white paper SQL Server 2014 and Windows Azure Blob Storage Service: Better Together.

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

SQL SERVER – SQL Server 2014 Developer Training Kit and Sample Databases

SQL Server 2014 RTM is around the corner (2014). There is plenty of the interest in the SQL Server 2014 in recent time. One of the most frequently asked questions is about learning resources of SQL Server 2014. Everybody wants to learn SQL Server 2014 but there is not enough learning material available currently in the outside world.

Microsoft has released two important resources around it.

SQL Server 2014 Developer Training Kit

The SQL Server 2014 Developer Training Kit includes technical content designed to help you learn how to develop SQL Server 2014 databases, BI Solutions, and gain insights into the new cloud capabilities to simplify cloud adoption for your SQL databases and help you unlock new hybrid scenarios.

SQL Server 2014 Developer Training Kit Sample Databases

This download contains several sample databases for the SQL Server 2014 Developer Training Kit which showcase many of the new and improved features of SQL Server 2014, including Clustered Columnstore, Online Operations, and Resource Governor IO.

Here are few of the key features in SQL Server 2014

  •  Resource Governor IO
  • Online Operations
  • Updatable Columnstore Index
  • In Memory OLTP Engine
  • Enhencements in SSDT and BI tools
  • Power BI Integration

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

SQL SERVER – Writing SQL Queries Made Easy with dbForget SQL Complete

Down with shackles of convention! dbForge SQL Complete 4.5 came in this world.

banner sqlcomplete45 SQL SERVER   Writing SQL Queries Made Easy with dbForget SQL Complete

What does SQL mean for each of us? For some – the only language for working with relational databases. Yet, for others – it is a way of life…

However, when working with SQL queries, both categories of people face the same difficulties.

Eventually, writing queries becomes routine, and all because of imperfection of the built-in Intellisense in SSMS.

The new dbForge SQL Complete 4.5 is called to release everyone from the shackles of convention in SSMS Intellisense and provide more opportunities when working with T-SQL code.

For this, SQL Complete has several key features in its arsenal:

1. Code auto-completion

Because of contextual object tooltips and syntactic elements of the T-SQL language, the productivity of work with SQL Complete is not just rising – it opens on to a qualitatively new level, providing greater opportunities.

Not just a trite hint of tables and columns is ensured. The ability to generate foreign key relationships, aliases, and many other things…

ii04 SQL SERVER   Writing SQL Queries Made Easy with dbForget SQL Complete

Object hints are provided in such a big number of structures, that an incomplete list of them can be learned only on a separate page.

2. SQL Formatter

Features of the SQL Formatter embedded in dbForge SQL Complete will allow to forget about manual query editing forever.

Using the SQL Formatter, your code will always be perfect due to a huge number of settings, that allow to customize formatting of all SQL constructs according to your personal preferences.

ii06 SQL SERVER   Writing SQL Queries Made Easy with dbForget SQL Complete

Moreover, there is a possibility to format not only the current document or selected code fragment, but groups of files on the disk as well.

3. Snippets

Code reuse through snippets is a perfect opportunity to accelerate the process of writing code.

As Devart developers said, their analysis of more than 5.000 topical posts from authoritative resources such as StackOverflow had shown that the list of basic snippets was significantly extended to prevent users from typing frequently used T-SQL statements.

Besides, owing to the Snippet Manager, users can easily extend the set of existing snippets.

ii05 SQL SERVER   Writing SQL Queries Made Easy with dbForget SQL Complete

When typing code, a required snippet can be selected by capital letters:

ii02 SQL SERVER   Writing SQL Queries Made Easy with dbForget SQL Complete

and by match with the snippet’s name:

ii03 SQL SERVER   Writing SQL Queries Made Easy with dbForget SQL Complete

4. Auto-refresh after update schema changes

On active schema changing, many encounter a situation when new or modified objects are not suggested in SSMS Intellisense. For this, you have to manually refresh the object list.

But all that is in the past, since in the version 4.5, there is a capability of smart refresh of hints for modified objects only at specified time intervals.

ii01 SQL SERVER   Writing SQL Queries Made Easy with dbForget SQL Complete

Within the dbForge SQL Complete 4.5 release, I would like to bring to your attention that memory consumption is reduced and objects describing is now much faster.

All these improvements are aimed to ensure that our users to be able to enjoy work and perform it without delays.

To support words with deeds, I recommend users to re-discover the wonderful world of SQL with dbForge SQL Complete 4.5.

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

SQL SERVER – Download SQL Server 2014 CTP2 and Related Downloads

SQL Server 2014 CTP2 was announced quite a while ago. I still see very few people working on it or writing about it. There can be many reasons for not attempting to start with SQL Server 2014 but the reality is that it is coming in the next few months and it will be here before we know it. Today is December 1, 2013 and in one month we will be in the year 2014. SQL Server 2014’s release cycle will announce its GA very soon and if we have not started with SQL Server 2014 we will be a bit late for sure. Here are few of the downloads related to SQL Server 2014.

 SQL SERVER   Download SQL Server 2014 CTP2 and Related Downloads

Feel free to download them and experiment with SQL Server 2014.

Microsoft SQL Server 2014 Community Technology Preview 2 (CTP2)
Microsoft SQL Server 2014 brings to market new in-memory capabilities built into the core database, including in-memory OLTP, which complements our existing in-memory data warehousing and BI capabilities for the most comprehensive in-memory database solution in the market. SQL Server 2014 also provides new cloud capabilities to simplify cloud adoption for your SQL databases and help you unlock new hybrid scenarios.

Microsoft SQL Server 2014 Data Tools – Business Intelligence for Microsoft Visual Studio 2012, Community Technology Preview 2 (CTP2)
Installs the Microsoft SQL Server 2014 CTP2 Data Tools Business Intelligence project templates for Analysis Services, Integration Services, and Reporting Services.

Microsoft Data-Tier Application Framework for SQL Server 2014 CTP2
The Microsoft Data-Tier Application Framework for SQL Server 2014 CTP2 provides application lifecycle services for database development and management.

Microsoft SQL Server Data Tools for SQL Server 2014CTP2
SQL Server Data Tools provides an integrated environment for database developers to carry out all their database design work for any SQL Serverplatform within Visual Studio.

Microsoft SQL Server 2014 CTP2 Product Guide
Download the datasheets, white papers and technical presentations that will help you evaluate Microsoft SQL Server 2014 CTP2.

Microsoft SQL Server 2014 Reporting Services Add-in for Microsoft SharePoint, Community Technology Preview 2 (CTP2)
The SQL Server 2014 CTP2 Reporting Services Add-in for Microsoft SharePoint technologies allows you to integrate Reporting Services features with the collaborative SharePoint experience.

Microsoft SQL Server 2014 PowerPivot for Microsoft SharePoint 2013, Community Technology Preview 2 (CTP2)
Microsoft SQL Server 2014 PowerPivot for SharePoint 2013, CTP2 extends SharePoint Server 2013 to add server-side data refresh processing, collaboration, and management support for PowerPivot workbooks.

Here is the question for you – Have you installed SQL Server 2014 CTP R2?

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

SQL SERVER – Download FREE PDFs from SQLAuthority.com

Throughout the last seven years, we have created many PDF downloads from SQLAuthority.com and many are very much appreciated by users. I just wanted to list all the downloads which we have created so far in a single place, hence here is the blog post which contains all the PDF downloads which we have created so far.

SQL Server Interview Questions and Answers Download
Beginning Big Data with NuoDB
SQL Server Management Studio Keyboard Shorts Download
SQL Server 2008 Certification Path Complete Download
SQL Server Cheat Sheet Download
SQL Server Database Coding Standards and Guidelines Complete List Download
SQL Server Indexing Checklist

download now button SQL SERVER   Download FREE PDFs from SQLAuthority.com

Let me know which one of the PDF you like the most and if you expect us to create any more PDF articles. Leave a comment.

Additionally, we have created various script bank for all the script which has been used on SQLAuthority.com so far. You can get access to the scripts by clicking on following link.

SQLAuthority.com Scripts Download

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

SQL – Download NuoDB and Qualify for FREE Amazon Gift Cards

nuodb bird logo SQL   Download NuoDB and Qualify for FREE Amazon Gift Cards

July has been a fantastic month and Team NuoDB has really appreciated the active participation of the SQLAuthority.com active reader base.

Earlier we had launched two contests with NuoDB and both of them are very much appreciated by readers. There are constant demands of more contests and team NuoDB is very much excited to support more contests.

Here are the details to constests ran earlier:

Based on the earlier successful contests, the kind folks at NuoDB decided that they will support one more round of the giveaways to SQLAuthority.com contests. However, please note that this month’s contest will end in next 48 hours. You have to take part before July 31st, 2013 11:59:00 PM PST.

Here is the quick contest:

amazoncard SQL   Download NuoDB and Qualify for FREE Amazon Gift CardsYou just have to go and download NuoDB. The first 10 people who will download the NuoDB will get Amzon USD 10 cards. Remaining everyone will be entered into a lucky draw of Amazon Gift cards of USD 50. Winners will be announced in next 24 hours. To eligible for this contest, please download NuoDB before July 31st, 2013 11:59:00 PM PST.

Bonus Round:

If you have entered in the contest above, you can also enter to win latest Beginning SSRS Joes 2 Pros book. You just have to leave a comment over here with the note about how many different platform NuoDB supports.

Here are few of the blog post I wrote earlier on that subject:

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

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

settings SQL SERVER   Drivers for PHP, JDBC, ODBC and OLE DBA 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)

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

nuodbcheatsheet SQL   Download Database Cheat Sheet for MongoDB, NuoDB, MySQL for FREEIn 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

ilovesamples SQL SERVER   List of All the Samples Database Available to Download for FREEIt 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.

SQL Server 2014 CTP1 Product Guide SQL SERVER   Microsoft SQL Server 2014 CTP1 Product Guide

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)