SQL Server 2008 and 2008 R2 Integration Services - Consuming Web Services Using Script Task

The omnipresent nature of Web-based technologies expanded the concept of distributed environments with the ability to utilize services hosted on remote servers accessible via standard Internet protocols. This capability can be easily leveraged in SQL Server 2008 R2 Integration Services by employing Web Services Task, whose characteristics have already been covered in detail on this forum. However, in some cases, it might be required to reference Web Services directly from within a Script Task code. We will describe how such a need can be accommodated in this article.


http://www.databasejournal.com/features/mssql/sql-server-2008-web-services-script-task.html

Map IP Address to a Geographical Location

On the Internet there is the concept of web site analytics that helps track all the visitors' activities and usage patterns. One of the dimensions to track is the geographical information of the visitors, which can be obtained by using the IP address information that is collected when a user lands on a Website. In this article, I will describe a simple process that enables your reporting system to display the geographical information of the visitors.

Using SSIS to zip files and email the zipped files

This article makes use of global variables throughout and shows how they can be used in SSIS, you can adapt these to make a package that can be made as flexible as you want. The package described here zips all files in a folder to a single archive zip file.

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64028/

Map IP Address to a Geographical Location

On the Internet there is the concept of web site analytics that helps track all the visitors' activities and usage patterns. One of the dimensions to track is the geographical information of the visitors, which can be obtained by using the IP address information that is collected when a user lands on a Website. In this article, I will describe a simple process that enables your reporting system to display the geographical information of the visitors.

Automating Performance Monitor Statistics Collection for SQL Server and Windows

Problem
You have about 100 SQL Servers installed in your production environment. You have performance problems on few of the servers, but they happen during the time when you are not watching the servers. So, how can you automate performance statistics collection on all the servers around the clock so we have the statistics for 24/7/365.

Solution
You can use the built-in windows utility "logman" that comes free.

Logman is the command line utility for Perfmon. Thru logman, it is easy to automate perfmon data collection which I will show you below.

Auto generate change scripts in SQL Server Management Studio (SSMS) for tables

As a part of my best practices, I always save the T-SQL scripts used for creation and modification of objects in SQL Server. When creating and modifying tables using SQL Server Management Studio designer it is easy to right click in the designer and select "Generate Change Script...", but is there a way to automatically script the creation and/or modification of tables made through of SQL Server Management Studio (SSMS) designer?  This tip shows you an option that exists within SSMS to automatically generate these scripts for all table changes when using the table designer.

Collecting performance counters and using SQL Server to analyze the data

The following will explain how to select counters, how to collect data, how to load the data to SQL Server and how to query the data that has been saved.

Effective PowerShell: The Free eBook

PowerShell MVP and prodigious PowerShell blogger Keith Hill has converted his very popular Effective PowerShell blog series into a FREE Ebook.  You can download it HERE.

Here is a taste of you'll you'll get:

Table of Contents

Introduction 1 

Item 1: Four Cmdlets that are the Keys to Discovery within PowerShell 1 

Key #1: Get-Command 1 

Key #2: Get-Help 2 

Key #3: Get-Member ..5 

Key #4: Get-PSDrive .6 

PowerShell 2.0 Update 7 

Item 2: Understanding Output 8 

Output is Always a .NET Object 8 

Function Output Consists of Everything That Isn't Captured 9 

Other Types of Output That Can't Be Captured .. 11 

Item 3: Know What Objects Are Flowing Down the Pipeline  12 

Item 4: Output Cardinality - Scalars, Collections and Empty Sets - Oh My! .. 15 

Working with Scalars  15 

Working with Collections .. 16 

Working with Empty Sets .. 17 

Item 5: Use the Objects, Luke. Use the Objects!  19 

Item 6: Know Your Output Formatters . 22 

Item 7: Understanding PowerShell Parsing Modes  31 

Item 8: Understanding ByPropertyName Pipeline Bound Parameters  35 

Item 9: Understanding ByValue Pipeline Bound Parameters  38 

Item 10: Regular Expressions - One of the Power Tools in PowerShell .. 42 

PowerShell 2.0 Update  43 

Item 11: Comparing Arrays  43 

Item 12: Use Set-PSDebug -Strict In Your Scripts - Religiously . 45 

PowerShell 2.0 Update  47 

Item 13: Commenting Out Lines in a Script File .. 47 

PowerShell 2.0 Update  48