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

   Items 1 to 20 of 13939    Older >>
 

Visualize the timeline of your SQL jobs using Google graph and email

Generate an HTML page with the timeline of your SQL jobs using Google graph and sp_send_dbmail  Read more...
By Theo Ekelmans 2015/07/28 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 5,313 reads

The Importance of Maintenance on MSDB

MSDB is a system database used by SQL Server. MSDB stores all sorts of data, such as backup history, log shipping monitor history, SSIS packages and Service Broker queue data to name a few. Just like user databases, MSDB needs regular maintenance, including index optimizations and, more importantly, regular purging. In this article, Tim Radney looks at how neglecting your MSDB can negatively impact on your environment.   Read more...
By Additional Articles 2015/07/28 | Source: SQLPerformance.com | Category: msdb
Rating:  Rate this |   Briefcase | 3,320 reads

Visualizing in Space

An amazing visualization of basketball players has Steve Jones encouraging you to find your own pet project and showcase some skills.   Read more...
By Steve Jones 2015/07/28 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 54 reads

Introducing the Set-based Loop

Set-based programming doesn’t mean “no loops” or a single statement. Finding out the best ways to traverse a full hierarchy.  Read more...
By Luis Cazares 2015/07/27 | Source: SQLServerCentral.com | Category: set-based loop
Rating: |  Discuss |   Briefcase | 9,615 reads

Learning Backup to Azure

References and links to get you started in backing up your database to the Azure blob storage.  Read more...
By Site Owners 2015/07/27 | Source: SQLServerCentral.com | Category: backup to azure
Rating: (not yet rated) |  Discuss |   Briefcase | 531 reads

What We Want and What We'll Pay For

The challenges of getting enough resources for our projects aren't always apparent.  Read more...
By Steve Jones 2015/07/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 80 reads

No Downtime Deployments

Can you deploy your database changes without any downtime? Steve Jones has a few notes.  Read more...
By Steve Jones 2015/07/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 50 reads

Can Code Review Be Automated?

Code must be checked, but how? Phil Factor shares his thoughts on automating SQL code reviews.  Read more...
By Additional Articles 2015/07/27 | Source: SimpleTalk | Category: code review
Rating: (not yet rated)  Rate this |   Briefcase | 3,282 reads

Is Skynet Coming?

The poll this week looks to the future and artificial intelligence. Steve Jones wonders if we'll ever really see this.  Read more...
By Steve Jones 2015/07/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 102 reads

SAN and NAS protocols and how they impact SQL Server

Discusses the various SAN and NAS protocols (FC, iSCSI, NFS) and how choosing one over the other can impact your SQL Server Performance.  Read more...
By Gregory Jackson 2015/07/24 (first published: 2012/04/24) | Source: SQLServerCentral.com | Category: san
Rating: |  Discuss |   Briefcase | 14,745 reads

SQL Style Habits: Attack of the Skeuomorphs

Although we like to think that our programming techniques are progressive and in tune with the bleeding edge of software development practices, too often they are directly influenced by restrictions faced when computers first became mainstream in the post-war decades. In this article Joe Celko looks at the history of mainframes, FORTRAN I and COBOL.   Read more...
By Additional Articles 2015/07/24 | Source: SimpleTalk | Category: joe celko
Rating:  Rate this |   Briefcase | 3,359 reads

SQL Explained

A short explanation and infographic of what SQL is. For the non-SQL people in your life.  Read more...
By Additional Articles 2015/07/24 | Source: Other | Category: sql
Rating:  Rate this |   Briefcase | 5,705 reads

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,345 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 | 155 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 | 3,997 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,609 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 | 310 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,469 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,878 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,052 reads
   Items 1 to 20 of 13939    Older >>