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.
 |
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.
 |
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...
|
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 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.