In a previous tip, the tip reviewed several steps for a better and improved environment for scheduled jobs. I am totally convinced with the recommendations and want to implement these for my scheduled jobs. To make this easier, I want to create a template so I can produce a suitable and reliable way of updates for my production server. In this tip I provide a step by step exercise to perform on a test server to prepare the customized and tested scripts to run on the production server.

Are You a Ten?

by Steve Jones

SQLServerCentral.com

Editorial

Are you truly an expert in SQL Server? Would you claim to be a 10 on a scale of 1 to 10? Steve Jones notes that the product is so wide and deep that it's unlikely any of us will be an expert in most of SQL Server, and that's OK.

Handy Hardware Assessment Tools For SQL Server

by GlennBerry

SQLServerCentral.com

Blogs

Here is a small selection of useful tools for getting some specific hardware information from any Windows based system you...

Implementing SQL Server Database Mail

by Additional Articles

Database Journal

Database Mail

Have you ever wished your database could tell you what's wrong or let you know when a task has completed? SQL Server's Database Mail allows the database to send out messages over SMTP. Deanna Dicken shows you how to set up Database Mail and send some messages.

Google Scale

by Steve Jones

SQLServerCentral.com

Editorial

Not many of us work at Google scale, where every little thing you do can matter. However Steve Jones thinks that the little things still matter when you are building software.

TSQL Challenge 43 – Identifying incomplete segments and missing elemen

by Jacob Sebastian

SQLServerCentral.com

T-SQL Challenges

This challenge involves writing a logic to identify incomplete segments and missing elements in an electronic data integration file exchanged between two applications.

Capturing and Logging Data Load Errors for an SSIS Package

by Additional Articles

MSSQLTips.com

Integration Services (SSIS)

In an ETL solution, error logging is a fundamental requirement for various aspects of the application and is very useful at various stages of the ETL execution life-cycle. Let's consider a scenario where our requirement is to insert records into a SQL Server table. The package should attempt loading all the records and whichever records fail, error details reported by the database engine should be reported. We will look at how to implement this in a SSIS package.

SQL Saturday #59 - New York City

by Press Release

SQLServerCentral.com

SQL Saturday

A free day of training in New York City just before Thanksgiving. Come see Steve Jones and Grant Fritchey, along with a number of other great speakers.

Learning Sharepoint, SSIS and SSAS

by Steve Jones

SQLServerCentral.com

Training

Steve Jones outlines some ways that you might look to get additional training that can help move your career along.

Proving Your Identity

by Steve Jones

SQLServerCentral.com

Editorial

We have to provide security for our data, and to some extent that means verifying who has access. SQL Server has limited means for doing this other than relying on the OS, but Steve Jones has some ideas on how to make this more secure.

SQL Server Agent Job Management Scripts

Are You a Ten?

Handy Hardware Assessment Tools For SQL Server

Implementing SQL Server Database Mail

Google Scale

TSQL Challenge 43 – Identifying incomplete segments and missing elemen

Capturing and Logging Data Load Errors for an SSIS Package

SQL Saturday #59 - New York City

Learning Sharepoint, SSIS and SSAS

Proving Your Identity

Blogs

T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?

Optimizing Redshift Performance by Configuring WLM Queues

PowerShell Strikes Back: Return of the Loop

Forums

Dealing with huge heap tables

Merge Replication failing with Error converting data type nvarchar to numeric

Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit

Question of the Day

Distance Metric Algorithms