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 13016    Older >>

One System to Rule Them All

Can a single piece of software work well for most situations? Steve Jones wonders if we're not attacking the problems of large software applications in the right way.  Read more...
By Steve Jones 2014/08/13 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 133 reads

Stairway to Database Design Level 2: Domains, Constraints and Defaults

A clear understanding of SQL Data Types and domains is a fundamental requirement for the Database Developer, but it is not elementary. If you select the most appropriate data type, it can sidestep a variety of errors. Furthermore, if you then define the data domains as exactly as possible via constraints, you can catch a variety of those problems that would otherwise bedevil the work of the application programmer.  Read more...
By Joe Celko 2014/08/13 (first published: 2010/05/04) | Source: | Category: database design
Rating: |  Discuss |   Briefcase | 20,663 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2014/08/13 (first published: 2013/07/17) | Source: Red-Gate | Category: concurrency
Rating:  Rate this |   Briefcase | 29,260 reads

Automating SQL Server Agent Notification

This article looks at some automated approaches of monitoring SQL Server agent jobs.  Read more...
By Additional Articles 2014/08/13 | Source: Database Journal | Category: sql server agent
Rating: (not yet rated)  Rate this |   Briefcase | 7,676 reads

Data Mining: Part 13 Powershell

In this lesson we will explain how to create scripts to manage Data Mining Models using Powershell.  Read more...
By Daniel Calbimonte 2014/08/12 | Source: | Category: data mining
Rating: |  Discuss |   Briefcase | 3,003 reads

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 | 180 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,872 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,709 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,689 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,683 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,210 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,826 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,787 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 | 187 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,881 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,900 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,212 reads
<< Newer    Items 61 to 80 of 13016    Older >>