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

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,740 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,751 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 | 176 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,650 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,738 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 | 4,972 reads

Byte Me: Hardware Error

A fundamental hardware error. 
By Bob Lang 2014/08/06 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 414 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 | 31,961 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,485 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 | 143 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,848 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,264 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,639 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,105 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 | 37 reads

Natively Compiled Stored Procedures: What they are all about!

What are natively compiled stored procedures? Why would we want to use them and what are the performance benefits of using them over classic disk-based stored procedures?  Read more...
By Edward Pollack 2014/08/04 | Source: | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 7,612 reads

A DBA at the Opera

In opera, tragedy or absurdity happens because the characters are incapable of standing back, and making a difficult decision. Instead, at every stage, they just drift towards their fate by taking the easy option. Don't let the same fate befall you, as a DBA.  Read more...
By Louis Davidson (@drsql) 2014/08/04 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 77 reads

Managing Big Data DBAs

Technical support teams usually support familiar hardware and software configurations. Specialization in particular combinations of operating systems and database management software is common, and this allows some team members to gain in-depth experience that is extremely valuable in an enterprise IT setting. How has big data changed this paradigm?  Read more...
By Additional Articles 2014/08/04 | Source: Database Journal | Category: big data
Rating: (not yet rated)  Rate this |   Briefcase | 9,172 reads

Call for Speakers in Sunny San Diego

If you're in Southern California, you should come to SQL Saturday #340 and speak at their event. If you want a late summer vacation, submit and come enjoy the event.  Read more...
By Steve Jones 2014/08/04 | Source: | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 7,265 reads
<< Newer    Items 41 to 60 of 12983    Older >>