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

<< Newer    Items 41 to 60 of 12988    Older >>

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 | 201 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 | 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,350 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,046 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,858 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 | 185 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,851 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 | 179 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,684 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 | 8,889 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,006 reads

Byte Me: Hardware Error

A fundamental hardware error. 
By Bob Lang 2014/08/06 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 420 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,125 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 | 7,649 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 | 145 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,870 reads

How to test what a SQL Server application would do in the past or in the future with date and time differences

For date and time based testing, I use what I like to call "mock-time". The mock-time starts at what ever I set it to, but then advances along with the regular system clock. Andy Novick shows how that would work.  Read more...
By Additional Articles 2014/08/05 | Source: | Category: test
Rating: (not yet rated)  Rate this |   Briefcase | 7,554 reads

SQL Monitor Custom Metric: Schema Modified

This metric creates an alert that will be raised when something is added to the schema, or the existing schema is modified.  Read more...
By Press Release 2014/08/05 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 6,930 reads

Call for Speakers - SQL Saturday Pittsburgh

SQL Saturday #315 in Pittsburgh (Oct 4th) is looking for speakers - if you've got a SQL topic you want to talk about, submit it and you may get to share with your peers.  Read more...
By Steve Jones 2014/08/05 | Source: | Category: sql saturday
Rating:  Rate this |   Briefcase | 7,401 reads

Technology Wave

The quickness at which technology has and is changing our lives and shaping our culture.  Read more...
By Brad Steele 2014/08/04 | Source: | Category: technology
Rating: |  Discuss |   Briefcase | 38 reads
<< Newer    Items 41 to 60 of 12988    Older >>