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

Mission Critical Deployments

Is a software deployment responsible for a plane crash? That's a scary thought.  Read more...
By Steve Jones 2015/08/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 94 reads

Nope to NoOps, No way to NoDBA

Phil Factor suspect the NoOps movement is dressing up some old mistakes in fancy new clothes.  Read more...
By Phil Factor 2015/08/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 194 reads

Free webinar: DLM Demo

Redgate’s Database Lifecycle Management solution ensures database changes made in development environments are always tested and reviewed before being deployed, and adds automation to the process. Find out how by joining Steve Jones, MVP and editor of SQLServerCentral, as he demonstrates the solution and shows why such an approach is essential if you want to release changes frequently.  Read more...
By Additional Articles 2015/08/17 (first published: 2015/08/11) | Source: Redgate | Category: dlm
Rating: (not yet rated)  Rate this |   Briefcase | 5,937 reads

MySQL Error Handling using the Signal and Resignal Statements

MySQL introduced the SIGNAL and RESIGNAL statements in version 5.5 to allow you to raise your own error conditions from stored procedures, triggers, and events. Rob Gravelle demonstrates how to utilize both.  Read more...
By Additional Articles 2015/08/17 | Source: Database Journal | Category: mysql
Rating: (not yet rated)  Rate this |   Briefcase | 1,483 reads

Stairway to MDX - Level 13: MDX Time/Date Series Functions: LastPeriods() and ParallelPeriod() Functions

BI Architect Bill Pearson continues with the third of a subseries surrounding a group of MDX functions we can use to support analysis and reporting in a time / date context. In this Level, we will explore the LastPeriods() and ParallelPeriod() functions, and get hands-on practice with each in meeting sample business requirements.  Read more...
By Bill Pearson 2015/08/14 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,848 reads

Free webinar: DLM Demo

Redgate’s Database Lifecycle Management solution ensures database changes made in development environments are always tested and reviewed before being deployed, and adds automation to the process. Find out how by joining Steve Jones, MVP and editor of SQLServerCentral, as he demonstrates the solution and shows why such an approach is essential if you want to release changes frequently.  Read more...
By Additional Articles 2015/08/17 (first published: 2015/08/11) | Source: Redgate | Category: dlm
Rating: (not yet rated)  Rate this |   Briefcase | 5,937 reads

How many environments?

This Friday Steve Jones looks at the setup for your software pipeline. He's wondering how complex it is with how many separated environments.  Read more...
By Steve Jones 2015/08/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 100 reads

Configure the SQL Server Integration Services For Loop Container

Dallas Snider looks at how you can configure the SQL Server Integration Services For Loop Container. He explores what options are available, how you can establish variables and how you can you test the process.  Read more...
By 2015/08/14 | Source: MSSQLTips.com | Category: integration services
Rating: (not yet rated)  Rate this |   Briefcase | 2,477 reads

The Tally Table

The tally table is a valuable tool for a SQL Server developer, but how many of you understand how to create and use one?  Read more...
By Steve Jones 2015/08/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 279 reads

Data Mining Part 31: DMX functions

In this chapter, we will learn how to use some DMX functions in our mining models.  Read more...
By Daniel Calbimonte 2015/08/13 | Source: SQLServerCentral.com | Category: data mining
Rating: (not yet rated) |  Discuss |   Briefcase | 1,712 reads

What is Database Lifecycle Management (DLM)?

When the different teams that are involved throughout the life of a database fail to reconcile their different roles and priorities, and so fail to cooperate or work adaptively, the result is gridlock: databases defined as though carved in stone rather than by code and data. William Brewer explores how DLM can offer an alternative that allows databases to respond quickly to business change.  Read more...
By Additional Articles 2015/08/13 | Source: SimpleTalk | Category: dlm
Rating: (not yet rated)  Rate this |   Briefcase | 5,425 reads

Free Webinar: Should your databases be Continuously Delivered?

If you want to learn more about Continuous Delivery, and where your databases fit into the picture, join Dave Farley on September 2nd for a webinar covering why databases are an essential component of CD, and how to start modernizing your software development practices.  Read more...
By Additional Articles 2015/08/31 (first published: 2015/08/13) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 6,574 reads

Business Pressures

The business pressures can often change how we work, or even how we build our software. A few notes on Github from Steve Jones.  Read more...
By Steve Jones 2015/08/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 94 reads

Stairway to Biml Level 3: Building an Incremental Load Package

The Stairway to BIML continues, with a lesson on how you might build a more complex package: an incremental load package.  Read more...
By Andy Leonard 2015/08/12 (first published: 2013/08/07) | Source: SQLServerCentral.com | Category: biml
Rating: |  Discuss |   Briefcase | 16,585 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2015/08/12 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 43,652 reads

Proactive SQL Server Health Checks, Part 4 : ERRORLOG

Don't underestimate the ERRORLOG. There is some great information in it for you to use not just when you're troubleshooting performance or investigating errors, but also when you're proactively monitoring an instance. Erin Stellato explains.  Read more...
By Additional Articles 2015/08/12 | Source: SQLPerformance.com | Category: errorlog
Rating: (not yet rated)  Rate this |   Briefcase | 3,060 reads

Why PolyBase matters - Part 2

Part 2, a more in depth look at An alternative approach to disaster recovery and backup strategies using PolyBase.   Read more...
By Alain Dormehl 2015/08/11 | Source: SQLServerCentral.com | Category: disaster recovery
Rating: |  Discuss |   Briefcase | 1,534 reads

Making Guesses

When working on a new database, Steve Jones hesitates to make too many guesses, or at least, too many exact guesses.  Read more...
By Steve Jones 2015/08/11 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 111 reads

Creating Dashboards for Mobile Devices with Datazen – Part 1

With the recent acquisition of Datazen by Microsoft, if you have SQL Server 2008 or later Enterprise Edition with Software Assurance, you can leverage (download and use) Datazen to create visually appealing dashboards for mobile devices across all the major platforms at no additional costs. In this article series Arshad Ali will demonstrate how you can use Datazen for creating dashboards and KPIs (Key Performance Indicators) for mobile devices easily and quickly.  Read more...
By Additional Articles 2015/08/11 | Source: Database Journal | Category: datazen
Rating: (not yet rated)  Rate this |   Briefcase | 4,243 reads

Free webinar: DLM Demo

Redgate’s Database Lifecycle Management solution ensures database changes made in development environments are always tested and reviewed before being deployed, and adds automation to the process. Find out how by joining Steve Jones, MVP and editor of SQLServerCentral, as he demonstrates the solution and shows why such an approach is essential if you want to release changes frequently.  Read more...
By Additional Articles 2015/08/17 (first published: 2015/08/11) | Source: Redgate | Category: dlm
Rating: (not yet rated)  Rate this |   Briefcase | 5,937 reads
<< Newer    Items 41 to 60 of 14034    Older >>