| Dandy's profileDANDYMAN's BlogPhotosBlogLists | Help |
|
December 13 Question of studentHow can I view objects that have similar datatypes in SQL 2000
-- OVERVIEW OF TABLES IN SQL 2000 that have similar datatypes select o.name as tablename ,c.name as columnname ,t.name,c.length from syscolumns c join systypes t on t.xtype = c.xtype join sysobjects o on c.id = o.id where o.xtype = 'U' order by t.name,c.length SQL Question of the dayOk ...
We trainers have been challenged at some of the SQL Launch Events.
The question asked by some people, or probably the same person was:
What is the tool displayed on the SQL books as displayed in the picture link below I am offering a free SQL 2005 exam voucher for the person that proofs me the existence and the description of this tool!
November 24 How many use Oracle and want to migrate to SQL Server ..How many of you are thinking of migrating from Oracle to SQL Server and why?
I am interested in finding out why you want to migrate, and when ./ how ... What is your pain in a migration ... and what do you identifies as reasons why not to migrate. All responses are welcome to the blog or via email to dandy@dandyman.net
Time for a SQL freebieThe first one who replies to this blog with 10 good reasons why you should migrate or move to SQL Server 2005 gets an exam voucher for the SQL 70-431 Technology Specialist Exam. And I am serious ..it have to be 10 good reasons, reasons to be happy about SQL Server 2005 and reason to party
November 23 Announcing the new Microsoft Certification trackTogether with the most important release ever [SQL Server 2005, Visual Studio 2005, Biztalk 2006], Microsoft announced a new range of certifications that can be considered as the baseline for future certification on Microsoft technologies.
The certification better matches job definitions and has implemented a CORE level of skills identified in the Microsoft Certified Technology Specialist. This will be the base and core requirement for the Microsoft Certified IT Professional Certification or the Microsoft Certified Professional Developer Certification.
Also ..4 of the SQL Server exams are currently in Beta, and I expect them to become live early 2006.
On the SQL Server Launch Events you can get a free exam voucher, together with a copy of SQL Server 2005 and Visual Studio 2005. To find out more about the new certification have a look at : http://www.microsoft.com/learning/mcp/newgen/
November 15 ITFORUM BarcelonaThis week I will be at Microsoft ITFORUM conference in Barcelona, besides from having some chat an talks with SQL People I will spend most of my time at the Microsoft Learning booth where I am presenting and promoting the Microsoft Certification Track and Learning, mostly focusing on Visual Studio 2005 and SQL Server 2005. Also I will be at the Ask the Expert booth on SQL Server hoping to provide answers to most of your questions.
I am thinking of blogging about the most asked questions
what a trip ...After succesfully delivering the ISV Touchdown Event in Montreal and Vancouver I went to Seattle to catch up with a friend and go for dinner at the Brazilian Barbecue downtown.
We discussed some of the items that I expect to be in a Transact-SQL Course on SQL Server 2005. First of all, I want a course on Transact-SQL that shows me the differences in features between SQL 2000 and SQL 2005.
Why is that? Because there is still going to be a lot of SQL 2000 Servers out there over the next coming years and there are some syntax differences and features I definetely want to point out. November 08 Looking for some challenges on SQLWhen training I really love to challene my students ...
If you have any challenging you want me to resolve in SQL Server 2005, related to T-SQL please let me know ... send me an email dandy@dandyman.net with your question or just post it here in the thread.
Looking forward to some interesting challenges.
Finally blogging againTHis year has been extremely busy so far and yes ...I promised that I was going to keep my blog site updated from now on ..you know how that goes Lately I have been training the world on SQL Server 2005, and I am so happy that the product is finaly released. Shortly I will be presenting SQL Launch Seminars in London, for QA Training, and I will release my own courseware on SQL Server 2005 with them.
Most of the SQL material I will upload in the future can be found on my very own SQL Resource pages that are located on www.dandyman.net/sql Some of the articles I published on SQL Server 2005 lately and my opinion on the product launch can be found at the links below: http://www.microsoft.com/presspass/features/2005/nov05/11-04Learning.mspx
January 27 Happy Birthday SUPERMOM!!!!`Today is my MOMS Birthday ... And I am really gonna miss her being on the Roadshow for 2 months. MAM !!! Gij zijt fantastisch... iets wat een kind niet ziet in zijn moeder heb ik op een bepaalde leeftijd ontdekt .... niemand kan zich een betere moeder voorstellen dan diegene die ik en ons Sally hebben. Dikke knuffel! MOM!!! You are fantastic... a child doesn't see this in his mom, but I discovered it @ a certain age ... no one has a better mom than the one me and Sally have. Big Hug.
January 26 Ready for the RoadshowI am about to get ready for my departure to the US for an extended period of 2 months to deliver the BI Roadshow - http://www.msusapartnerreadiness.com/biworkshop.asp) Of course I will mainly focus on the successful delivery of this Roadshow but I am definitely up for drinks and meet and greets. The only updated and correct schedule for my stay in the US is posted here http://www.dandyman.net/schedule.htm It will show you where I will be teaching but also where I will spend the weekend, and of course St. Patricks day ( although I still wonder where to find good beers in the US) During the Roadshow I will try to keep this blogsite updated. Pictures, travel stories and so on will be posted here too. I hope to see some of you around during my US Experience. The other part of the Roadshow will be covered by Rob Labbe. Hereby I would like to wish Rob the best during the Roadshow, I know being away from home with a little baby won't always be that easy. Also the very best on what he calls the -- indy world ---! I am glad he is taking that step and I am sure he will do fine. You can find his schedule on his blogsite. Also I would like to thank the people from Asentus for the planning and hard work they delivered and the opportunity they give me to be able to deliver this event for them. Special thanks to Melissa there, you are doing a wonderful job. See you all! December 29 Business Intelligence RoadshowGenerally because of my mom's request The Entire list and content and how to subscribe for this event can be found @ http://www.msusapartnerreadiness.com/biworkshop.asp
ISA 2004Yesterday I configured some computers to setup as my testenvironment and provide me global access when I am traveling the US on the Business Intelligence Roadshow and the TPREPS I am organizing. Great news on the TPREPS, also .. they will be sponsored by Microsoft Belgium. (special thanks to Stefan Lamberichts) December 27 HOAX Virus .. the matrixToday I got several customers warning me about a virus : The Matrix pps ...
December 21 Got this blog thing running!Woohoo, I just introduced myself in the world of bloggers. Am I a geek now? 2005 is gonna be a very busy year for me. |
|
|