Archive | January, 2008

PTI Learning Series 1: Post-Morten

As promised, here are the slides from my presentation. Thanks to all whom attended the event and hopefully you will join us for the next one. Feel free to contact me with further questions by using the contact tab and keep looking on http://events.perptech.com for further event information. DBA Toolkit:SSIS Presentation Cheers, AJ Powered by […]

Read more

SSIS: Setting up an XML Configuration File

SSIS provides several methods to create configuration information for your ETL process. The easiest of these to implement is the XML configuration file. Additionally, it provides the easiest method to migrate and update your configuration information of the method available. I will go step by step on how you can implement this in your application. […]

Read more

SQL Server 2008 Sneak Peak

Looks like Perpetual Technologies may be having me put on yet another event! This one looks like it will entail a SQL Server 2008 Sneak Peak. So keep tuned to my blog and also check out events.perptech.com for registration details here in the near future but for now it looks like the date will be […]

Read more

Recursive Queries using Common Table Expressions (CTE)

SQL Server 2005 uses a new T-SQL Entity called a  Common Table Expression(CTE), which can be thought of a resultant dataset that can be used within a query(SELECT,INSERT,UPDATE,DELETE or even a View). In many respects a CTE is similar to a derived table variable because it lingers around only for the duration of the statement. […]

Read more

New SQLCLRPROJECT Released!

For everyone that may have attended yesterday’s presentation at CincySQL..I mentioned that I liked using the SQLCLRProject for creating and deploying my user-defined functions. Well. sorry for missing this one but it appears that on the 14th Neil has released a newer version of the project in which he addressed some ‘undocumented features’. So head […]

Read more

CincySQL Presentation

Here is a ZIP file that contains the presentation files for my presentation to the CincySQL group in Jan of 2008, Enjoy! CincySQL.zip Cheers, AJ

Read more

SQL Server All Up Rundown…

Here is an okay preview of some of the features they are touting for SQL Server 2008. It mirrors a lot of the Microsoft stuff we have been receiving at the office here lately. Additionally, I may be planning a SQL Server 2008 sneak peek event for here in Indianapolis to happen possibly the first […]

Read more

Scripting User Permissions in SQL Server 2005

This is a pretty handy script for scripting out user permissions in SQL Server 2005. With a few modifications I was able to transform it to basically run through the databases on an instance and create a bunch of scripts for me. Grats to Narayna on this one. Narayna’s Article Cheers,AJ Powered by ScribeFire.

Read more

Perpetual Learning Series Seminars #1

I will be speaking at a set of free learning event seminars put on by my parent company Perpetual Technologies. The events will be going on for the next couple of months and are geared towards DBAs and developers alike….so sign up at at events.perptech.com.Here is what the first in the series of events will […]

Read more

Speaking at CincySQL PASS Group

I will be speaking at CincyPASS on Jan 22nd, 2008. Here is a rundown of what to expect and be sure to check out their website at the link above. CincySQL Meeting Time: 6 – 8 PM Meeting Location:  MaxTrain 4900 Parkway Dr Suite 160 Mason OH 45040-8429 Meeting Date: January 22nd, 2008 Topic: DBA […]

Read more