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

If or When?

Are data breaches a question of if they will happen to you or when will they happen to you?  Read more...
By Steve Jones 2014/04/10 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 131 reads

How to create an SSIS conditional data flow task

This article demonstrates how to selectively channel records from a flat-file data source to separate destination tables in an SSIS package using a combination of multicast, data-conversion and conditional-split data flow transformation elements within a data flow task.  Read more...
Rating: |  Discuss |   Briefcase | 5,229 reads

Write for SQLServerCentral

We are looking for new content here for the site, based on your experiences in the real world. Submit something and get yourself published.  Read more...
By Site Owners 2014/04/10 | Source: | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 758 reads

Managing SQL Server Services with PowerShell

PowerShell provides a command-line shell and scripting language (built in the .NET Framework) especially designed for administrative task automation and configuration management. Learn how to manage Windows services related to SQL Server, either on a local machine or remote machine, using PowerShell cmdlets.  Read more...
By Additional Articles 2014/04/10 | Source: Database Journal | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,313 reads

Problems with Big Data

Today Steve Jones notes that Big Data isn't a panacea. It's not going to just solve all problems.  Read more...
By Steve Jones 2014/04/09 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 148 reads

Stairway to T-SQL: Beyond The Basics Level 6: Using the CASE Expression and IIF Function

There are times where you need to write a single T-SQL statement that is able to return different T-SQL expressions based on the evaluation of another expression. When you need this kind of functionality you can use the CASE expression or IIF function to meet this requirement. In this Stairway level Gregory Larsen reviews the CASE and IIF syntax and showing you examples of how the CASE expression and IIF function.  Read more...
By Gregory Larsen 2014/04/09 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,534 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2014/04/09 (first published: 2013/07/17) | Source: Red-Gate | Category: concurrency
Rating:  Rate this |   Briefcase | 17,926 reads

How much overhead does encryption add to a SQL Server query

If you have been in the information technology industry long enough, you have probably heard the expression "this adds overhead" when discussing any extra processing added on to what is considered normal processing. Dallas Snider answers the question of additional overhead caused by encryption.  Read more...
By Additional Articles 2014/04/09 | Source: | Category: encryption
Rating: (not yet rated)  Rate this |   Briefcase | 2,829 reads

Lobbying for Change

The Connect system from Microsoft doesn't work that well, but that doesn't mean we shouldn't continue to press Microsoft for change.  Read more...
By Steve Jones 2014/04/08 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 96 reads

Divide and Conquer - Performance Tuning

Sometimes we need to break down a complex problem into a multiple stage solution to achieve optimal performance  Read more...
By Claire Mora 2014/04/08 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,758 reads

14 SQL Server Indexing Questions You Were Too Shy To Ask

The first thing you need to understand about SQL Server is indexes, but somehow many of the basic questions don't often get asked or answered much on forums. Rob Sheldon answers some of these questions about SQL Server Indexes and indexing.  Read more...
By Additional Articles 2014/04/08 | Source: SimpleTalk | Category: indexing
Rating:  Rate this |   Briefcase | 7,205 reads

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,199 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: | Category: sql like search
Rating: |  Discuss |   Briefcase | 15,126 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,474 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: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 92 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: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 109 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: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 122 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: | 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
<< Newer    Items 41 to 60 of 12645    Older >>