Blogs

Browse by Tags

• Certification
• DB Pro
• DM Views
• SQL 2000
• SQL 2005
• SQL RS

• Upgrading to SQL Server 2008

  Check out Jason Massie's top 10 Reasons to Upgrade to SQL Server 2008 . These are probably an instant classic. Read More... Posted Monday, November 17, 2008 1:32 AM by Jason | 0 Comments Filed under: SQL 2008

• Say what?! DB Pro 2008 installation didn't work?

  I'm sitting around tonight trying to reverse engineer a database with Database Professional 2008 and I get this unexpected error. (they're all unexpected, aren't they) --------------------------- Microsoft Visual Studio --------------------------- Could Read More... Posted Wednesday, November 12, 2008 10:40 PM by Jason | 0 Comments Filed under: SQL 2008, DB Pro

• PASS Next Week & Certifications

  Are you going to be at PASS next week? You can follow my comments on twitter @h4ppyd4y . If you are going to be there, are you taking any exams? PASS has a great special and discount for taking the exams. As of today the first 100 for free is still open. Read More... Posted Tuesday, November 11, 2008 10:43 PM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, Certification

• Heading out of Seattle (aka Microsoft SQL Server 2008, Database Development Certification)

  I still have an hour and a half until I catch my flight out of Seattle. Me and the red-eye are sharing a journey tonight because I tend to fail at waking up for anything between 4 and 6 AM and I still want to have a Saturday. I'm just wrapping up my week Read More... Posted Saturday, November 08, 2008 1:20 AM by Jason | 0 Comments Filed under: SQL 2008

• SQL Server Virtual Conference This Week - Nov 5, 6, and 7!

  Online event this upcoming week... SSWUG.org presents the SQL Server Virtual Conference Designed to bring useful technical sessions to your desktop along with the ability to interact with speakers and exhibitors in a lively forum where your questions Read More... Posted Sunday, November 02, 2008 2:15 PM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008

• SQL Server 2008 Community Launch Event Tomorrow (10/24/2008)

  Check out this event from SSWUG: We're working to bring you real-world information about how to get started with SQL Server 2008, tips about new features and functionality and much more. Stephen Wynkoop, Chris Shaw, Jason Strate have joined together to Read More... Posted Thursday, October 23, 2008 3:17 PM by Jason | 0 Comments Filed under: SQL 2008

• Upgrade Issues When 'sa' Renamed

  I've not done recommended changing the sa account name at a client for quite a while. Since the account can be disabled there isn't any good reason to rename it that I've been able to come up with. But if you do and plan to upgrade to SQL Server 2008, Read More... Posted Monday, October 13, 2008 10:30 AM by Jason | 0 Comments Filed under: SQL 2008

• SQL Server 2008 Certifications

  The following SQL Server 2008 exams today: 070-432: Microsoft SQL Server 2008, Installation and Maintenance (MCTS) 070-448: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance (MCTS) Or maybe yesterday. But they are there now Read More... Posted Thursday, October 09, 2008 1:17 PM by Jason | 0 Comments Filed under: SQL 2008

• SQL Server 2008 Books Online Update

  Microsoft has updated SQL Server 2008 Books Online . Keep up to date on the greatest story since SQL Server 2005 Books Online... Read More... Posted Wednesday, October 01, 2008 11:32 AM by Jason | 0 Comments Filed under: SQL 2008

• The SQL Server Experience

  A whole big cut-n-paste: Microsoft Announces SQL Server 2008 Experience Microsoft continues the momentum of SQL Server 2008 with new resources for global customers and partners. Editor’s note: the Web site referenced below will not be live until 8:00 Read More... Posted Monday, September 29, 2008 6:00 AM by Jason | 0 Comments Filed under: SQL 2008

• SQL Server 2008 Cumulative Update 1

  If you hadn't heard the first cumulative update to SQL Server 2008 came out this week. Some of the items that were fixed seem to be a bit annoying: FIX: When you query through a view that uses the ORDER BY clause in SQL Server 2008, the result is still Read More... Posted Friday, September 26, 2008 11:45 AM by Jason | 0 Comments Filed under: SQL 2008

• Remove All Non-Numeric Characters From A String

  I completely lack creativity today but thought this link on removing non-numeric characters was kind of cool. Oh... Also... I am a big fan of Captain Varchar(MAX) and the Pagelatch Posse . The greatest thing about the cartoons is that the more you know Read More... Posted Thursday, September 18, 2008 1:48 PM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008, SQL 2000

• SQL Server 2008 Consolidation\Virtualization.

  Charley Hanania discusses consolidation and virtualization with SQL Server 2008. Read More... Posted Friday, August 22, 2008 1:41 PM by Jason | 0 Comments Filed under: SQL 2008

• Where'd Report Designer Preview go!?

  If you are like me and have been toying around with Report Designer (aka Report Builder 2.0), you may have noticed that it disappeared with RC0 and RTM. Unfortunately, the RC0 version is the only version currently available and even more unfortuantely, Read More... Posted Monday, August 18, 2008 4:57 PM by Jason | 0 Comments Filed under: SQL RS, SQL 2008

• Are You Sure You're Using the Right Query?

  I found a nice little feature in SQL Server Reporting Services (SSRS) today. Through the expression "=dataset!<dataset name>.commandtext" the query executed by the dataset can be returned to the report. There is also a rewrittencommandtext function Read More... Posted Friday, August 15, 2008 3:26 PM by Jason | 0 Comments Filed under: SQL RS, SQL 2005, SQL 2008