Additional Articles

Building Real-World Microsoft BI Dashboards Today

by Additional Articles

SQLServerCentral

Business Intelligence

There is a lot of Microsoft buzz about Power BI and Excel these days, but customers need real-world, professional business intelligence solutions that meet their complex real-world requirements today. In this article, Jen Underwood shares what technologies were used to develop a dashboard solution for a Fortune Global 500 company using Microsoft Business Intelligence technologies, and why. Some of the decisions may surprise you and the lessons learned are sure to be of value.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2013-11-07

5,745 reads

Getting Started with Columnstored Index in SQL Server 2014 – Part 2

by Additional Articles

SQLServerCentral

ColumnStore Index

Column Store Index, which improves performance of data warehouse queries several folds, was first introduced in SQL Server 2012. Though it had several limitations, now SQL Server 2014 enhances the columnstore index and overcomes several of the earlier limitations. In this article, Arshad Ali discusses how you can get started using the enhanced columnstore index feature in SQL Server 2014 and do some performance tests.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2013-11-06

4,375 reads

Different Ways to Restore a SQL Server Database

by Additional Articles

MSSQLTips.com

Backup and restore

This article describes the SQL Server database restore principles for full backups, differential backups and transaction log backups and how to perform the restores to get to a particular point in time. This tip describes SQL Server database restore principles on a database that is using the FULL recovery model.

2013-11-05

5,308 reads

Fundamentals of Vendor Management

by Additional Articles

SimpleTalk

project management

Creating and maintaining mutually beneficial relationships with external vendors is one of the pillars of good project management. Dwain Camps goes through what to expect and allow in your client-vendor relationship during the various stages of a given project to ensure its success and secure that all important win-win outcome.

2013-11-04

2,844 reads

Calculating Values within a Rolling Window in Transact SQL

by Additional Articles

SimpleTalk

window functions

Before the SQL Window functions were implemented, it was tricky to calculate rolling totals or moving averages efficiently in SQL Server. There are now a number of techniques, but which has the best performance? Dwain Camps gets out the metaphorical stopwatch.

2013-11-01

4,628 reads

Tuning Distributed Applications to Access Big Data

by Additional Articles

SQLServerCentral

Big Data

Distributed applications are just that: distributed across one or more hardware platforms across the enterprise. The database administrator (DBA) has the unenviable task of monitoring these environments and configuring and tuning the database server to meet multiple needs. As multiple distributed applications now require access to a very large data store, what tuning options are available to help?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2013-10-31

3,024 reads

The ETL from Hell - Diagnosing Batch System Performance Issues

by Additional Articles

SimpleTalk

ETL (Extract Transform and Load)

Too often, the batch systems that underlie a lot of database processing just grow without conscious design. When runs start to extend beyond their allotted time, and tuning no longer solves the problem, it is often discovered that batches are run in series, with draconian error handling. It is time to impose some rational design, and Nigel is a seasoned healer of batch processes.

2013-10-30

3,753 reads

Using Views to Expose Encrypted Data in SQL Server

by Additional Articles

MSSQLTips.com

Views

I'm using SQL Server's built-in encryption to hide data in one of my SQL Server databases, but this is a reporting system and my end users need to be able to query the data without having to remember the specialized decryption functions. Is there a way to do this? Yes, there is, via the use of views.

2013-10-29

4,794 reads

SSIS Basics: Using the Merge Join Transformation

by Additional Articles

SimpleTalk

Integration Services (SSIS)

SSIS is able to take sorted data from more than one OLE DB data source and merge them into one table which can then be sent to an OLE DB destination. This 'Merge Join' transformation works in a similar way to a SQL join by specifying a 'join key' relationship. this transformation can save a great deal of processing on the destination. Annette Allen, as usual, gives clear guidance on how to do it.

2013-10-28

4,491 reads

Migrate to Natively Compiled SQL Server Stored Procedures for Hekaton

by Additional Articles

MSSQLTips.com

Hekaton

In order to take full advantage of the In-Memory OLTP options in SQL Server 2014, you should migrate standard stored procedures that references Memory-Optimized tables to natively compiled ones. In this tip we will see how to achieve this goal.

2013-10-25

3,317 reads

All authors

Additional Articles

Building Real-World Microsoft BI Dashboards Today

Getting Started with Columnstored Index in SQL Server 2014 – Part 2

Different Ways to Restore a SQL Server Database

Fundamentals of Vendor Management

Calculating Values within a Rolling Window in Transact SQL

Tuning Distributed Applications to Access Big Data

The ETL from Hell - Diagnosing Batch System Performance Issues

Using Views to Expose Encrypted Data in SQL Server

SSIS Basics: Using the Merge Join Transformation

Migrate to Natively Compiled SQL Server Stored Procedures for Hekaton

Blogs

Exploring DiskANN: Part I: Understanding the Algorithm before the disk

Learning Tool – Deepstash

New article – migrating from a named instance

Forums

Understanding Temp Tables and Table Variables in SQL Server

The Data API Builder MCP Server Tools

Collecting Data Is Hard

Question of the Day

The Data API Builder MCP Server Tools