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

Quick Survey: PostgreSQL in Your Organization

Do you use PostgreSQL in your organization? Are you thinking about using it? Take our short survey and tell us about what you think about it.  Read more...
By Press Release 2014/09/02 | Source: Red-Gate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 7,063 reads

SQL Monitor Custom Metric: Time Since Last Restore

If your log restores aren't happening when they’re meant to, you want to know about it. You’ll be relying on restoring from logs should anything happen to your databases, and if you can’t restore to a certain point in time, you risk losing valuable data.  Read more...
By Press Release 2014/09/02 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 5,727 reads

Implementing Azure Blob Storage (ABS) With SQL Server 2014

With any application organizations face consistent key challenges such as high efficiency and business value, complex configuration, and low total cost of ownership. Extending applications to the cloud in hybrid scenarios addresses many of these challenges, whether distributing SharePoint content across on-premises and Office 365 while leveraging search as a service (hybrid search) or externalizing data, extending it to the cloud with Remote Blob Storage or related technologies.   Read more...
By Additional Articles 2014/09/02 | Source: Microsoft MSDN | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 5,348 reads

Happy Labor Day 2014

It's a holiday in the US  Read more...
By Steve Jones 2014/09/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 68 reads

Using the Script Task in SSIS to Process Data Files When They Arrive

Learn how you can process data files with SSIS as soon as they arrive using the Script Task.  Read more...
By Orlando Colamatteo 2014/09/01 (first published: 2012/10/25) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 24,775 reads

New toys in SQL Server 2012

In this article we are going to look two new enhancements: the Insert snippet menu option and the surround with option.  Read more...
By Daniel Calbimonte 2014/09/01 (first published: 2012/05/15) | Source: SQLServerCentral.com | Category: insert
Rating: |  Discuss |   Briefcase | 17,931 reads

More Text Analysis with the SSIS Term Lookup Component

As mentioned before, we will use the same use case in this tip as used with the Term Extraction component, which is an archive of all my tweets I've downloaded from Twitter. Using this archive and the Term Extraction transformation I found out which topics I particularly tweeted about in the past years or which persons I mentioned the most.   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 5,789 reads

On the importance of a complete break

If you’re the type who habitually checks work email and thinks about work while on holiday, here’s Gail Shaw's challenge for next time: don’t.  Read more...
By Gail Shaw 2014/09/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 109 reads

Data Mining Introduction Part 2

This is a continuation of first article about Data Mining. We will talk about decision trees.  Read more...
By Daniel Calbimonte 2014/08/29 (first published: 2012/12/31) | Source: SQLServerCentral.com | Category: data mining
Rating: |  Discuss |   Briefcase | 14,928 reads

Hooks

Building hooks from your software into enterprise monitoring systems is prudent, and might save you from a few late night phone calls.  Read more...
By Steve Jones 2014/08/29 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 148 reads

A TDD Journey: 2 - Naming Tests; Mocking Frameworks; Dependency Injection

Test-Driven Development (TDD) relies on the repetition of a very short development cycle starting from an initially failing automated test that defines the functionality that is required, and then producing the minimum amount of code to pass that test, and finally refactoring the new code.   Read more...
By Additional Articles 2014/08/29 | Source: SimpleTalk | Category: tdd
Rating: (not yet rated)  Rate this |   Briefcase | 6,094 reads

Free SQL in the City Seminar Cambridge, MA – Oct 8, 2014

SQL Server MVP Grant Fritchey and Steve Jones will present the Stairway to Continuous Delivery in Cambridge this October in place of the NESSUG meet-up. Learn how to build an efficient development and deployment process for your organization. Register for this free event.  Read more...
By Press Release 2014/08/29 | Source: SQL in the City | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 5,368 reads

Data Mining: Part 15 Processing Data Mining components with SSIS

In this lesson, we will show different components to Administer the Data Mining Models with SSIS.  Read more...
By Daniel Calbimonte 2014/08/28 | Source: SQLServerCentral.com | Category: data
Rating: |  Discuss |   Briefcase | 1,848 reads

Reverse Engineering Disasters

Preparing a disaster recovery plan means more than just trying to prevent a few specific disasters. It means turning around the way you view the world.  Read more...
By Steve Jones 2014/08/28 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 143 reads

SQL Server AlwaysOn Availability Groups Fail the Initial Failover Test

The first test of AlwaysOn in SQL Server 2012 is successful, but after testing to swing back again to your primary replica, you find out that automatic failover works only the first time. How come? Carla Abanes explains.  Read more...
By Additional Articles 2014/08/28 | Source: MSSQLTips.com | Category: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 6,011 reads

Stairway to PowerPivot and DAX - Level 6: The DAX SUM() and SUMX() Functions

Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson exposes the DAX SUM() and SUMX() functions, comparing and contrasting the two. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in managing “sum” aggregations within our PowerPivot model designs.  Read more...
By Bill Pearson 2014/08/27 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,165 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2014/08/27 (first published: 2013/08/07) | Source: Red-Gate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 30,682 reads

Byte Me: The One

The apparel oft proclaims the man.  Read more...
By Bob Lang 2014/08/27 | Source: SQLServerCentral.com | Category: byte me
Rating: |  Discuss |   Briefcase | 183 reads

Questions about T-SQL Expressions You Were Too Shy to Ask

Nobody seems to ask questions about SQL Expressions in forums, even though expressions can cause all sorts of problems. It's time for some straight-forward Q&As, and who better than Robert Sheldon to give the A?  Read more...
By Additional Articles 2014/08/27 | Source: SimpleTalk | Category: expressions
Rating: (not yet rated)  Rate this |   Briefcase | 10,314 reads

SQL Server Service Engine fails to start after applying CU4 for SQL Server 2008 SP1

After performing an update on SQL Server, SQL Server Engine and SQL Agent stop responding.  Read more...
By Hilda E 2014/08/26 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 2,918 reads
<< Newer    Items 41 to 60 of 13054    Older >>