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

<< Newer    Items 21 to 40 of 12978    Older >>
 

How Much for a Laugh?

How much would you pay for a laugh? Maybe you'll donate to ensure that some of your SQL Server speakers will embarrass themselves at the PASS Summit.  Read more...
By Steve Jones 2014/08/14 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 194 reads

The Hybrid Cloud: Having your Cake

With a hybrid cloud, can you get the freedom and flexibility of a public cloud with the security and bandwidth of a private cloud? Robert Sheldon explains all the ins and outs.  Read more...
By Additional Articles 2014/08/14 | Source: SimpleTalk | Category: hybrid cloud
Rating: (not yet rated)  Rate this |   Briefcase | 6,703 reads

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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 125 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: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 20,414 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 | 27,743 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 | 6,217 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: SQLServerCentral.com | Category: data mining
Rating: |  Discuss |   Briefcase | 2,721 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: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 159 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: MSSQLTips.com | Category: reports
Rating: (not yet rated)  Rate this |   Briefcase | 7,421 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 (http://www.tripass.org) 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 | 5,345 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: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 3,439 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: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 199 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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 72 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 | 6,112 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: SQLServerCentral.com | Category: checkdb
Rating: |  Discuss |   Briefcase | 17,983 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 | 7,559 reads

Titles Matter

Today Andy Warren talks titles, and how they can affect your career.  Read more...
By Andy Warren 2014/08/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 181 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 | 5,583 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: SQLServerCentral.com | Category: performance testing
Rating: |  Discuss |   Briefcase | 172 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: SQLServerCentral.com | Category: columnstore index
Rating: |  Discuss |   Briefcase | 5,628 reads
<< Newer    Items 21 to 40 of 12978    Older >>