Microsoft SQL Server 2008 { JumpStart }… your data, any time, any place

Microsoft SQL Server 2008 { JumpStart } @ http://sqlserver2008jumpstart.microsofttraining.com 


This site contains presentations, recordings, hands-on labs and demonstrations for the SQL Server 2008 JumpStart technical training event, while there are 5 tracks in this event: <!–
Overview Sessions,
Database Infrastructure and Scalability,
Business Intelligence Part I & II,
Developer & Software + Services,
and
Application Compatibility & Upgrade.
–>
Overview Sessions, Database Infrastructure and Scalability, Business Intelligence Part I & II, Developer & Software + Services, and Application Compatibility & Upgrade

Lateral SQL injection in Oracle

David Litchfield has just released a paper, showing that it is possible to do SQL injection using DATE or even NUMBER data types to exploit a PL/SQL procedure in Oracle RDBMS! The attacker can exploit a PL/SQL procedure that doesn’t even take user input!


The trick is to apply an ”ALTER SESSION SET NLS_DATE_FORMAT” command in order to change the NLS variable such that the PL/SQL compiler will accept an arbitrary SQL as a ”DATE” (even though it is not).


=== For more information ===


~ Lateral SQL Injection: A New Class of Vulnerability in Oracle


http://www.databasesecurity.com/dbsec/lateral-sql-injection.pdf

Microsoft Office Live Workspace

Microsoft Office Live Workspace offers storage space for sharing documents online, such that you can access them directly using Microsoft Office Word, Excel, or PowerPoint.


There are dozens of ways to use Microsoft Office Live Workspace for work, school, and home projects! The documents can be saved and accessed from any computer. Feedbacks and/or comments can be gathered within a project. Meeting agenda, minutes, and action items can also be shared with colleagues, classmates, or family. You can even save documents to your workspace directly from Word on your PC.


=== For more information ===


~ Video – Office Live Workspace


[ http://www.microsoft.com/winme/0710/31052/current.htm ]


~ Office Live Workspace

 [ http://workspace.officelive.com ]

Writing the first SQL Server database .NET application

Just listing a few getting-started links for developing SQL Server .NET application.

~ SQL Server 2005 Express Edition – Sample Rich Client and Web Applications
http://msdn2.microsoft.com/en-us/express/bb403187.aspx

~ SQL Server 2005 Express Edition – Samples and Starter Kits
http://msdn2.microsoft.com/en-us/express/aa718396.aspx

~ “How Do I” Videos – ASP.NET
http://msdn2.microsoft.com/en-us/asp.net/bb498194.aspx

~ “How Do I” Videos – Visual Basic
http://msdn2.microsoft.com/en-us/vbasic/bb466226.aspx

~ Hitchhiker’s Guide to Visual Studio and SQL Server: Best Practice Architectures and Examples (7th Edition)
http://www.amazon.com/Hitchhikers-Guide-Visual-Studio-Server/dp/0321243625
http://www.betav.com

~ LearnVisualStudio.NET
http://www.learnvisualstudio.net

~ Free basic training for SQL Server
http://blogs.msdn.com/buckwoody/archive/2008/07/17/free-basic-training-for-sql-server.aspx

Installing Components… Full Installation of Visual Studio 2008 Professional Edition

Just got the *full* installation of Visual Studio 2008 Professional Edition done on an Vista Ultimate box (x64), and, here is the …long… list of components that are installed!


– Runtime Pre-requisites
– Microsoft .NET Framework v3.5 (x64)
– Microsoft Visual Studio 2008 64bit Prerequisites (x64)
– Microsoft Document Explorer 2008
– Microsoft Visual Studio Web Authoring Component
– Microsoft Visual Studio 2008
– Microsoft .NET Compact Framework 2.0 SP2
– Microsoft .NET Compact Framework 3.5
– Microsoft Visual Studio Tools for the Microsoft Office system (version 3.0 Runtime)
– Microsoft Visual Studio 2005 Tools for the 2007 Microsoft Office System Runtime
– Microsoft SQL Server Compact 3.5
– Microsoft SQL Server Compact 3.5 Design Tools
– Microsoft SQL Server Compact 3.5 For Devices
– Windows Mobile 5.0 SDK R2 for Pocket PC
– Windows Mobile 5.0 SDK R2 for Smartphone
– Microsoft Device Emulator version 3.0 (x64)
– Microsoft SQL Server 2005 Express Edition
– Microsoft Visual Studio 2008 Remote Debugger (x64)
– Crystal Reports Basic for Visual Studio 2008
– Crystal Reports Basic 64-Bit Runtime for Visual Studio 2008
– Microsoft Windows SDK for Visual Studio 2008 Tools (x64)
– Microsoft Windows SDK for Visual Studio 2008 Headers and Libraries (x64)
– Microsoft Windows SDK for Visual Studio 2008 Win32 Tools (x64)
– Microsoft Windows SDK for Visual Studio 2008 .NET Framework Tools (x64)
– Microsoft Windows SDK for Visual Studio 2008 SDK Reference Assemblies and IntelliSense (x64)
– Microsoft SQL Publishing Wizard

.NET Framework 3.5 full package

Have just got the link to download the full package of .NET Framework 3.5. This is a 197 MB standalone executable file that contains all the components that are required to deploy to 32-bit and 64-bit platforms on all supporting operating systems. (The .NET Framework 3.5 supports IA64 only on Microsoft Windows Server 2008.) This executable does not contain language packs. The .NET Framework version 3.5 language packs are available as separate per-language stand-alone executable files.

.NET Framework 3.5 builds incrementally on the new features added in .NET Framework 3.0. For example, feature sets in Windows Workflow Foundation (WF), Windows Communication Foundation (WCF), Windows Presentation Foundation (WPF) and Windows CardSpace. In addition, .NET Framework 3.5 contains a number of new features in several technology areas which have been added as new assemblies to avoid breaking changes.
They include the following:

~ Deep integration of Language Integrated Query (LINQ) and data awareness. This new feature will let you write code written in LINQ-enabled languages to filter, enumerate, and create projections of several types of SQL data, collections, XML, and DataSets by using the same syntax.

~ ASP.NET AJAX lets you create more efficient, more interactive, and highly-personalized Web experiences that work across all the most popular browsers.

~ New Web protocol support for building WCF services including AJAX, JSON, REST, POX, RSS, ATOM, and several new WS-* standards.

~ Full tooling support in Visual Studio 2008 for WF, WCF, and WPF, including the new workflow-enabled services technology.

~ New classes in .NET Framework 3.5 base class library (BCL) that address many common customer requests.

 

===== For more information =====

~ .NET Framework 3.5 full package
http://download.microsoft.com/download/6/0/f/60fc5854-3cb8-4892-b6db-bd4f42510f28/dotnetfx35.exe

~ Microsoft .NET Framework 3.5 readme
http://download.microsoft.com/download/9/a/e/9ae0f6cc-7032-408e-9ca7-989f9e4af4ec/dotNetReadMe.htm

 

===== Other posts that points here =====

~ Microsoft .NET Framework 3.0: Pacote de Idiomas x86 (KB928416) (Resolvido)

http://www.guiadohardware.net/comunidade/microsoft-net/907431/

VSTS 2005 – using TFS SDK to write code on my x64 box

I was trying to follow a source sample to obtain the VSTS project list, but got the following System.BadImageFormatException on the library file [ Microsoft.TeamFoundation.Client.dll ].


===== Exception =====


System.BadImageFormatException was unhandled
  Message=”Could not load file or assembly ‘Microsoft.TeamFoundation.Client, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ or one of its dependencies. An attempt was made to load a program with an incorrect format.”
  StackTrace:
       at TfsApplication1.Program.Main(String[] args)
       at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
       at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Threading.ThreadHelper.ThreadStart()


===== More findings ===== 


It appears that the library cannot be used on my x64 box, and the workaround is to change the target platform of my project to [ x86 platform ].


–> Right-click on the project


  –> Properties


    –> Build


      –> Platform target: x86


===== For more information =====


~ MSDN: How to: use the TFS SDK to write code


http://msdn2.microsoft.com/en-us/library/bb286958(VS.80).aspx


~ MSDN forum: BadImageFormatException on Microsoft.TeamFoundation.Client.dll


http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=760600&SiteID=1