Siccolo's profileSiccolo - Free Managemen...BlogLists Tools Help

Siccolo - Free Management Tool For SQL Server! for Mobile Devices

Siccolo - Free Management Tool For SQL Server! + Development Articles on .NET, SQL Server, MS CRM Customization!

sql number format and sql format number

Creating user defined number format function to
dbo.format_number (1234), dbo.format_number (-1234.05), results are: 1,234 and -1,234.

sql currency format and sql format currency

Creating user defined currency format function to
select dbo.format_currency (1234), dbo.format_currency (-1234.05), results are: 1,234.00 and -1,234.05.

How to open Dataset from a Text File and display Text File in GridView or in ListView

New article at Siccolo .NET Development Articles - Open Dataset from Text File - Load ListView and GridView in .NET from TextFile - using OleDB namespace and OleDbConnection, OleDbCommand, OleDbAdapter, DataSet, DataRow, DataColumn objects...
November 08

... more on using WMI - Windows Management Instrumentation

See how to build Network Browser by Using WMI to retrieve Domain Information, Enumerate Computers on Network with WMI - .NET allows to retrieve almost any information about local network by using WMI - Windows Management Instrumentation - service with ManagementObjectSearcher class and in conjunction with Active Directory Service Interfaces (ADSI) - Active Directory hierarchy. and also - How to check for Shared Open Files with WMI and Win32_ConnectionShare

WMI (Windows Management Instrumentation) is a component of the Microsoft operating system that allows to monitor virtually every piece of the system (either locally or remotely) as well as control the windows operating system. Windows Management Instrumentation (WMI) is the infrastructure for management data and operations on Windows-based operating systems and can be used in all Windows-based applications, and is most useful in enterprise applications and administrative scripts. WMI consists of several pieces that allow it to manage systems. All parts of the operating system are managed through COM by a provider that talks to WMI. WMI also has a repository and a Windows Management service that manages reading and writing information between the provider and the repository.

... and more .NET and SQL development articles on Siccolo - How to Articles on .NET, VB.NET, C#, SQL development you may find useful

using SQL OLE Automation

Siccolo articles and samples on how to use SQL OLE Automation methods to work with MS Excel and MS Word at:
How to print a document from SQL stored procedure
How to convert Excel file into Table using OLE Automation more articles at Siccolo Articles
September 06

Siccolo - SQL Server management tool w/ administration capabilities and ...


Siccolo helps MS SQL Server professionals save time and increase their productivity by utilizing a more efficient approach to database management - use their Windows Mobile empowered device while sipping margarita on the beach.

read more

.... more on MS CRM customization - Adding Custom Report to CRM

New article on how to add your own custom report to CRM reports - using grid_data_reports.aspx - see How to customize MS CRM at Siccolo articles

more articles at Siccolo Articles

Microsoft CRM Customization - Import Leads records from Excel into CRM via Email


New article on how to setup a process to allow users to upload Leads records from Excel file into CRM database - see How to customize MS CRM at Siccolo articles

more articles at Siccolo Articles

Siccolo mobile management tool - Free Management Tool For SQL Server(s!)

Engineered to help you extend your support from mobile devices for Microsoft SQL Servers, Siccolo - free mobile management tool for SQL Server - is a portable administration tool for Microsoft SQL Server.

It enables database administrators to manage their SQL Server environments using a Windows Mobile device such as a cell phone or PDA.

Easy to install and use, Siccolo mobile management tool helps database administrators to assure the availability of their SQL Servers 24 X 7 no matter where they are.

Siccolo mobile management tool for Microsoft SQL Server allows database administrators to "stay in touch" with their SQL Servers no matter where they are - right from the palm of the hand.

Siccolo mobile management tool helps database administrators be more productive by giving them information on what is going on at all times.

Siccolo mobile management tool is able to provide database administrators with flexibility, convenience, and the ability to act quickly to ensure that SQL Servers perform without problems. And Best of all it's Free!
 

Siccolo

Occupation
Interests
Got SQL Server? Manage it with Siccolo!
Siccolo .NET, SQL, MS CRM Development Articles