Many times when I'm teaching a class or working with a group, they express frustration at the load time for SSMS or BIDS.

 This is easily optimized by Using the NoSplash Command.

All you need to do is Right Click on the application for either BIDS or SSMS and select… Read more

Hey there Gang !

 Most of you probably know Jamie Thompson has move his blog over to SQLBlog.com. This is worth noting since Jamie is always a great source for SSIS and BI info. I wanted to share a post of his that provides a script method for clearing your… Read more

My presentation and sample files from SQLSaturday in Orlando are now online for you to download. Check them out at SQLSaturday.com. Thank to all who attended and have emailed me questions about tuning your own SSAS environments. Check them out at SQLSAturday.com

  Read more

I can’t wait until Feb 27 when Code Camp is right in my backyard! I just submitted my session for Intro to SQL Server Analysis Services and Hopefully it will get put on the schedule. The guys in SF always put on a great event ! See you there ! Read more

I am not about to get into a theoretical discussion of whether certifications will benefit you in your career. I am a firm believer that this follows the rule of “it depends”. However if you’re a professional in a field, whether plumbing or technology, certification is a good way to… Read more

Everyone likes to get a project done, but many times in our rush to deploy we bypass some of the things that demonstrate the consistency and usability that give our projects the credibility they need. How many times have you used an application that had weird glitches but the functionality… Read more

One of the most underused features in SSMS is the additional templates that are available for MDX, DMX, and XMLA. Many of you probably use the T-SQL templates to quickly build common statements, but struggle with the syntx for their counterparts in these variation languages.

Fear Not !

If you…

Read more

My new blog has been centralized at http://www.bidevelopernetwork.com/blogs/AdamJorgensen/. Check it out for all my new updated content. Read more

One of the most underused features in SSMS is the additional templates that are available for MDX, DMX, and XMLA. Many of you probably use the T-SQL templates to quickly build common statements, but struggle with the syntx for their counterparts in these variation languages.

Fear Not !

If you…

Read more

With the explosion of Netbooks, it has become important to find new ways to load operating systems. I recently picked up a new Netbook and immediately desires to load Windows 7. I LOVE the new OS and am so pleased with it I have been running it since Beta with… Read more

Everyone likes to get a project done, but many times in our rush to deploy we bypass some of the things that demonstrate the consistency and usability that give our projects the credibility they need. How many times have you used an application that had weird glitches but the functionality…

Read more

Looking forward to a great Tamp Code Camp tomorrow. My first code camp. I’ve had some great experiences at the one day conferences, but am really looking forward to my first code camp. The session list looks great! Can’t wait to see everyone there!

Check it out at - www.tampacodecamp.com Read more

Have you ever received the following Error when developing your ETL or working with data cleanup?

 

Msg 544, Level 16, State 1, Line 1

Cannot insert explicit value for identity column in table 'tblDemo' when IDENTITY_INSERT is set to OFF.

 

This is because the table has a…

Read more

Mike Davis, Author and consultant extraordinaire recently posted a great new take on parallel vs. series SSIS packages. Some interesting results and Myths dispelled here :

http://blogs.pragmaticworks.com/mike_davis/2009/11/ssis-parallel-vs-series-data-flows.html

Check it out ! Read more

Have you ever lost your project file for a SQL Server Analysis Services database? There is a great option to create a new project from an existing database either in development or production.

First - Select to Create a New Project in BIDS (Business Intelligence Development Studio) and Choose the…

There are many different ways to manipulate dates when working with them in SSIS. Many great examples have been posted across the web and I use many of them on a regular basis in my coding. It can be difficult however to get a single source for many of these…

One of the most common problems facing a DBA or developer in troubleshooting performance is identifying what processes, and by association, what queries are causing the slowdown or symptoms. The first step used to be run SP_Who or SP_WHO2 and pour through the data. There are also a number of…

It’s very exciting to be involved with the SQL Saturday here in South Florida. There are already so many great sessions on the schedule, and the tracks will be finalized soon. I have submitted two sessions. MDX Fundamentals and Performance Tuning SSAS.  Brian Knight         and Devin Knight are also slated…

Recently I was working with client and they were discussing the pet peeves of some of the new intellisense features in SSMS. Now, Intellisense is a powerful tool to help developers be more efficient, but for professionals who haven’t had it for the last 15 years, it can take some…

I was working with a team of developers this week who were having the hardest time finding the keystroke to close and disconnect a tab in SQL Server Management Studio. It’s very simple so I thought I would post it here. I know many of you use keystrokes when working…