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

<< Newer    Items 61 to 80 of 12648    Older >>
 

Getting Started in SQL Server

Preparing for your first (or next) interview or job in SQL Server. A good introduction from Craig Farrell.  Read more...
By Craig Farrell 2014/04/04 (first published: 2010/12/09) | Source: SQLServerCentral.com | Category: career
Rating: |  Discuss |   Briefcase | 12,209 reads

High Performance Relational Division in SQL Server

Relational division is used in SQL to select rows that conform to a number of different criteria. Dwain Camps explains how to use it, and shows the performance gains.   Read more...
By Additional Articles 2014/04/04 | Source: SimpleTalk | Category: relational division
Rating:  Rate this |   Briefcase | 2,954 reads

SQL Monitor Custom Metric: Server principals with default database offline

This metric monitors whether a server principal’s default database is offline. When you create a SQL Server server principal (formerly referred to as a server login) it has a default database setting that is used to assist in a connection request when no database is specified.  Read more...
By Press Release 2014/04/04 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 1,831 reads

The Internet of Things

Today Steve Jones notes that the explosion of cheap hardware and electronics might be good for data professionals.  Read more...
By Steve Jones 2014/04/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 106 reads

SQL Server 2012 AlwaysOn Groups and FCIs Part 3

Part 3 of the AO and FCI integration series. This article gets SQL Server configured on the nodes and ready for work.  Read more...
By Perry Whittle 2014/04/03 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 2,189 reads

How to recover a suspect msdb database in SQL Server

A SQL Server MSDB database is flagged as "suspect"... what can you do? John Grover has some suggestions  Read more...
By Additional Articles 2014/04/03 | Source: MSSQLTips.com | Category: suspect database
Rating: (not yet rated)  Rate this |   Briefcase | 2,513 reads

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,898 reads

Byte Me: Programming Language

Naming conventions are always tricky.  Read more...
By Bob Lang 2014/04/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 701 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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,622 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 backups...save the business.   Read more...
By Additional Articles 2014/04/02 | Source: Red-Gate | Category: backup / recovery
Rating:  Rate this |   Briefcase | 3,772 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,593 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: DEVintersection.com. 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,957 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: SQLServerCentral.com | Category: sql server 2014
Rating:  Rate this |   Briefcase | 9,538 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: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 5,039 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: SQLServerCentral.com | Category: sql server 2014
Rating: (not yet rated)  Rate this |   Briefcase | 2,020 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: SQLServerCentral.com | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 3,900 reads

Telepresence

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: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 93 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: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,423 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: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 105 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,894 reads
<< Newer    Items 61 to 80 of 12648    Older >>