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

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,266 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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 146 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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,449 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,903 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: MSSQLTips.com | Category: encryption
Rating: (not yet rated)  Rate this |   Briefcase | 2,747 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: SQLServerCentral.com | 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: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,679 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,056 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,193 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 | 15,020 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,453 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 | 90 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 | 105 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 | 121 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,187 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,946 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,826 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 | 103 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,161 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,499 reads
<< Newer    Items 41 to 60 of 12642    Older >>