A introduction to reporting services with a short demo report application.
An introduction to SSIS with a small example project.
Here are the presentation slides and sample website code for my IndyPass presentation tonight. I am presenting a talk on using Server Management Objects (SMO) and Replication Management Objects (RMO). Once you learn how to use these your life as a DBA can become a whole lot easier.
Cheers,
AJ
Here are the slides and some of the demo code I used for my T-SQL Enhancements presentation on the 14th.
T-SQL Enhancements
Cheers,
AJ
Here are the slides from my presentation today for the Eli Lilly Lunch & Learn session. It is an overview of replication titled. Replication Demystified It has a lot of good stuff in it..so ejoy and if you have any questions feel free to ask!
Cheers,
AJ
Here are Server Management Objects(SMO) presentation slides from the February 21st event. Feel free to email me if you find any thing that you have issues with concerning SMO. I will be trying to put up a short series of blogs demonstrating some of the things programmatically you can do using SMO.
Cheers,
AJ
The link for the slides and the handout booklet for the exercises for last week’s SSIS class can be found at the link below.
Cheers,
AJ
This Thursday is PTI’s next Learning Series Event. I will be presenting on DBA Toolkit:SMO. It should be a fun 3 hour run through as I have plenty of demos ready to show how powerful the SMO paradigm is. If you haven’t signed up yet please go to the PTI events page below…
http://events.perptech.com
Cheers,
AJ
Powered by ScribeFire.
Seems like this question ALWAYS comes up in my consulting more often than not. This is a fairly detailed article on the subject of SAN vs. Direct Attached. So get educated so that the next time the hardware monkeys ask you what you need, you are ready to go with an answer….
SAN vs. Direct Attached: Which is Faster?
Cheers,
AJ
Powered by ScribeFire.
Jeesh! Yet another significant delay looks imminent for Microsoft. With most people waiting to see what fixes would come with SP1,like me, in order to gauge whether they wanted to make the switch….I believe that this is a major downer for any hope of moving to Vista before the next release OS comes out in 2010. Check out the post and see what you think…
http://www.vnunet.com/itweek/news/2208796/vista-sp1-windows-server-2008
–Note: Sorry for those that may have hit the incorrect link I had posted previously. The corrected link is posted above. Microsoft has basically said that they are merely tweaking a few drivers that had problems with the install process. My basic premise is that driver problems this late in the game is not a good sign at all………
Cheers,
AJ
Powered by ScribeFire.
You can take a look a this short video from Daniel Moth about the aesthetic and usability enhancements…
What you can basically summarize in the whole 10 minute theme is that basically you will not be able to get anything done without Vista bugging you that you need elevated permissions. Other than that it is some basic Vista-like eye candy which is not very impressive. I will be using Visual Studio 2008 but not on Vista. I fully expect to wait until the next operating system come along. Hopefully, Microsoft will have learned its lesson from the Vista debacle and get things on the right track.
Cheers,
AJ
Powered by ScribeFire.
You can read the depressing news here……
If you read the whoe blog entry it makes it sound like this is a fanatastic thing and I guess you have to put the best spin on things. What depresses me is that I have asked several times at various events about the release date. Especially, sinc eI have yet to see things like database mirroring…but have consistantly been told that this is because of the ‘new’ design methodology…code complete…yadda-yadda-yadda. Basically, that we just need to wait and be patient.
When is Microsoft going to understand the concept of under promise - over deliver?
Cheers,
AJ
Another handy tip for everyone out there deals with handling an Excel file import on a 64bit environment. Now the problem that arises is that there is no 64bit compatible JET provider to use. This causes a slight problem when you are trying to do something like ‘upload an Excel file’ which needs the JET provider to function. However, this does not negate you from running the process in the 32 bit environment (WOW) on your 64 bit machine. It all depends on the scenario. Read the rest of this entry »
At my talk today I ran into a couple of individuals that asked me the same question. “Why can’t I run this package as a scheduled job?”. I run across this many times in my consulting because there is a lot of documentation on deployment out there but none of it really seems to click with people. Read the rest of this entry »
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.
Cheers,
AJ
Powered by ScribeFire.
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 the rest of this entry »
Just a short reminder for myself really. A lot of people tend to use a custom script in order to accomplish this logic simply because the interface for the derived column data object simply does not spell out how to accomplish this. In order to place an IF statement for the derived column you would use something like the following syntax
({Boolean Expression}?{True Part}:{False Part})
So if I were checking against a product_type column to determine whether I should use wholesale_price or retail_price I could simply write up something like the following.
([product_type]==2?[wholesale_price]:[retail_price])
Another benefit to using the derived column data object instead of a custom script task is that the process is so much faster. In my personal experience with large ETL sets of data substituting the derived column for the custom script task cuts my data processing for that event in more than half. So play around with it and see what you can accomplish.
Cheers,
AJ
Powered by ScribeFire.
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 sometime in early May.
Cheers,
AJ
Powered by ScribeFire.
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. What is often unused in these instances,is the ability of the CTE to self-reference and therefore provide a way we can use it to perform recursive queries. Read the rest of this entry »
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 on over to his blog and read about it….I promise you won’t be disappointed.
Cheers,
AJ
Entries (RSS)