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

Reporting Services: Drawing a Buffer on a Map

Handle together SQL Server spatial data features and Reporting Service design tools to build a map-based interactive report.  Read more...
Rating: |  Discuss |   Briefcase | 3,795 reads

There Are Always Constraints

We must learn to deal with the reality of our situation, along with the limitations.  Read more...
By Steve Jones 2015/07/21 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 103 reads

Analyzing I/O Performance for SQL Server

Inadequate storage is one of the most common bottlenecks seen in subsystem performance. There are a number of reasons for poor storage performance, but measuring it and understanding what needs to be measured and monitored is always a useful exercise.   Read more...
By Additional Articles 2015/07/21 | Source: | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 4,292 reads

SQL Monitor Custom Metric: Table size (MB)

This metric is useful if you want to know exactly how much physical space a particular table is taking up, including the size of its indexes.  Read more...
By Press Release 2015/07/21 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,344 reads

Changing SQL Server Database Logical Names

SQL Server Databases are made up of physical and logical names. This article goes over the logical names, where you might need to know them, and then how to change them.  Read more...
By Shawn Melton 2015/07/20 | Source: | Category: sql server
Rating: |  Discuss |   Briefcase | 3,954 reads

Learning AlwaysOn

References and links to help you learn about the AlwaysOn technologies.  Read more...
By Site Owners 2015/07/20 | Source: | Category: alwayson
Rating: (not yet rated) |  Discuss |   Briefcase | 1,908 reads

Presenting Data

One important skill is for the DBA or developer of the future is being sure they can present data to clients in a way they can use it.  Read more...
By Steve Jones 2015/07/20 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 152 reads

Are DacPacs ready for prime-time?

DacPacs have been around for a while but DBAs have not, in the past, taken them particularly seriously. Is it time to get involved and influence the way the technology develops?  Read more...
By Phil Factor 2015/07/20 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 92 reads

Parallelize Data Flows with SSIS Balanced Data Distributor Transformation

In this article, Daniel Farina shows how to speed up SSIS package execution by using the Balanced Data Distributor Transformation.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,365 reads

Free webinar: Embracing DLM – The Definitive Guide

Database Lifecycle Management (DLM) is about enabling rapid, risk-free database development and deployments. However, the most effective DLM processes actually reach beyond the database. Embracing the full scope of it can be daunting, so Grant Fritchey and Matthew Skelton are making it manageable.  Read more...
By Additional Articles 2015/07/23 (first published: 2015/07/20) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 4,057 reads

Capturing Baselines on SQL Server: Wait Statistics

By capturing baseline data, a well-prepared DBA should get a good idea of what potential issues they will face. In this article Erin Stellato looks at Wait Statistics and what they can tell you about your databases.  Read more...
By Erin Stellato 2015/07/17 (first published: 2013/02/04) | Source: | Category: baselines
Rating: |  Discuss |   Briefcase | 13,659 reads

Would You Pay To Wear Jeans?

For this Friday, Andy Warren asks if you would pay to change your wardrobe for work.  Read more...
By Andy Warren 2015/07/17 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 175 reads

Azure SQL Database Security Features

The Microsoft Azure platform is evolving fast. Azure SQL Database is riding high on the cloud wave with new features enabled at a fast pace. In this article, Kun Cheng shares a few Azure SQL Database security features that could help developers and DBAs develop and manage a secure SQL Database solution.  Read more...
By Additional Articles 2015/07/17 | Source: SQLCAT | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 5,145 reads

Survey: What are your plans to upgrade SQL Server?

The Microsoft SQL Server product group are evaluating how to better assist with your SQL Server upgrades. With the upcoming SQL Server 2005 extended support deadline fast approaching, they want to understand how to help you migrate to a modern, supported version of SQL Server, and how to provide support and upgrades in future.   Read more...
By Additional Articles 2015/07/17 | Source: Microsoft MSDN | Category: microsoft
Rating: (not yet rated)  Rate this |   Briefcase | 4,564 reads

Resolution for SSIS Package Catastrophic Failure

Solution to overcome SSIS Package Catastrophic Failure Error 
Rating: |  Discuss |   Briefcase | 2,613 reads

10 SQL Snippets For Faster, More Effective Code

How many hours per week do you spend writing the same SQL again and again?  Read more...
By Gaurav Vohra 2015/07/16 | Source: | Category: sql
Rating: |  Discuss |   Briefcase | 5,021 reads

Continuous Delivery In Real Life

Everyone wants to know who is actually using Continuous Deliver for their software. Today Steve Jones has a prominent example.  Read more...
By Steve Jones 2015/07/16 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 236 reads

PowerShell Day-to-Day Admin Tasks: Monitoring Performance

By reading performance counters from services such as SQL Server or Exchange, you can get a wealth of performance information. By automating the process of gathering and storing appropriate counters, you can routinely check a range of devices quickly using visual tools such as PerfMon. By then creating your own counters, you can add counter-based metrics to anything that can be measured programmatically, such as services, applications, processes such as ETL, or deployments. Nicolas Prigent shows you how.  Read more...
By Additional Articles 2015/07/16 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,003 reads

Jump In

Steve Jones encourages you to help others and share your knowledge.  Read more...
By Steve Jones 2015/07/15 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 95 reads

Stairway to Database Source Control Level 1: Setting Up For Database Source Control

The first level of this stairway introduces the basics of source control, some common technologies and technologies, and demonstrates how to start versioning a SQL Server database.  Read more...
By Dave Green 2015/07/15 (first published: 2014/04/23) | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,224 reads
<< Newer    Items 41 to 60 of 13959    Older >>