Friday, February 11, 2011

Calling SQL Server With A BlackBerry Phones

This article provides a simple Web page to play multimedia files on a home computer using a BlackBerry phone. It does this by using SQL Server to store selected binary images (documents, music, videos, etc.) bulk copied to it. Such images may be opened on a smart phone, copied to other SQL Servers, or downloaded to remote machines.


Sunday, February 6, 2011

EMS SQL Management Studio for SQL Server



Compatible with Windows 7EMS SQL Management Studio 2010 for SQL Server is a complete solution for Microsoft SQL Server database administration and development. With components that focus on all critical MS SQL Server database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering SQL Server databases, managing database schema and objects as well as for MSSQL Server database design, migration, extraction, SQL Server query building, data import, export and database comparison. SQL Studio unites these database tools for SQL Server in one powerful and easy-to-use environment that can work round the clock. With SQL Management Studio many database administration objectives, such as migration, data loading and synchronization, database backup and extraction can be automated, allowing SQL Server database administrators and SQL Server application developers to perform complex tasks on a regular basis with the minimum number of efforts and a high level of flexibility. Whether you are a database or application developer, DBA or business analyst, SQL Studio for SQL Server offers all essential SQL Server tools to make you more productive than ever before!

Tuesday, February 1, 2011

Advanced Intellisense for SQL Server developers & DBAs

SQL Complete: smart autocomplete for SQL Server developers & DBAs

dbForge SQL Complete is a useful add-in for SQL Server Management Studio 2000, 2005 and 2008 that offers powerful autocompletion and formatting of T-SQL code.

Besides extending List Members, Complete Word and Parameter Info features, SQL Complete adds SQL Formatter to enrich the developer toolkit and provide the fastest T-SQL query typing ever possible.

Key Features

Context-based code completion
SQL Complete thoroughly defines the context to predict what you want to type next. Smart intellisense prompts only relative keywords and names of database objects. Just type several symbols and see the required word in the suggestion list. It takes only to press Enter and go on with your query.
Parameter Info
When you type names of user-defined and built-in functions and procedures, dbForge SQL Complete will display their parameter information in a hint. Get the necessary information promptly without browsing external documentation.
Customizable SQL formatting
Produce clear and well-formatted code without worrying about all those indents, whitespaces, wrappings, line breaks, etc. Just keep typing your SQL and see it automatically transformed based on your preferences and formatting rules. With a wide selection of formatting options you can set any formatting style you need.