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/05/08 to 2013/05/15

SQL Saturday #220 - Atlanta

A free day of training this weekend in Atlanta, GA.  Read more...
By Press Release 2013/05/15 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 3,262 reads

Using XML from data variable option in SSIS

Learn how you can manipulat XML documents solely in memory. No file required.   Read more...
By Cindy Conway 2013/05/15 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 4,249 reads

Forwarding Pointers in Heaps

When no clustered index is defined on a table, that table is said to be a Heap. Heaps are not ideal when it comes to performance but there are lots of instances where you have heaps.   Read more...
By Additional Articles 2013/05/15 | Source: SQL Server Performance | Category: heaps
Rating:  Rate this |   Briefcase | 2,891 reads

Case Study: Designing Scaled-Out Architecture

On Thursday May 16th 12PM Central time, Robert Davis will discuss public facing websites on a global scale when looking at Data Architecture.  Read more...
By Press Release 2013/05/14 | Source: SQLServerCentral.com | Category: pass virtual chapters
Rating: (not yet rated)  Rate this |   Briefcase | 3,248 reads

SQL Saturday #212 - Redmond

A free day of training in Redmond, WA this weekend on May 18, 2013.  Read more...
By Press Release 2013/05/14 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 2,630 reads

Converting Large Object Data Types

Eliminate pesky legacy TEXT, NTEXT and IMAGE data types with this handy script.  Read more...
By Othman Hack 2013/05/14 | Source: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 4,510 reads

How to Synchronize Two SSAS Servers

Unfortunately SQL Server Analysis Services (SSAS) does not support differential backups and creating full backups for the servers might take too much time. In this tip we are going to show how to synchronize two SSAS servers in order to have a failover server in case something goes wrong with one of the servers.  Read more...
By Additional Articles 2013/05/14 | Source: MSSQLTips.com | Category: ssas
Rating:  Rate this |   Briefcase | 2,627 reads

Disturbing Development

Part 4 of the top 5 hard earned lessons of a DBA.  Read more...
By Additional Articles 2013/05/13 | Source: Red-Gate | Category: red gate software
Rating:  Rate this |   Briefcase | 4,746 reads

Loginless In Seattle

Identify orphaned Database Users and differentiate them from "Loginless" Database Users.  Read more...
By Orlando Colamatteo 2013/05/13 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,914 reads

The Ten Commandments of SQL Server Monitoring

It is easy to get database monitoring wrong. There are several common-sense rules that can make all the difference between a monitoring system that works for you and helps to avoid database problems, and one that just creates a distraction. Adam Machanic spells out the rules, based on his considerable experience with database monitoring.  Read more...
By Additional Articles 2013/05/13 | Source: SimpleTalk | Category: monitoring
Rating:  Rate this |   Briefcase | 7,648 reads

Job overran Custom Metric

This SQL Monitor custom metric tells you if a specific SQL Server Agent job that runs at the same time every day has overrun. The metric is useful when a job can have negative effects on other processes if it overruns.  Read more...
By Press Release 2013/05/10 | Source: Red-Gate | Category: red gate software
Rating: (not yet rated)  Rate this |   Briefcase | 2,363 reads

SQL Server Simple and Forced Parameterization

I have heard about parameterization for SQL Server queries, but what is Forced and Simple Parameterization and which one should I use for my SQL Server database?  Read more...
By Additional Articles 2013/05/10 | Source: MSSQLTips.com | Category: forced parameterization
Rating: (not yet rated)  Rate this |   Briefcase | 4,975 reads

Indexed Views

This article will show you the importance of Indexed Views and how they can help performance.  Read more...
By Sarvesh Singh 2013/05/10 (first published: 2010/11/16) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 23,953 reads

Community-driven free Azure tips eBook

We’re putting together a free eBook of 50 tips for Azure Storage, if you’ve got tips that you’d like to share we’d love to hear from you.  Read more...
By Press Release 2013/05/09 | Source: SQLServerCentral.com | Category: books
Rating: (not yet rated) |  Discuss |   Briefcase | 644 reads

Stairway to PowerPivot and DAX - Level 5: The DAX ISBLANK() Function

Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson exposes the DAX ISBLANK() function, and then provides some hands-on exposure to its use, particularly in combination with other DAX functions, in managing empty values underlying our PowerPivot model designs.  Read more...
By Bill Pearson 2013/12/04 (first published: 2013/05/09) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,872 reads

Monitoring Transactional Replication in SQL Server

If you are using replication in SQL Server, you can monitor it in SSMS, but it makes sense to monitor distribution jobs automatically, especially if you can set up alerts or even set up first-line remedial action when a problem is detected. Francis shows how to do it in T-SQL as an agent job.  Read more...
By Additional Articles 2013/05/09 | Source: SimpleTalk | Category: transactional replication
Rating: (not yet rated)  Rate this |   Briefcase | 2,345 reads

Rendering PDFs Natively in SQL

How to render PDF documents using SQL CLR. Also a good introduction on creating SQL CLR functions.  Read more...
By David Rueter 2013/05/08 | Source: SQLServerCentral.com | Category: pdf
Rating: |  Discuss |   Briefcase | 15,510 reads

Using Policy-Based Management to Check Number of SQL Server Data and Log Files

To meet our database configuration standards we want to make sure that we have only one database transaction log file and more than one data file. In this tip we look at how this can be done using a policy.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,839 reads

SQL Saturday #220 - Atlanta

Join us for a free day of SQL Server training and networking in Atlanta on May 18th.  Read more...
By Press Release 2013/05/08 | Source: SQLServerCentral.com | Category: sql sat
Rating: (not yet rated)  Rate this |   Briefcase | 1,772 reads