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

DBA Skills - Creating a Striped Backup

Learn how to create a striped backup in this short piece.  Read more...
By Steve Jones 2015/02/18 | Source: SQLServerCentral.com | Category: dba skills
Rating: |  Discuss |   Briefcase | 462 reads

SSIS Catalog Environments– Step 20 of the Stairway to Integration Services

In this next level of the Stairway to Integration Services, we look at the SSIS catalog environments and how they help you manage your package parameters.  Read more...
By Andy Leonard 2015/02/18 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,837 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 2015/02/18 (first published: 2013/07/30) | Source: Red-Gate | Category: execution plans
Rating:  Rate this |   Briefcase | 58,965 reads

Application Containers For Cloud Computing

Containers promise to make applications more portable and efficient. The technology, originally based on Linux's cgroups, provides a way of running several applications as modular, platform-agnostic packages in isolation on the same server. Docker's open-source approach to containers has dominated the market, and Microsoft is producing its own equivalent Windows system. What next? Will Containers replace VMS? Robert Sheldon investigates.  Read more...
By Additional Articles 2015/02/18 | Source: SimpleTalk | Category: containers
Rating: (not yet rated)  Rate this |   Briefcase | 7,498 reads

Byte Me: Bug Out

The right tools for the job.  Read more...
By Bob Lang 2015/02/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 337 reads

The Real World: Rebuilding Index - 1 Instance, 106 Databases

The article show a simple way we managed to schedule index rebuild and reorg for an SQL instance with 106 databases used by one application using a Scheduled job.  Read more...
By Kenneth Igiri 2015/02/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 5,266 reads

Automate SQL Server Express Backups and Purge Old Backups

SQL Server Express Edition does not include SQL Server Agent in order to schedule the SQL Server database backups. Here's how to automate the backups for SQL Server Express Edition and make sure the old backup files are deleted.  Read more...
By Additional Articles 2015/02/17 | Source: MSSQLTips.com | Category: sql server express
Rating: (not yet rated)  Rate this |   Briefcase | 9,437 reads

SQL Monitor Custom Metric: Tempdb Allocation Contention

If your code uses temporary tables, variable tables or dynamic cursors, this metric can help identify whether you have contention on tempdb allocation. Tempdb is shared by all databases and is used for many operations in a SQL Server instance, so it is common for tempdb to cause performance problems.  Read more...
By Additional Articles 2015/02/17 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 7,113 reads

SQL Injection, Still?

We still have problems with SQL Injection. Steve Jones has a few thoughts on why.  Read more...
By Steve Jones 2015/02/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 190 reads

What’s going on, on my server, right now?

Quick and easy way to monitor server activity and be notified from alerts.  Read more...
By Kimberly Killian 2015/02/16 (first published: 2013/07/23) | Source: SQLServerCentral.com | Category: sql monitoring
Rating: |  Discuss |   Briefcase | 17,941 reads

Managing Test Data as a Database CI Component - Part 1

Constructing a test environment for your databases can be a difficult task at the best of times. Once you’ve actually acquired the hardware needed and architected the environment, you still have to arrange and securely transport the data. And with the rising demand for fast feedback and continuously integrated processes, having all of this automated and operating at speed is a challenge all of its own.  Read more...
By Additional Articles 2015/02/16 | Source: SimpleTalk | Category: test data
Rating:  Rate this |   Briefcase | 6,322 reads

How do you develop and deploy your database?

Could you spare 3 minutes to do us a quick favor? Redgate’s running this short survey on how our readers develop and deploy databases. It’s just 12 multiple choice questions, so if you’ve got a couple of minutes to spare, we’d love to hear from you.  Read more...
By Press Release 2015/02/26 (first published: 2015/02/05) | Source: Red-Gate | Category: deployment process
Rating: (not yet rated)  Rate this |   Briefcase | 14,081 reads

Salaries and Experience

Experience matters in setting your salary, but Steve Jones reminds us there are different types of experience, and there's more to life than money.  Read more...
By Steve Jones 2015/02/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 1,000 reads

Outpacing Change

The law seems to be failing to with the boons and pitfalls of technology.  Read more...
By Dave Convery 2015/02/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 50 reads

Closer to the Heart

This week Steve Jones wonders where you would work if you had the chance.  Read more...
By Steve Jones 2015/02/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 111 reads

Understanding Graphical Execution Plans - Part 1: Explaining the Plan

Understanding execution plans is a good basic skill for all DBA's and SQL developers. Darren White gives us an overview of what execution plans are in SQL Server and how they are used.  Read more...
By Darren White 2015/02/13 (first published: 2014/02/18) | Source: SQLServerCentral.com | Category: execution plan
Rating: |  Discuss |   Briefcase | 21,386 reads

Cascaded Parameters in SQL Server Reporting Services

You have a reporting requirement where a user has two or more parameters for a single report, but the values for one parameter depend on the values chosen in a previous parameter. Ghanesh Prasad explains how to create cascaded parameters in SQL Server Reporting Services to solve this issue.  Read more...
By Additional Articles 2015/02/13 | Source: MSSQLTips.com
Rating: (not yet rated)  Rate this |   Briefcase | 7,129 reads

SQL Saturday #371 - Tampa, FL

SQL Saturdau is coming to Tampa on February 28, 2015. This is a free training event for those wanting to learn about SQL Server. Register while space is available.  Read more...
By Additional Articles 2015/02/13 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 5,887 reads

Starting a New Job

Steve Jones talks about starting a new job and the need to get up to speed quickly, perhaps by being prepared on day 1.  Read more...
By Steve Jones 2015/02/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 176 reads

How to use the IsNothing Inspection Function in SSRS

SSRS includes multiple functions that can be used in within an expression. This article hopes to just show an example of how to use the IsNothing function in an SSRS report.  Read more...
By Shawn Melton 2015/02/12 | Source: SQLServerCentral.com | Category: report development
Rating: |  Discuss |   Briefcase | 4,337 reads
<< Newer    Items 41 to 60 of 13530    Older >>