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

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,602 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,600 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,929 reads

Byte Me: Hardware Error

A fundamental hardware error. 
By Bob Lang 2014/08/06 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 407 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,826 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,356 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,825 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,163 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,531 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 | 6,996 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,576 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 | 76 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 | 8,992 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,090 reads

How To Write An Interview Winning Resume

Writing a resume that rocks is not an art. Follow these simple guidelines to help secure your next interview.  Read more...
By John Sansom 2014/08/01 (first published: 2012/07/19) | Source: | Category: professional development
Rating: |  Discuss |   Briefcase | 18,675 reads

Using Views

Views can be a great way to abstract away details for clients, but they can also make development much more flexible.  Read more...
By Steve Jones 2014/08/01 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 218 reads

Create First SSRS Report with SQL Server Analysis Services OLAP Cube

Mubin M. Shaikh outlines how to create SSRS Report on SSAS OLAP Cube. If you don't have much prior knowledge of SSRS, just follow the steps and to have your first report ready on OLAP Cube.  Read more...
By Additional Articles 2014/08/01 | Source: | Category: ssrs
Rating:  Rate this |   Briefcase | 9,695 reads

Spackle: Making sure you can connect to the DAC

The DAC is an important tool and several things can go wrong when trying to connect to it.  Read more...
By Kenneth Fisher 2014/07/31 | Source: | Category: dac
Rating: |  Discuss |   Briefcase | 2,767 reads
<< Newer    Items 41 to 60 of 12979    Older >>