-
Today, I took the beta version of the SQL Server 2008 BI certification test , which is free until 7/31. It was pretty grueling. I don't do well with standardized testing but this one was especially lengthy at 70 questions and up to 3 hours to take...
-
I was recently working with FoxPro for Unix as a data source using ODBC in SSIS (story for another day) and found some interesting scenarios inside of it. We wanted to pull the table name dynamically, thus changing the SELECT statement inside the SSIS...
-
If you're interested in becoming certified in SQL Server and are really, really driven, there's a free test for BI and SQL Server for this month only. You have to register soon to get one of the available open beta slots though. If you do pass...
-
Due to popular demand, many of the webinars have reached the capacity of more than 1500 registered guests. To make sure everyone could participate, we have added an additional hour each day for those who missed the first session. You must register in...
-
I just signed up for a service called Twitter, where you can follow your co-workers through mini-micro posts throughout the day. If you interested in following the truly boring life of Brian, you can go to http://www.twitter.com/brianknight .
-
In this session by SQL Server MVP, Brian Knight, you’ll learn how to make a package that needs zero configuration as you migrate from development to production. He will then show you how to deploy your packages and administer the SSIS service. You’ll...
-
Nothing gives me more pleasure than teaching and getting the "aha" moment out of a student when the student gets over the learning curve of a potentially difficult product. That feeling on a larger scale is what is exciting me most to announce...
-
JSSUG will be meeting next week on Wednesday the 25th at 6PM at the BOA campus. Where : "Driftwood" room (2nd floor) in Building 500, Bank of America, 9000 Southside Blvd: Map and Directions Topic: New Features in SQL Server 2008 - In this session...
-
All of my ideas seem to come to me on drives to clients or work. About 3 years ago, I was driving to work when I had the idea for JumpstartTV.com. The site was going to be a central how-to hub for videos on the web. The old saying is once you come up...
-
As we all know, our friends in Redmond have publicly declared their intention to "own" the BI market. Their latest offering to obtain that ambitious goal is a product called Performance Point Server. Admittedly the name of the product...
-
Reporting Services in 2008 has provided some exciting new enhancements that will really spice up your reports. In this example, we will create a charting report that uses the new charting controls (Dundas charts that MS bought. Sweet!). The cube data...
-
I had been working in SQL Server 2008 for a number of months while working on the upcoming 2008 books and never had experienced this issue until just today. In hindsight, I can't imagine how I didn't experience sooner. The behavior change is when...
-
This Monday (June 9th) I will be speaking at the SQL Server Users Group meeting in Atlanta. The topic will be on SQL Server Reporting Services 2008. I'm excited to introduce the new and exciting features of the latest version of Reporting Services...
-
In SSIS, we recently were engaged by a customer who had a fairly simple request. They wished to remove non-numeric items from a column in the data flow. They were doing this in a stored procedure by using a T-SQL replace function row-by-row and we wanted...
-
If you're going to be in the Orlando area around the TechEd timeframe, I'll be doing speaking at SQL Saturday #4. On Saturday, June 7th, I'll be doing a session on what's new in SQL Server 2008 and on Sunday, I'll be doing a half-day...