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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,746,127 DBAs, developers and SQL Server users

Rss
Headlines today   September 1, 2014

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 | 19,136 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 | 14,971 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 | 336 reads
Previous headlines

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,076 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 | 4,101 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 | 3,547 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,501 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 | 4,273 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 | 1,899 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 | 28,826 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Painful or Helpful? No SSMS Multiserver Results if One Instance Errors

I've been going back and forth with this question for a few days now. If one instance in a multiserver query presents an...  Read more...
By William Assaf 2014/09/01 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 260 reads

Better Presentations–Hide those Windows

This is part of a series of tips for speakers to make your presentations better. I wanted to give some specific SQL...  Read more...
By Steve Jones 2014/09/01 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 338 reads
Question of the Day

Happy Monday

By Steve Jones 2014/09/01 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 148 reads

I run this: 


select dbo.udf_DT_NthDayInMon('2014', 9, 1, 'Mon');
What happens? This is based on this wonderful function from Andrew Novick:


CREATE FUNCTION dbo.udf_DT_NthDayInMon (
@nYear as int
, @nMonth as int
, @nthOccurance as int...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Eirikur Eiriksson
405 1766 SSCommitted  
2.
cruice
345 907 SSC Eights!  
3.
GilaMonster
327 42822 SSC-Forever  
4.
ben.mercer
310 337 Old Hand  
5.
crussell-931424
295 2677 SSCrazy  
Latest forum posts