Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2013/10/31 to 2013/11/07

SSIS Distributed Transactions

This article shows the steps to set-up distributed transactions for SSIS.  Read more...
By Brian Ellul 2013/11/07 | Source: SQLServerCentral.com | Category: dtc
Rating: |  Discuss |   Briefcase | 4,072 reads

Building Real-World Microsoft BI Dashboards Today

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.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 5,197 reads

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

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.  Read more...
By Additional Articles 2013/11/06 | Source: Database Journal | Category: columnstore index
Rating: (not yet rated)  Rate this |   Briefcase | 3,911 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2014/05/28 (first published: 2013/07/30) | Source: Red-Gate | Category: execution plans
Rating:  Rate this |   Briefcase | 23,719 reads

Stairway to PowerPivot and DAX - Level 4: The DAX BLANK() Function

Business Intelligence architect and author Bill Pearson exposes the DAX BLANK() function, and then provides some hands-on exposure to its use in managing empty values underlying our PowerPivot model designs.  Read more...
By Bill Pearson 2013/11/06 (first published: 2013/03/18) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,199 reads

How to Design, Build and Test a Dynamic Search Stored Procedure

Learn how to design, build and test a dynamic search SP in just a few simple but methodical steps.  Read more...
By Dwain Camps 2013/11/05 | Source: SQLServerCentral.com | Category: sql catch all query
Rating: |  Discuss |   Briefcase | 10,599 reads

SQL Server 2008 R2 Build List

The list of builds for SQL Server 2008 R2 up to CU14 for SP1 and CU12 for SP2.  Read more...
By Steve Jones 2013/11/05 (first published: 2010/05/25) | Source: SQLServerCentral.com | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 50,483 reads

Different Ways to Restore a SQL Server Database

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.   Read more...
By Additional Articles 2013/11/05 | Source: MSSQLTips.com | Category: backup/restore
Rating: (not yet rated)  Rate this |   Briefcase | 4,948 reads

Database Restore Automation

Read about Paul Brewer's Framework (Version 2) for Database Restore Automation.  Read more...
By Paul Brewer 2013/11/04 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 4,706 reads

Free eBook: 45 Database Performance Tips for Developers

As a developer, if you need to go into the database and write queries, design tables, or determine the configuration of your SQL Server Systems, these tips should help make sure you're not unnecessarily sacrificing database performance. This eBook has 45 easy tips to improve the performance of your indexes and T-SQL queries, and hunt down problems within ORM tools and database design.   Read more...
By Press Release 2014/01/02 (first published: 2013/11/04) | Source: Red-Gate | Category: tips
Rating:  Rate this |   Briefcase | 15,368 reads

Fundamentals of Vendor 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.   Read more...
By Additional Articles 2013/11/04 | Source: SimpleTalk | Category: project management
Rating: (not yet rated)  Rate this |   Briefcase | 2,439 reads

Normalizing-Denormalized Tables

Explains how to normalize a table without breaking the application or doing any application code changes.  Read more...
By Mohit K. Gupta 2013/11/01 (first published: 2008/11/10) | Source: SQLServerCentral.com | Category: normalization
Rating: |  Discuss |   Briefcase | 21,950 reads

Calculating Values within a Rolling Window in Transact SQL

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.  Read more...
By Additional Articles 2013/11/01 | Source: SimpleTalk | Category: window functions
Rating: (not yet rated)  Rate this |   Briefcase | 3,840 reads

Improving SSIS Update Performance

This article includes an examination of how I improved update performance. We examine four methods of loading data into a data warehouse.  Read more...
Rating: |  Discuss |   Briefcase | 5,867 reads

SQL in the City Seminar Portland 2013 –Deployment Stairway

Join Red Gate for a free seminar on November 15 (the day before SQL Saturday Oregon). Steve Jones and Grant Fritchey, SQL Server MVPs, will present best practices for SQL Server version control, continuous integration and deployment, in addition to showing Red Gate tools in action.   Read more...
By Press Release 2013/11/12 (first published: 2013/10/31) | Source: SQL in the City | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 2,564 reads

Tuning Distributed Applications to Access 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?  Read more...
By Additional Articles 2013/10/31 | Source: Database Journal | Category: big data
Rating: (not yet rated)  Rate this |   Briefcase | 2,695 reads