Blogs

Browse by Tags

• Certification
• DM Views
• SQL 2000
• SQL RS

• 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

• 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

• 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

• 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

• Second Shot Exams...

  Two chances for the price of one to gain the adoration of millions... Also, if you've been keeping up with the SQL Server 2008 release, the MCITP level exams are available for beta testing. SQL Server 2008 Beta Exam: 71-452: Designing a Business Intelligence Read More... Posted Sunday, August 10, 2008 11:30 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008

• Index Size and Usage

  Thought I'd share something I threw together for a client today. They were looking for index a list of indexes in a database with their associated sizes and usage. SELECT object_name ( i . object_id ) as table_name , COALESCE ( i . name , space ( 0 )) Read More... Posted Thursday, July 10, 2008 3:02 PM by Jason | 1 Comments Filed under: DM Views, SQL 2005, SQL 2008

• Last Time SQL Server Restarted

  Not a really hard thing to figure out, but for some crazy reason I always forget. So, hopefully actually writing it out for the world to see will help me remember. Since tempdb is created every time that SQL Server restarts, the created date for that Read More... Posted Tuesday, July 01, 2008 11:25 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008

• 24 Hours of SQL Server 2008

  If you haven't been keeping up with the changes for SQL Server 2008, there is a great series that is worth checking out. The 24 Hours of SQL Server 2008 webcasts. I've been watching these as they come out and I definitely have to disagree with a lot of Read More... Posted Friday, June 06, 2008 11:05 AM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008

• The 2008 PASS Community Summit

  PASS announced next year's summit the other day. Be like me and start thinking ahead for next year's summit since it should be interesting with it being shortly after the launch of SQL Server 2008. The 2008 PASS Community Summit will be held: November Read More... Posted Thursday, October 11, 2007 1:53 PM by Jason | 0 Comments Filed under: SQL 2005, SQL 2008