Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

<< Newer    Items 61 to 80 of 13011    Older >>

The Brittleness of Replication

Replication is a great feature in SQL Server, but it seems brittle. When things go wrong, they break quickly, and often severely. It seems that we have many features like this in SQL Server that are useful and handy, but receive very little attention as versions are released.  Read more...
By Steve Jones 2014/08/12 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 178 reads

Adding Custom Reports to SQL Server Management Studio

In this tip, Koen Verbeeck explores how to apply business intelligence solutions to administrative tasks, specifically creating custom reports and adding them to SQL Server Management Studio.  Read more...
By Additional Articles 2014/08/12 | Source: | Category: reports
Rating: (not yet rated)  Rate this |   Briefcase | 8,756 reads

SQL Saturday #320 - Raleigh, NC

SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. The Triangle SQL Server user group ( of Raleigh, NC is hosting this event on September 6, 2014. Register while space is available.  Read more...
By Press Release 2014/08/12 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 6,595 reads

Verify SQL Backup Integrity

Perform automated database restores and check the integrity of your backup files  Read more...
By Willem Gossink 2014/08/11 | Source: | Category: backup
Rating: |  Discuss |   Briefcase | 3,670 reads

We Don't Care about Data and IT Security

Most of us say we care about IT and data security. Our actions speak differently.  Read more...
By Brian Kelley 2014/08/11 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 212 reads

Data is Not Always Enough

More data is better, but Steve Jones notes that even that isn't always enough to make decisions count for your organization.  Read more...
By Steve Jones 2014/08/11 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 78 reads

Practically Cloudy: SQL Server Disaster Recovery to Microsoft Azure - Backups

In the first in a series on the practicalities of using the Microsoft Azure Platform for the SQL Server professional, Buck Woody shows that, whatever your version of SQL Server, there is a way of storing offsite backups in the cloud.  Read more...
By Additional Articles 2014/08/11 | Source: SimpleTalk | Category: disaster recovery (dr)
Rating: (not yet rated)  Rate this |   Briefcase | 7,674 reads

How to Create a Corrupt SQL Server Database

This article details how to create a corrupt SQL Server database for testing purposes  Read more...
By Perry Whittle 2014/08/08 (first published: 2012/05/04) | Source: | Category: checkdb
Rating: |  Discuss |   Briefcase | 18,194 reads

The SQL of Membership: Equivalence Classes & Cliques

It is awkward to do 'Graph databases' in SQL to explore the sort of relationships and memberships in social networks because equivalence relations are classes (a set of sets) rather than sets. However one can explore graphs in SQL if the relationship has all three of the mathematical properties needed for an equivalence relationship.  Read more...
By Additional Articles 2014/08/08 | Source: SimpleTalk | Category: graph databases
Rating: (not yet rated)  Rate this |   Briefcase | 8,818 reads

Titles Matter

Today Andy Warren talks titles, and how they can affect your career.  Read more...
By Andy Warren 2014/08/08 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 194 reads

SQL Saturday #327 - Johannesburg

SQL Saturday is coming to Johannesburg on August 30. Join in for a free day of SQL Server training and networking. Register while spaces are available.  Read more...
By Press Release 2014/08/08 | Source: SQL Saturday
Rating: (not yet rated)  Rate this |   Briefcase | 6,783 reads

What do you consider important when performance testing?

What data specific considerations do you make when preparing for performance testing?  Read more...
By Gary Varga 2014/08/07 | Source: | Category: performance testing
Rating: |  Discuss |   Briefcase | 185 reads

Introducing the Columnstore Index

A brief overview of Columnstore index and its usage with an example  Read more...
By Gayathri Jayaraman 2014/08/07 | Source: | Category: columnstore index
Rating: |  Discuss |   Briefcase | 5,854 reads

The Road To Hell - new article from the DBA Team

Joe Celko & Chris Date guest as the sinister Relational Police in this new DBA Team adventure. Can the DBA Team save another doomed database? Find out.  Read more...
By Additional Articles 2014/08/07 | Source: Red-Gate | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 9,871 reads

Stairway to SQL Server Virtualization Level 1: What is Virtualization?

The first level in the Stairway to Virtualization introduces the concept of virtualized servers as well as the terminology and benefits of implementing the technology.  Read more...
By David Klee 2014/08/06 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,186 reads

Byte Me: Hardware Error

A fundamental hardware error. 
By Bob Lang 2014/08/06 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 441 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/08/06 (first published: 2013/07/30) | Source: Red-Gate | Category: execution plans
Rating:  Rate this |   Briefcase | 32,987 reads

Getting Started with Hashing in SQL Server

Encryption brings data into a state which cannot be interpreted by anyone who does not have access to the decryption key, password, or certificates. Hashing brings a string of characters of arbitrary size into a usually shorter fixed-length value or key. Here's how to get started using it.  Read more...
By Additional Articles 2014/08/06 | Source: Database Journal | Category: hashing
Rating:  Rate this |   Briefcase | 8,506 reads

Getting It Right First Time. Almost?

Mistakes happen but how can we minimize them and deal with them whey they do happen?  Read more...
By Scott Crosby 2014/08/05 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 149 reads

Linked Server Tribulations In SQL Server

In this article, Thomas chronicles the difficulties of troubleshooting a linked server set up, with helpful tips and an exposé of a Linked Server UI flaw.   Read more...
By Thomas Knight 2014/08/05 | Source: | Category: linked server
Rating: |  Discuss |   Briefcase | 4,964 reads
<< Newer    Items 61 to 80 of 13011    Older >>