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

Data Science Laboratory System - Distributed File Databases

Distributed File Databases manage large amounts of unstructured or semi-structured data. Buck Woody shows how to install Hadoop in your Data Science lab to experiment with an example of the breed.  Read more...
By Additional Articles 2014/04/03 | Source: SimpleTalk | Category: data science
Rating:  Rate this |   Briefcase | 1,833 reads

Byte Me: Programming Language

Naming conventions are always tricky. 
By Bob Lang 2014/04/02 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 667 reads

Stairway to T-SQL: Beyond The Basics Level 5: Storing Data in Temporary Tables

There are times when retrieving data for complex business requirement requires you to temporarily store one or more results sets for a short period of time. Typically these temporary tables are stored in the scope of the current connection, but they may also need to be available across multiple connections.   Read more...
By Gregory Larsen 2014/04/02 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,419 reads

The Girl with the Backup Tattoo

The DBA Team are back, ready to save another DBA. In this episode, a rogue DBA sabotages the backups, can Robyn Page, Steve Jones, Grant Fritchey, and Phil Factor find the solution? Save the the business.   Read more...
By Additional Articles 2014/04/02 | Source: Red-Gate | Category: backup / recovery
Rating:  Rate this |   Briefcase | 3,715 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/04/02 (first published: 2013/07/30) | Source: Red-Gate | Category: execution plans
Rating:  Rate this |   Briefcase | 19,449 reads

DEVintersection: Developers, ITHeros, Industry-experts Intersect Here!

Intersect with your favorite Microsoft experts in Orlando, Florida April 13-16, 2014 at this year’s most exciting tech conference: Register with the discount code "RedSimple" for $50 off your registration.  Read more...
By Press Release 2014/04/02 | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 3,873 reads

SQL Server 2014 Has Been Released

Today is the first day of general availability for SQL Server 2014.  Read more...
By Press Release 2014/04/01 | Source: | Category: sql server 2014
Rating:  Rate this |   Briefcase | 9,423 reads

Limited Time Offer: Licensing by Scale for SQL Server

With the release of SQL Server 2014, the licensing options have changed slightly. Read on to discover how you might choose to change your licensing in the future.  Read more...
By Steve Jones 2014/04/01 | Source:
Rating: |  Discuss |   Briefcase | 4,998 reads

SQL Server 2014 New Defaults

SQL Server 2014 is being released and a change in the defaults will ensure that more instances will run smoother.  Read more...
By Grant Fritchey 2014/04/01 | Source: | Category: sql server 2014
Rating: (not yet rated)  Rate this |   Briefcase | 2,002 reads

Native C# in Stored Procedures

A new enhancement in SQL Server 2014 allows you to directly enter C# code in your stored procedures.  Read more...
By Steve Jones 2014/04/01 | Source: | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 3,855 reads


Today Steve Jones notes that an advance in technology will help change the way he works.  Read more...
By Steve Jones 2014/04/01 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 92 reads

Solid State Tapes–Prelaunch News!

In the world of data it’s always been about speed. SSD’s have become very common on consumer machines and not unusual in corporate datacenters.   Read more...
By Andy Warren 2014/03/31 | Source: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,378 reads

X in Technology

Steve Jones talks about the women in technology, and other efforts to help minorities.  Read more...
By Steve Jones 2014/03/31 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 103 reads

Database Master Key Error After Database Restore

When restoring a database to another server, you may get a master key error if using symmetric keys   Read more...
Rating: |  Discuss |   Briefcase | 2,839 reads

Applying The Scientific Method to SQL Server Performance Tuning

A relational database is a complex machine that is asked to deal with intricate problems. When things go wrong, it usually takes knowledge, deduction and a systematic approach to track down the root core of problems and to determine the best fix, Joshua Feierman illustrates how this can be done.  Read more...
By Additional Articles 2014/03/31 | Source: SimpleTalk | Category: problem solving
Rating:  Rate this |   Briefcase | 5,450 reads

David McCandless Keynoting at PASS Business Analytics Conference 2014

Bringing together business analysts, data scientists, and business intelligence and IT pros, the PASS BA Conference will feature 65+ best-practices, how-to, and strategy sessions by top BA/BI experts. Keynoting this year is Information Is Beautiful author David McCandless.  Read more...
By Press Release 2014/03/31 | Source: | Category: pass
Rating: (not yet rated) |  Discuss |   Briefcase | 309 reads

IT Skills Shortage? No, Just Looking in the wrong place

In which Phil ruminates on the ridiculous idea that we in the West suffer from an IT skills shortage. In truth we have a very blinkered idea of the sort of person who would succeed in an IT Development role   Read more...
By Phil Factor 2014/03/31 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 159 reads

The Perfect Environment

All our environments for SQL Server are different, but Andy Warren wonders if each of us might have a "perfect environment." Would things be standardized to make administration consistent? Or perhaps flexible to allow each instance to be tailored to its own needs.  Read more...
By Andy Warren 2014/03/28 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 116 reads

The SQL Server 2008 Datetimeoffset Data Type

The Datetimeoffset Data Type was introduced in SQL Server 2008 (and .Net Frameword 3.5) and is the most advanced date and time date type available.  Read more...
By James Skipwith 2014/03/28 (first published: 2011/04/18) | Source: | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 12,814 reads

AlwaysOn Availability Groups - What Not to do when Adding Databases

SQL Server's AlwaysOn Availability Groups provide a very resilient way of providing High-availability for SQL Server databases, but there are inevitable limits to their capacity. Warwick Rudd explains some of the dos and don'ts when adding databases.  Read more...
By 2014/03/28 | Source: SimpleTalk | Category: alwayson
Rating:  Rate this |   Briefcase | 4,544 reads
<< Newer    Items 41 to 60 of 12622    Older >>