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/08/13 to 2013/08/20

Upgrading the GIS application and database.

In this article I will mention a specific issue that I experienced during my last GIS application and database upgrade.  Read more...
By Hilda E 2013/08/20 | Source: SQLServerCentral.com | Category: upgrading
Rating: |  Discuss |   Briefcase | 3,407 reads

New SQL Monitor Custom Metric: Untrusted Foreign Keys

A foreign key points to a primary key that must exist in another table, for example, column X in Table 1 must also be present in Table 2. The key protects this link, and only valid data can be inserted in the foreign key column. An untrusted foreign key may threaten a database’s referential and data integrity.  Read more...
By Press Release 2013/08/20 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,117 reads

SQL in the City Seminar Denver 2013 – SQL Development Seminar

Join Red Gate for a free seminar on September 27 (the day before SQL Saturday Denver). Steve Jones, SQL Server MVP and editor-in-chief of SQLServerCentral.com, will present best practices for SQL Server database development, in addition to showing Red Gate tools in action.   Read more...
By Press Release 2013/08/20 | Source: Red-Gate | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 1,267 reads

Columnstore Indexes in SQL Server 2012

The columnstore index in SQL Server 2012 stores columns instead of rows, and is designed to speed up analytical processing and data-warehouse queries. Whilst columnstore indexes certainly do that effectively, they are not a universal panacea since there are a number of limitations on them. When used appropriately, they can reduce disk I/O and use memory more efficiently.   Read more...
By Additional Articles 2013/08/20 | Source: SimpleTalk | Category: columnstore index
Rating:  Rate this |   Briefcase | 2,828 reads

SQL Server Central Webinar Series #25 - Best Practices in Database Deployment Part 1: Aug 27th @ 4PM BST

Join Grant Fritchey (SQL Server MVP) as he tackles the most common problems and pitfalls of database deployment. He will explain how you (and your team) can make your deployment process, faster, more efficient and most importantly less stressful!  Read more...
By Press Release 2013/08/26 (first published: 2013/08/19) | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,989 reads

SQL Server 2012 Analysis Services Partitioning Performance Demonstration

How much of an improvement in processing time can a simple SQL Server Analysis Services (SSAS) partitioning structure provide? Can you provide any examples? Does this processing time improvement only apply to the fact tables? Check out this tip to learn more.  Read more...
By Additional Articles 2013/08/19 | Source: MSSQLTips.com | Category: ssas
Rating: (not yet rated)  Rate this |   Briefcase | 3,079 reads

Implementing, loading and optimizing a Type 2 Slowly Changing Fact Table

This article shows how to implement a Slowly Changing Facts Table, how to overcome the problems encountered when using the MERGE statement to process the data and suggest a minimal set of indexes to aid data loading and quering.   Read more...
Rating: |  Discuss |   Briefcase | 5,292 reads

Data Science Laboratory System - Key/Value Pair Systems

Though the Key/Value pair paradigm is common to almost every computer language, there is no clear agreement yet for the definition of a Key/Value Pair database. However, Key/Value pair databases are valuable for special applications where speed of writing data is more important than searching and general versatility. Buck Woody experiments.  Read more...
By Additional Articles 2013/08/16 | Source: SimpleTalk | Category: data science
Rating: (not yet rated)  Rate this |   Briefcase | 2,869 reads

Creating A SQL Server 2008\2008 R2 Failover Cluster

Details how to install a SQL Server 2008\2008R2 Failover Cluster Instance  Read more...
By Perry Whittle 2013/12/23 (first published: 2011/01/19) | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 17,704 reads

SQLServerCentral.com Users Survey 2013 - Last week

The SQLServerCentral.com survey will end on Wednesday August 21st. Let us know how we're doing and be in with a chance to win a $100 Amazon gift card. Winners will be announced later that week.  Read more...
By Additional Articles 2013/08/15 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: (not yet rated)  Rate this |   Briefcase | 2,318 reads

SSIS Deployments with SQL Server 2012

This article describes different methods for deploying your SSIS projects to a server.  Read more...
Rating: |  Discuss |   Briefcase | 5,818 reads

Move an On Premise SQL Server Database to the SQL Azure Cloud

I’ve introduced my manager to SQL Server’s cloud based platform, SQL Azure and Windows Azure Virtual Machine. He wants to test functionality with some of our applications, which would require me to move my on premise databases to the Azure Virtual Machine. What is the easiest way to accomplish this task? See how it is done in this tip.  Read more...
By Additional Articles 2013/08/15 | Source: Quest | Category: sql azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,526 reads

Using Biml as an SSIS Design Patterns Engine – Level 4

In this level, we make a large leap forward, showing you how to use BIML to script a large number of packages using C#.  Read more...
By Andy Leonard 2013/08/14 | Source: SQLServerCentral.com | Category: biml
Rating: |  Discuss |   Briefcase | 5,848 reads

What’s New with SQL Server 2014

In this article Greg Larson outlines the exciting new features that come along with SQL Server 2014. He'll also let you know where you can download CTP1, as well as where you can find additional resources related to SQL Server 2014.  Read more...
By Additional Articles 2013/08/14 | Source: Database Journal | Category: sql server 2014
Rating:  Rate this |   Briefcase | 4,169 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2014/03/12 (first published: 2013/08/14) | Source: Red-Gate | Category: transaction logs
Rating: (not yet rated)  Rate this |   Briefcase | 13,848 reads

SQL in the City Seminar San Diego 2013 – DBA Team Seminar

Join Red Gate for a free seminar on September 20 (the day before SQL Saturday San Diego). SQL Server MVPs, Steve Jones and Grant Fritchey will present informative sessions featuring best practices for SQL Server database administration, in addition to showing Red Gate tools in action.   Read more...
By Press Release 2013/08/13 | Source: Red-Gate | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 1,370 reads

How to Compile, Deploy and Consume a SQL Server CLR Assembly

Specialized tasks like cryptography require external libraries that are not available in SQL Server. Methods for such tasks can be compiled in a .NET language and deployed to SQL Server as a CLR assembly where the assembly's methods can be referenced by SQL Server stored procedures and functions.  Read more...
By Stan Kulp 2013/08/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,858 reads

The SQL of Gaps and Islands in Sequences

Some SQL problems are intriguing because, just when good methods emerge and are accepted, other alternative solutions are discovered. The fun of exploring problems such as 'Gaps and Islands' is all the greater when we have a thorough test-harness to try out the alternative solutions.  Read more...
By Additional Articles 2013/08/13 | Source: SimpleTalk | Category: gaps
Rating:  Rate this |   Briefcase | 2,269 reads