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,765,406 DBAs, developers and SQL Server users

Rss
Headlines today   November 26, 2014

Stairway to SQL Server Indexes: Level 2, Deeper into Nonclustered Indexes

By this stage, you should be familiar with the basics of SQL Server indexes. We've discussed what an Index actually is, as well as some of the most common types you're likely to encounter. Now that we've seen some simple examples of how Indexes can be useful, we're going to delve deeper into nonclustered indexes, as we'll see how they can improve the performance of more complex queries.  Read more...
By David Durant 2014/11/26 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 20,347 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2014/11/26 (first published: 2013/08/21) | Source: Red-Gate | Category: performance tuning
Rating:  Rate this |   Briefcase | 39,521 reads

SSIS 2012 Projects: Deployment Configurations and Monitoring

The Project Deployment Model introduced in SSIS 2012 speeds up the deployment of database projects in which there may be hundreds of SSIS packages per project. Not only that, but deployments can be configured differently for each environments such as test and staging, and there are now ways of monitoring the status and performance of packages and of versioning the SSIS Catalog.  Read more...
By Additional Articles 2014/11/26 | Source: SimpleTalk | Category: ssis
Rating: (not yet rated)  Rate this |   Briefcase | 2,769 reads
Previous headlines

Using SQL Server Stored Procedures in SSIS Data Flow Sources

A technique to deal with lack of metadata for stored procedures when used with SSIS.  Read more...
By Adán Bucio 2014/11/25 | Source: SQLServerCentral.com | Category: data flow task (ssis)
Rating: |  Discuss |   Briefcase | 3,231 reads

Building an Automated Database Deployment Pipeline

Data and databases are historically ignored or given a low priority within the processes of ALM and DevOps. This situation needs to change and the primary point of the changes is within the database professional part of the team.  Read more...
By Additional Articles 2014/11/25 | Source: SQL Server Magazine | Category: database deployment
Rating:  Rate this |   Briefcase | 4,287 reads

Data Mining Part 22: Analyze the Data Mining Data with Excel

This is the last article related to Data Mining in Excel. This last chapter will cover the Analyze section.  Read more...
By Daniel Calbimonte 2014/11/24 | Source: SQLServerCentral.com | Category: data
Rating: (not yet rated) |  Discuss |   Briefcase | 1,721 reads

The Salesforce Platform: The Return of the Citizen Programmer

The current popularity of the Salesforce software development platform has taken the industry by surprise. The current IT culture favours the esoteric, yet here is a development platform geared to the idea that anyone can use it: a populist language like BASIC. Does this threaten the careers of professional developers?  Read more...
By Additional Articles 2014/11/24 | Source: SimpleTalk | Category: salesforce
Rating: (not yet rated)  Rate this |   Briefcase | 6,641 reads

Generate SSRS reports from a SSIS Package

Learn how to invoke SSRS reports from an SSIS package after the data load is completed.  Read more...
By Ravindra Chhabria 2014/11/21 (first published: 2012/10/09) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 15,328 reads

Questions About Using TSQL to Import Excel Data You Were Too Shy to Ask

It is easy to import Excel data into database tables via TSQL, using OLEDB, either by the OPENROWSET function or linking to the spreadsheet as a server. The problem is that there are certain things that aren't obvious that you need to know about.  Read more...
By Additional Articles 2014/11/21 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 7,305 reads

Distribution Database Migration

This article shows a step-by-step guide to move the distribution database to a new SQL Server instance.  Read more...
By Valerij Urban 2014/11/20 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 1,798 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Vital Statistics and Health Checks

This post has nothing, absolutely nothing, to do with SQL Server. It does, however, relate to your career as a...  Read more...
By Tracy McKibben 2014/11/26 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,605 reads

Exam Prep 70-463: More about Dimensions   Recently updated !

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...  Read more...
By Colleen M. Morrow 2014/11/26 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,375 reads
Question of the Day

IF EXISTS vs @@ROWCOUNT

By Anju Renjith 2014/11/26 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 855 reads

Suppose I have created a table variable @table with 2 columns - col1 is an identity column and col2 is a integer column. I insert 4 rows to the table. I...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Michael J Clayton
686 742 Right there with Babe  
2.
Shiva N
325 584 Mr or Mrs. 500  
3.
ksatpute123
282 854 SSC Eights!  
4.
RK Mandava
280 1872 SSCommitted  
5.
ketaki25
270 1195 Ten Centuries  
Latest forum posts