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

Rss
Headlines today   February 9, 2010

Forecasting with SQL

Can you use SQL Server to extrapolate out trends from your data? Lots of companies would have you buy a BI solution instead, but new author Mark Wojciechowicz brings us a great example of how you could forecast something in T-SQL.  Read more...
By Mark Wojciechowicz 2010/02/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 4,946 reads

Introducing SQL Server 2008 and 2008 R2 Integration Services

The latest release of SSIS strengthens its position as one of the primary foundations of Business Intelligence, delivering a powerful framework for solutions that combine data from disparate sources, facilitating its analysis and reporting. Join Marcin Policht as he reviews its general characteristics.  Read more...
By Additional Articles 2010/02/09 | Source: Database Journal | Category: sql server 2008
Rating: (not yet rated)  Rate this |  Briefcase | 1,385 reads
Previous headlines

A guide to recover a database out from Suspect mode

This is a guide to bring back a database back from Suspect status. This covers common causes and the steps to resolve the situation.  Read more...
Rating: |  Discuss |  Briefcase | 5,074 reads

PASS Virtualization Presents: SQL Meets Virtual CPUs, Memory, and Storage

Upcoming webcasts in February on the 9th and 10th of the month.  Read more...
By Press Release 2010/02/08 (first published: 2010/02/04) | Source: PASS | Category: pass
Rating: |  Discuss |  Briefcase | 1,555 reads

SQL Server Third Party Application Requirements Document / Checklist

In August 2009 I wrote a tip concerning checklists for third-party applications running against Microsoft SQL Server. I thought it was a good time to revisit the topic and provide an added bonus: a requirements document that you can download and customize for your own uses.   Read more...
By Additional Articles 2010/02/08 | Source: MSSQLTips.com | Category: documentation
Rating: (not yet rated)  Rate this |  Briefcase | 1,120 reads

TSQL Challenge 23 - Calculate the uptime and downtime of a system by reading the data from an audit log

It is again time to play with some date/time values. This challenge involves reading the audit log entries generated by a monitoring application and create a report that shows the up-time and down-time of a system that the application is monitoring.  Read more...
By Press Release 2010/02/08 | Source: T-SQL Challenges | Category: t-sql challenges
Rating: (not yet rated)  Rate this |  Briefcase | 1,081 reads

SSIS 101: Object Variables, ResultSets, and Foreach Loop Containers

SQL Server MVP and SSIS guru, Andy Leonard, discusses Integration Services and some of the tasks and containers that he uses quite often.  Read more...
By Andy Leonard 2010/02/05 (first published: 2008/08/21) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |  Briefcase | 42,922 reads

Laying out SQL Code

It is important to ensure that SQL code is laid out the best way for the team that has to use and maintain it. Before you work out how to enforce a standard, one has to work out what that standard should be for the application. So do you dive into detail or create an overall logic to the way it is done?  Read more...
By Additional Articles 2010/02/05 | Source: SimpleTalk | Category: code formatting
Rating:  Rate this |  Briefcase | 4,033 reads

Don Syme: Geek of the Week

It came as a surprise to many of us when Microsoft pulled from it's hat a rabbit in the form of an exciting, radical, language that offers an effective alternative to the Object-oriented orthodoxy. The creative force behind this language, F#, turns out to be a brilliant Cambridge-based Australian called Don Syme, already well known for his work on generics in .NET. F# has taken the specialised power of ML and OCaml and developed a versatile general-purpose .NET language. We sent Richard Morris across the road to investigate.   Read more...
By Additional Articles 2010/02/05 | Source: SimpleTalk | Category: interviews
Rating:  Rate this |  Briefcase | 1,744 reads
 



From the SQLServerCentral Blogs

Sending SSIS Errors to the Windows Event Log

 In a previous post I explained how to trap for errors in your Script Task and Components and send the information to the SSIS...  Read more...
By Josef Richberg 2010/02/09 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |  Briefcase | 431 reads
Question of the Day

Transaction Log Backups

By Paul Randal 2010/02/09 | Category: backup and recovery
Rating: (not yet rated) |  Discuss |  Briefcase | 1,367 reads
How much transaction log will a full database backup include, regardless of recovery model?
  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
gkprasad
1079 2702 SSCrazy  
2.
CirqueDeSQLeil
839 4669 SSCarpal Tunnel  
3.
Road Kill
811 1267 Ten Centuries  
4.
GilaMonster
728 16389 SSChampion  
5.
Rufio
576 2280 SSCrazy  
Latest forum posts