Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

<< Newer    Items 21 to 40 of 13947    Older >>
 

Is It Worth Writing Unit Tests?

What's the overhead for writing unit tests? Ed Elliot breaks it down, looking at the ways in which unit tests both take more time and save time.  Read more...
By Ed Elliott 2015/07/23 | Source: SQLServerCentral.com | Category: unit testing
Rating: |  Discuss |   Briefcase | 5,463 reads

The Evolving DBA

The job of the DBA is constantly evolving, but one thing has always been critical: access to data.   Read more...
By Steve Jones 2015/07/23 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 167 reads

Large SQL Server Database Backup on an Azure VM and Archiving

For a large SQL Server database on an Azure VM, backing up the data can have some challenges. In this article, Murshed Zaman focuses on the two most common challenges: size and speed.  Read more...
By Additional Articles 2015/07/23 | Source: SQLCAT | Category: azure vm
Rating:  Rate this |   Briefcase | 4,173 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 | 3,732 reads

Byte Me:Oracle

Asking the right questions the wrong way.  Read more...
By Bob Lang 2015/07/22 | Source: SQLServerCentral.com | Category: byte me
Rating: |  Discuss |   Briefcase | 311 reads

Stairway to MDX - Level 12: : MDX Time/Date Series Functions: OpeningPeriod() and ClosingPeriod() Functions

BI Architect Bill Pearson continues with the second of a set of articles surrounding a group of MDX functions specialized to support the analysis of data within the context of time / date. In this article, we will explore the OpeningPeriod() and ClosingPeriod() functions, and get hands-on practice with each in meeting sample business requirements.  Read more...
By Bill Pearson 2015/07/22 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,508 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's new In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2015/07/22 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 10,961 reads

Azure Event Hubs

If you need to receive and process a large volume of of packets of data, such as telemetry, or event-log items, it may be worth considering Azure Event hubs. They aren't like traditional messaging but represent more of a stripped down one-way event processing system for large volumes of data. It could represent a good solution to an ever-present problem, but is it ready for production use? Rob Sheldon investigates.  Read more...
By Additional Articles 2015/07/22 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,180 reads

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,675 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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 102 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: SQLPerformance.com | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 4,113 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,192 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: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 3,789 reads

Learning AlwaysOn

References and links to help you learn about the AlwaysOn technologies.  Read more...
By Site Owners 2015/07/20 | Source: SQLServerCentral.com | Category: alwayson
Rating: (not yet rated) |  Discuss |   Briefcase | 1,831 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: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 144 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: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 90 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,246 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 | 3,732 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: SQLServerCentral.com | Category: baselines
Rating: |  Discuss |   Briefcase | 13,546 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: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 166 reads
<< Newer    Items 21 to 40 of 13947    Older >>