Translate

Monday, June 24, 2013

Saturday, June 22, 2013

Huge collection of Free Microsoft SQL Server eBooks

image
5 Tips for a Smooth SSIS Upgrade to SQL Server 2012
EPUB
MOBI
PDF
image
A Hitchiker's Guide to Microsoft StreamInsight Queries
EPUB
MOBI
PDF
image
Data Mining Extensions (DMX) Reference
EPUB
MOBI
PDF
image
Data Quality Services
EPUB
MOBI
PDF

image
High Availability Solutions
EPUB
MOBI
PDF
image
Master Data Services
EPUB
MOBI
PDF
image
Monitor and Tune for Performance
EPUB
MOBI
PDF
image
Multidimensional Expressions (MDX) Reference
EPUB
MOBI
PDF

image
SQL Server Distributed Replay
EPUB
MOBI
PDF
image
Transact-SQL Data Definition Language (DDL) Reference
EPUB
MOBI
PDF
image
XQuery Language Reference
EPUB
MOBI
PDF
image
Extracting and Loading SharePoint Data in SQL Server Integration Services
EPUB
MOBI
PDF

image
Integration Services: Extending Packages with Scripting
EPUB
MOBI
PDF
image
Multidimensional Model Programming
EPUB
MOBI
PDF
image
Optimized Bulk Loading of Data into Oracle
EPUB
MOBI
PDF
image
Planning Disaster Recovery for Microsoft SQL Server Reporting Services in SharePoint Integrated Mode
EPUB
MOBI
PDF

image
SQL Server 2012 Tutorials: Reporting Services
EPUB
MOBI
PDF
image
SQL Server 2012 Tutorials: Writing Transact-SQL Statements
EPUB
MOBI
PDF
image
SQL Server Community FAQs Manual
EPUB
MOBI
PDF

Copy only backup feature Modification in SQL Server 2012

Copy only backups were introduced in SQL Server 2005 so that DBA has an option of taking ad-hoc backups without breaking the backup sequence. In SQL Server 2005, copy only backup was available only for as a T-SQL option and in SQL Server 2008, this feature came to UI.

In SQL Server 2012, there is another UI change!!!!

Copy only backup does not have a meaning for differential backups since ad-hoc differential backup does not effect any sequence.

However, in SQL Server 2008 still you can get a copy only differential backups.

image

In SQL Server 2012, we you select differential backups copy only backup option will be disabled.

image

you can read more about copy only backups from here.

Saturday, June 15, 2013

New Features in SQL Server 2014

Although it doesn’t seem possible so soon, Microsoft announced SQL Server 2014 at this year’s TechEd 2013 conference in New Orleans. Quentin Clark, Microsoft Corporate Vice President for SQL Server, said that Microsoft is getting ready for the upcoming SQL Server 2014 release. Some of the most important new features in SQL Server 2014 include the following:

In-Memory OLTP Engine
The new In-Memory OLTP Engine (formerly code-named Hekaton) will provide OLTP performance improvements by moving selected tables into memory. The In-memory OTLP Engine works with commodity hardware and won’t require any application code changes. A built-in wizard will help you to choose which tables go in memory and select the stored procedures that will be compiled into machine code for high performance execution.

EdgeNet, an early adopter, saw a 7X performance increase with no code changes. Microsoft claims that some applications can achieve a 50x performance boost using the new In-Memory OTLP engine.

Improved Scalability
SQL Server 2014 will have the ability to scale up to 640 logical processors and 4TB of memory in a physical environment. It can scale to 64 virtual processors and 1TB of memory when running in a virtual machine (VM). New buffer pool enhancements increase performance by extending SQL Server’s in-memory buffer pool to SSDs for faster paging.

Windows Azure Integrated Backup
The new backup option is integrated into SQL Server Management Studio (SSMS). It lets you back up a SQL Server database to Windows Azure. You can also use it to quickly restore database backups to an Azure VM.

Azure Integrated AlwaysOn Availability Groups
AlwaysOn Availability Groups have also been integrated with Azure, providing AlwaysOn capabilities in the cloud. AlwaysOn Azure integration enables you to create asynchronous Availability Group replicas in Azure for disaster recovery.

Like the new Azure backup feature, the Azure AlwaysOn Availability options are completely integrated into SSMS. Other enhancements to AlwaysOn Availability Groups include the ability to have up to eight replicas—up from four in SQL Server 2012.

Business Intelligence and Data Visualization Enhancements
SQL Server 2014 will include the new data visualization tool, code-named Data Explorer. Data Explorer enables data analysis in Microsoft Excel, and its can work with a wide variety of sources including relational, structured, and semi-structured data such as OData, Hadoop, and the Azure Marketplace.

The new feature, code-named GEOFlow, will able to provide visual data mapping in Excel. You can download the previews for Data Explorer and GEOFlow from the Microsoft website. Other BI enhancements include the ability for Power View to work against multidimensional cube data in addition to tabular data models.

Improved Integration with Windows Server 2012
SQL Server 2014 will also provide support for Windows Server 2012’s new Storage Spaces feature. Storage Spaces enables you to create pools of tiered storage that can improve application availability and performance. SQL Server 2014’s Resource Governor can take advantage of Windows Server 2012’s automated storage tiering. Plus, you can use the Resource Governor to manage and limit application IO utilization.

Microsoft skipped the traditional R2 release that it normally puts out between major releases because of the significant changes it made to the database engine to support the new In-Memory OLTP Engine. A preview of the SQL Server 2014 release is expected in late June and the general availability of SQL Server 2014 is planned for early 2014. You can read more in the Microsoft SQL Server Blog.

Tuesday, June 11, 2013

Avoiding Parameter Sniffing in SQL Server

Parameter sniffing is when SQL Server compiles a stored procedure’s execution plan with the first parameter that has been used and then uses this plan for subsequent executions regardless of the parameters.  Read more about parameter sniffing and how to avoid it from here.

Tuesday, June 4, 2013

SQL Server 2014 & the Data Platform

image

image

SQL Server 2014 due out in late 2013, in-memory OLTP a big feature

SQL Server 2014, due out late this year, has an in-memory capability for online transaction processing (OLTP) with table-level granularity and doesn't require expensive hardware like other in-memory databases, according to Microsoft.

Microsoft announced SQL Server 2014 at its TechEd conference in New Orleans this week. A technology preview download will be available this month, and the database is expected to be generally available in late 2013. Redmond had already said last fall that in-memory would be a feature of the next version and previewed it during the Professional Association for SQL Server (PASS) Summit in Seattle under the codename "Hekaton." What's new this week is Microsoft's announcement of the release date.

Read More at http://searchsqlserver.techtarget.com/news/2240185188/SQL-Server-2014-due-out-in-late-2013-in-memory-OLTP-a-big-feature

Saturday, June 1, 2013

CREATE INDEX vs ENSURE INDEX

When creating an INDEX in many database systems we use, CREATE INDEX statement. However, in MongoDB command is ensureIndex. Reason for this is, ensureIndex will ensure there is an index on given attribute. CREATE INDEX will create an index on given columns for given index name.

Also, if you execute CREATE INDEX twice second execution will fail. However, in ensureIndex multiple execution will not fail.