|
|
-
Jeff Wharton Posted 4 Months ago through Blogs | 10 Points
The Microsoft Virtual Academy has just released a free course covering SQL Server Essentials for Oracle DBA’s. This is a Level 200 course containing 15 modules (each consisting of a video presentation, demos and a slide-deck) and while it’s intended to...
|
|
|
-
Jeff Wharton Posted 6 Months ago through Blogs | 10 Points
Though I’d share details of another SQL Server Data Tools (SSDT) bug to hopefully save others the time I wasted trying to figure out what was going on. Details SSDT Version: November 2012 Update Setting the Sensitive flag of package parameters to Tru...
|
|
|
-
Jeff Wharton Posted 6 Months ago through Blogs | 10 Points
After installing SQL Server 2012 Service Pack 1 you will discover that SQL Server Database Projects can no longer be opened (or created) using SQL Server Data Tools (SSDT). The error presented when trying to open existing projects is: Unable to o...
|
-
Jeff Wharton Posted 8 Months ago through Blogs | 10 Points
Derrick VanArnam (MSFT) has put together a great blog post on consuming an OData feed based on the AdventureWorks 2012 database. The AdventureWorks OData service exposes resources based on specific SQL views. The SQL views are a limited subset of the A...
|
-
Jeff Wharton Posted 9 Months ago through Blogs | 10 Points
Second Shot is available for single exams and featured certification packs until May 31, 2013 For more info and to get your voucher, visit http://aka.ms/secondshot . Spread the word on Twitter with hashtag #SecondShot. ...
|
-
Jeff Wharton Posted 11 Months ago through Blogs | 10 Points
The following SQL Server 2012 upgrade exams are now available:
Exam 70-457: Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1
Exam 70-458: Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2
Exam 70-459: Trans...
|
|
|
-
Jeff Wharton Commented 12 Months ago through Blogs | 1 Point
The main issue with CHAR vs VARCHAR is not comparisons, it's wasted space and performance.
http://www.sqlskills.com/BLOGS/PAUL/post/How-can-data-type-choice-affect-performance.aspx...
|