SQLTutorials           P1Station
Powered By PhICK1.com            http://sqltutorials.blogspot.com/
Sending scheduled SQL query results via HTML e-mail using SSIS
Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.

Introduction to SQL Server Statistics
A free virtual chapter presentation by Andy Warren on Sept 7, 2010 at 12:00EDT. This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more!

SQLBits - The 7 Wonders of SQL
Last day for early bird registration for the next SQLBits conference on Sept 30th-Oct 2, 2010 at York University. SQLServerCentral has a discount code if you'd like to attend.

Automatic Restart of SSIS packages after Failover or Failure
SSIS makes it possible to minimize work lost by starting after the last successfully executed control flow task upon restarting a failed package. From there, one challenge many seek to overcome is automatically restarting that package at that point without any manual intervention. This would make it possible for your SSIS packages to be running, your cluster to failover, and your SSIS packages to restart and complete without you having to respond to the failover and restart them.

SQL Saturday #50 - East Iowa
Come to a SQL Saturday in Iowa City on Sept 18, 2010 and get a free day of training from the SQL community.

Restricting SecurityAdmin on SQL Server 2005/2008
Members of the securityadmin role can escalate to sysadmin rights. Here's how to restrict them back to 2000 levels.

DMVs for Query Plan Metadata
Before you can tackle any performance issues with a working database, you need to know which queries to work on first: The ones that are taking the most time in total, and which are the most expensive in terms of cache, CPU and disk. Although SQL Server Management Studio can help, it isn't long before you need an armoury of DMVs to provide you the statistics to find the culprits.
SQL Response Too many SQL Servers to keep up with?
Download a free trial of SQL Response to monitor your
SQL Servers in just one intuitive interface."The monitoring
in SQL Response is excellent." Mike Towery.


SQL Saturday #46 - Raleigh
A free one day training event in Raleigh, NC. Come to the first SQL Saturday in this city on Sept 18, 2010

Parsing an ADO result set into a comma separated string in SSIS
This article describes a way to parse a result set in SSIS using For each loop container, variables and SQL task.

Raw Materials - Refugees
Why are they here? Why is anyone?

SQL Saturday #52 - Colorado
A free one day training event in the Denver Tech Center on Sept 25, 2010. Come learn about SQL Server and how to further your career at this one day event.

What Every DBA Ought to Know About SQL Server Cursors (and Their Alternatives)
Cursors provide a means of processing through a set of records row-by-row. However, many companies have a policy against using cursors in their SQL Server standards. This article examines the problem with cursors and alternatives to using them.

Conditional WHERE Clauses and Boolean Algebra
Utilize simple boolean algebra and nullable parameters to implement conditional WHERE clauses without dynamic SQL.

From Zero to SSIS! Learning SQL Server Integration Services
Learn SSIS from MVP Andy Leonard in Waltham, MA on Oct 6-8, 2010. More details inside.

Streaming Profiler Data Through StreamInsight
Using the Trace Management objects API it is possible to capture the events happening on SQL Server or indeed Analysis Services. I got to thinking that this would be a good thing to stream out in real time in StreamInsight and do some analysis “In Flight”. So here is a short video of me doing just that.

Why is data integrity important?
Why should I care and why should the database enforce it? This article from Jamin VanderBerg gives some reasons why the database is the place to enforce rules that ensure integrity.

Writing an SSBS App When the Initiator and Target are on the Same Database
SQL Server Service Broker (SSBS), introduced with SQL Server 2005 and enhanced in SQL Server 2008, allows you to write queuing/message based applications within the database itself. This article discusses creating an application in which Initiator and Target both are in the same database.

Memory
Not a sound from the pavement. Have you ever come across a SQL query that used to run faster?  Has that...

DBA Morning Check List
This article helps the DBA find and fix issues quickly by creating a DBA Morning Checklist.

SQL Source Control - Q & A
After a webinar for SQL Source Control, there were a large number of questions left unanswered. All have been listed here, along with answers from the Red Gate development team.
DMV Booklet Free SQL Server monitoring resources
Get the SQL Server DMV Starter Pack,
including a booklet and 30 sample queries,
and download a trial of SQL Response to monitor
your SQL Servers and be alerted to problems.
Download your free resources.


SQL Schema Comparison with Visual Studio 2010
we normally do development on the development box; then during the build preparation we compare the development database with the QA/UAT/Production database to identify differences and generate schema objects for synchronization or incremental deployment scripts. How we can compare schema objects between databases and generate synchronization or incremental deployment scripts?

Defensive Db Programming Chapter 05
We are here again with after another week and ready for another episode in this series.  Today we get to...
SQL Response Too many SQL Servers to keep up with?
Download a free trial of SQL Response to monitor your
SQL Servers in just one intuitive interface."The monitoring
in SQL Response is excellent." Mike Towery.


SSRS In a Flash - The Basics
In this part of our series on Reporting Services (SSRS), Jessica Moss examines the basics of the Report Builder and BIDS.
SQL Backup Free trial of SQL Backup™
“SQL Backup was able to cut down my backup time
significantly AND achieved a 90% compression at
the same time!” Joe Cheng. Download a free trial now.


A deadlock was detected while trying to lock variables in SSIS
Error: 0xC001405C at SQL Log Status: A deadlock was detected while trying to lock variables "User::RowCount" for read/write access. A lock cannot be acquired after 16 attempts. The locks timed out. Have you ever considered variable locking when building your SSIS packages? I expect many people haven’t just because most of the time you never see an error like the one above. I’ll try and explain a few key concepts about variable locking and hopefully you never will see that error

SSIS: Conditional File Processing in a ForEach Loop
I’ve fielded a number of requests recently asking how to interrogate a file within SSIS and change the processing rules...

Mutexes in SQL
This article shows you how to manage process control among multiple servers using a lightweight database utility

Stairway to Database Design - STEP 5: Procedures
Joe Celko tackles the subject of the Stored Procedure and its place in database design. What he writes is food for thought, even for experienced database developers

Security Auditing Matching Up Logins And Users
I have been tasked with auditing security on my SQL Server. However, this needs to be a somewhat automated process as I don't want to have to rely on taking screenshots every month to satisfy our auditors. What tables and/or views should I be using and what's the best way to extract the information out of them?

The Semantics of NULL in SQL Server 2008
Learn the basics of NULL, what it is, and how to query for it in your databases from Adolfo Socorro. What NULL means, how to account for it, and how are expressions involving NULL evaluated
SQL Response Too many SQL Servers to keep up with?
Download a free trial of SQL Response to monitor your
SQL Servers in just one intuitive interface."The monitoring
in SQL Response is excellent." Mike Towery.


Tracy Hamlin, Exceptional DBA of 2010, on what it means to go the extra mile
An interview with the Exceptional DBA of 2010, Tracy Hamlin.

Visual Studio LightSwitch Tutorial
Detailed walkthrough on creating a simple application using Visual Studio LightSwitch. [Read Full Article]


Manage Database Projects With Visual Studio 2010
This article demonstrates how to manage database projects with Visual Studio 2010. [Read Full Article]


Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 - Part 3

Software Usage Tracker

New to MAP 5.0 is another feature called the Software Usage Tracker. This is an audit mechanism that allows you to track the number of users or devices accessing your servers. ... [Read Full Article]



IIS Application Pools for ASP.NET Apps
This article demonstrates how to manage and optimize IIS pools for running ASP.NET apps. [Read Full Article]


Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 - Part 2
Using MAP to inventory your servers

When you start MAP, the application prompts you for a database name (see figure below). At the very beginning there will be no database to hold MAP inventory information, ... [Read Full Article]



Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 - Part 1

Auditing and inventorying is not something new in any IT environment. Depending on the purpose, it can take many forms. Sometimes the auditing is about security and data access. Sometimes it is about software usage ... [Read Full Article]



WCF Tutorial