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

Rss
Headlines today   November 25, 2014

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 | 2,887 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: (not yet rated)  Rate this |   Briefcase | 3,542 reads
Previous headlines

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,624 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,106 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,181 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,141 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,756 reads

Monitoring Azure SQL Database

Marcin Policht presents different methods that allow you to monitor the performance and characteristics of your PaaS databases, ensuring that they behave in a manner that matches your expectations.  Read more...
By Additional Articles 2014/11/20 | Source: Database Journal | Category: sql azure
Rating: (not yet rated)  Rate this |   Briefcase | 5,945 reads

Stairway to SQL Server Agent - Level 2: Job Steps and Subsystems

SQL Server Agent jobs are made up of a series of one or more Job Steps. A job step is assigned to a specific job subsystem, which identifies the kind of work the job step is going to perform. Each job step runs in a separate security context, although each job also has an owner that determines who can modify the job.  Read more...
By Richard Waymire 2014/11/19 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 6,363 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2014/11/19 (first published: 2013/08/14) | Source: Red-Gate | Category: transaction logs
Rating:  Rate this |   Briefcase | 44,571 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

T-SQL Tricks – Custom Templates

I wrote about the Template Explorer, which comes with the SQL Server tools and is visible in Management Studio (SSMS)....  Read more...
By Steve Jones 2014/11/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,099 reads

Exam Prep 70-463: Tables and Schemas   Recently updated !

Well, the PASS Summit has come and gone and it was *awesome*.  What a difference from my first Summit experience,...  Read more...
By Colleen M. Morrow 2014/11/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,549 reads
Question of the Day

In The Beginning

By Sean Pearce 2014/11/25 | Category: datetime
Rating: (not yet rated) |  Discuss |   Briefcase | 1,039 reads

According to the DATETIME datatype in SQL Server, when is the beginning of time?


  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
317 573 Mr or Mrs. 500  
3.
ksatpute123
287 854 SSC Eights!  
4.
RK Mandava
280 1872 SSCommitted  
5.
ketaki25
270 1195 Ten Centuries  
Latest forum posts