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

SQL Saturday #289 - Orange County, CA

SQL Saturday is coming to Huntington Beach, CA on April 26 2014. This is a free day of training and networking for SQL Server Professionals - there are also 2 paid-for precons on April 25 presented by Jason Horner and Bradley Bell. Register for SQL Saturday Orange County while space is available.  Read more...
By Press Release 2014/04/08 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 1,166 reads

Improving Performance for Some LIKE “%string%” Searches (SQL Spackle)

If you've ever wondered if you can do better than an INDEX SCAN when you do a LIKE "%string%" search, read on...  Read more...
By Dwain Camps 2014/04/07 | Source: SQLServerCentral.com | Category: sql like search
Rating: |  Discuss |   Briefcase | 14,856 reads

Load Testing in a Big Data Environment

Load tests give the database administrator quite a lot of valuable information and may make the difference between poor and acceptable application performance. But are there any gotchas or traps associated with big data?  Read more...
By Additional Articles 2014/04/07 | Source: Database Journal | Category: big data
Rating: (not yet rated)  Rate this |   Briefcase | 3,429 reads

Data Security Policies

Does your organization have policies around data security? Perhaps they should, or perhaps you should ask for some to be created and education available for users.  Read more...
By Steve Jones 2014/04/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 87 reads

Short Stroking and Performance

Disk performance can make a difference to your SQL Server instance. Steve Jones discusses a few things this week.  Read more...
By Steve Jones 2014/04/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 102 reads

Team Reputation

The way that various departments might view a team of technology employees can affect how we interact. Andy Warren remembers a few situations and notes it's always more fun to join a team with a good reputation.  Read more...
By Andy Warren 2014/04/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 120 reads

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,162 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,939 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,821 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 | 101 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,130 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,491 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,889 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 | 684 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,522 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,754 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,529 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,924 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,481 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,013 reads
<< Newer    Items 41 to 60 of 12634    Older >>