SQL Server Central newsletters for April 2008

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQL Server Central is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

Home Articles Editorials Forums Scripts Blogs QotD SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Newsletter Archive: April 2008

Find month: Show current month

Mon	Tue	Wed	Thu	Fri	Sat	Sun
	1st SQL Server Central Newsletter SQLskills.com Announces Time-Setback Technology for DBAs Database Wars Coming for the XBOX 360 SQL Sleep The New SQL OS April Bloopers Generating combinations 'm elements from n-element set'	2nd SQL Server Central Newsletter Why Read-only Table Parameters is Not Enough Mine Data from Text Files SQL Server Table Types Nuggets from My SSIS Experience A Scary Comparison Convert binary SID to string	3rd SQL Server Central Newsletter Find blocking processes using recursion in SQL Server 2005 Implementing Error Handling with Stored Procedures Transactions in Transactional Replication SQL Server Index Checklist Try To Be More Inefficient Available bytes for row expansion (adding columns) in a table	4th SQL Server Central Newsletter Tame Your Software Dependencies for More Flexible Apps Gotcha! SQL Aggregate Functions and NULL Automating SQL Server Profiler Handling Data Integrity Issues in Analysis Services 2005 Multiple Personality Show all database's tables' columns' collations.	5th Database Weekly	6th
7th SQL Server Central Newsletter Row Level Versioning The New MVPs TSQL String Array Workbench Building and customizing SQL Server script templates The Cost of Support Compare Different tables from 2 Databases	8th SQL Server Central Newsletter Inside The Question of the Day Virtualization for Database Development How to Share Data Between Stored Procedures Securing Data Table Information View -- No Cursors!	9th SQL Server Central Newsletter Top Queries in SQL Server 2005 XML Workshop XVIII - Generating an RSS 2.0 Feed with TSQL SQL Server Tracing: An Automated and Centralized Solution The Feature Debate Create_sp_help_revlogin_DB	10th SQL Server Central Newsletter Yet another way to include portability on DTS packages Issues with running backup log with no_log or truncate_only Joining to the Next Sequential Row The Social Mesh Comprehensive Backup Script	11th SQL Server Central Newsletter How to Implement an Automatic Sliding Window in a Partitioned Table on SQL Server 2005 SQL Server 2005 Logins Creating a Scorecard in PerformancePoint Server 2007 (PPS) Historical Dollars Find and Replace a String in the Whole Database	12th Database Weekly	13th
14th SQL Server Central Newsletter PASS 2008 - Article Analyze and Correct a large SQL Server MSDB Database DBA Morning Check List Storing Images and BLOB files in SQL Server Part 4 Bloated Clear database - delete all records from a database (updated)	15th SQL Server Central Newsletter Giving Permissions through Stored Procedures Lesson Learned from Contracting, Revisited Designing Tables for Audit Data in SQL Server The Optimists SQL Server 2005 - Backup, Integrity Check and Index Optimization	16th SQL Server Central Newsletter theSystem - Part II myLittleAdmin for MS SQL Server 2005 SQL Server Script to Create Windows Directories Sun Invests, IBM Invests, MS ?? Discover Unique Columns	17th SQL Server Central Newsletter SQL Data Generator Reverse engineering alias data types - Part 5 SQLSaturday - Jacksonville High Availability (DR) Using SQL Server 2005 Transactional Replication Hunting Developers Report SQL SERVER 2005 Permissions	18th SQL Server Central Newsletter Recursive Queries in SQL Server 2005 Integrating Reporting Services into Your Application Set Functions: The StripCalculatedMembers() Functio Up or Down? Removing Duplicate Records	19th Database Weekly	20th
21st SQL Server Central Newsletter Identify SQL Server 2005 Standard Login Settings SQL Server 2005 Express Edition - Part 20 - Authenticating Merge Web Synchronization Error Handling in SSIS The Inmates in Charge Padding function	22nd SQL Server Central Newsletter File Handling A Different Way SQL Server 2005 log shipping setup using the wizard SQLSaturday - Jacksonville SQL String User Function Workbench: part 1 Table Level Access Alter Index with Rebuild	23rd SQL Server Central Newsletter Reading the SQL Server log files using T-SQL SQL Server 2005 Build List Sending scheduled SQL query results via HTML e-mail using SSIS Same Report but Different Methods in SQL Server Reporting Services The April Energy Update Select from stored procedure	24th SQL Server Central Newsletter Tracer Token UPSERT Functionality in SQL Server 2008 Retrieve XML data values with XQuery in SQL Server 2005 The Tax Warehouse SQL version and service pack level	25th SQL Server Central Newsletter Free Encryption International Features in Microsoft SQL Server 2005 TSQL Spam-killer Seeing Double Calendar Display with Language Specific Day/Month names	26th Database Weekly	27th
28th SQL Server Central Newsletter Connection Strategy for Multiple Database Environments How to Handle NULL Values Loaded by SSIS from Excel Files SQL Server 2005 log shipping setup using the wizard Easy or Hard Who did what?	29th SQL Server Central Newsletter Usage of Functions in Stored Procedures Advanced Matrix Reporting Techniques Same Report but Different Methods in SQL Server Reporting Services All Data Readers Are Evil Verify Last successful CHECKDB on all databases	30th SQL Server Central Newsletter SQL Server 2005 Express Edition - Part 21 - Using Replication Management Objects A Function Gotcha with the Use of an Asterisk Custom job categories to organize your SQL Agent jobs Should I Buy a Kindle? Create a Tally or Numbers Table

Previous month