Sign the petition!

Sign the petition!

Sign the petition!

Sign the petition!

Sign the petition!

Sign the petition!

Sign the petition!

Sign the petition!

Sign the petition!

Sign the petition!

http://www.siccolo.com/pad/widget.aspx?m=1

next article in Developing Facebook Application with FBML FBJS FQL and .NET series at CodeProject

see at Developing Facebook Application with .NET - part 2

next article in Developing Facebook Application with FBML FBJS FQL and .NET series

next article in Developing Facebook Application with FBML FBJS FQL and .NET series:


ASP.NET - using FBML Tabs - <fb-tabs/> and <fb:tab-item/> in ASP.NET

ASP.NET - using <fb:request-form/> in ASP.NET

ASP.NET - building Invite page with FBML multi friend selector from ASP.NET

access Facebook Data from ASP.NET (C#) using FQL and DirectFQLQuery()

ASP.NET - update Facebook user profile using SetFBML, <fb:subtitle/>, <fb:wide/> in ASP.NET

ASP.NET - update Facebook user profile using <fb:ref/>, SetRefHandle

ASP.NET - build scheduled updates for Facebook - "cron job" for Facebook using ASP.NET

ASP.NET - populate user profile mini-feed using PublishAction(), Feed.publishActionOfUser using ASP.NET

ASP.NET - handle Application unsintall/remove using Post Remove URL in ASP.NET

Comma delimited files - Load Dataset from CSV File - Reading CSV and Parsing CSV Files

new artcle at Siccolo -


How to open Dataset From Comma delimited (CSV) File - Reading CSV files - Parsing CSV Files

fix for Error: FacebookAPI.CreateSession() -> FacebookAPI.ErrorCheck(): Invalid Parameter

Fix for FacebookAPI.CreateSession() - FacebookAPI.ErrorCheck() - Invalid Parameter problem in Facebook Developer Toolkit -
see it at Siccolo articles

Developing Facebook Application with FBML and .NET article on www.codeproject.com

Siccolo development article on www.codeproject.com - Developing Facebook Application with FBML FBJS and .NET, with C#

Developing Facebook Application with FBML and .NET article on www.lottext.com

Siccolo development article on www.lottext.com - Developing Facebook Application with FBML FBJS and .NET, with C#

Developing Facebook Application with FBML and .NET

Developing Facebook Application with FBML FBJS and .NET -
how to build a sophisticated Facebook application that interacts with Facebook users and with a SQL Server database - see it at Siccolo articles

Develop Custom File Upload article on www.lottext.com

Siccolo development article on www.lottext.com - Develop Custom File Upload with Javascript and Scripting.FileSystemObject

Create Custom File Upload - .NET Software Development - Javascript and Scripting.FileSystemObject

How to create Custom File Upload - .NET Software Development - Javascript and Scripting.FileSystemObject - a new Siccolo development article -
Custom File Upload with Javascript and Scripting.FileSystemObject, Web Service/ASP.NET and C#

address showModalDialog() problem and javascript

new article on Siccolo - address showModalDialog() problem and javascript

Personal Security Certificate PFX article on www.lottext.com

posted article on Windows Mobile - How to Install Personal Security Certificate PFX

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.

Hubba-Hubba

hubbing at Siccolo Hub

How to Install Personal Security Certificate in C# compact framework using PFXIsPFXBlob(), CertAddCertificateContextToStore() functions

Access web service with required personal security certificate - using x509 PFX personal certificate - Install Personal Security Certificate in C# compact framework. :

...
byte[] pfxData = GetFile(certificatePath);
...
CRYPT_DATA_BLOB pPFX = new CRYPT_DATA_BLOB();
pPFX.cbData = pfxData.Length;
pPFX.pbData = Marshal.AllocHGlobal(pfxData.Length);
Marshal.Copy(pfxData, 0, pPFX.pbData, pfxData.Length);
...
hMemStore  = PFXImportCertStore(ref pPFX, password, CRYPT_USER_KEYSET);
...
cert_MY_store = CryptoAPI.CertOpenStore(new IntPtr(CERT_STORE_PROV_SYSTEM_W),
                                                           0, 
                                                            IntPtr.Zero,
                                                            CERT_SYSTEM_STORE_CURRENT_USER, 
                                                            "MY");

...
...
CertAddCertificateContextToStore(cert_MY_store,
                                                               hCertCntxt,
                                                               (int)CERT_STORE_ADD_REPLACE_EXISTING, IntPtr.Zero)

.NET Compact Framework Miscellaneous Development Tips...

.NET Compact Framework Miscellaneous Development Tips:

• Access web service with required network credentials - System.Net.NetworkCredential
  
• How to Install Personal Security Certificate in C# compact framework - x509 PFX personal certificate - CertAddCertificateContextToStore() - PFXIsPFXBlob()
  
• How to Check if Personal Security Certificate Exists in C# compact framework - x509 PFX personal certificate - X509Store - X509Certificate2Collection
  
• How to Retrieve Windows Mobile Device ID in C# Compact Framework - GetDeviceUniqueID()
  
• How to Retrieve Windows Mobile SIM Phone Number in C# Compact Framework - SmsGetPhoneNumber()
  
• How to Retrieve Windows Mobile Application Directory in C# Compact Framework - Path.GetDirectoryName()
  
• How to Retrieve and Load XML Settings in Windows Mobile Application in C# Compact Framework
  

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...

[off topick] - what is NETWORK MARKETING

read more at Articles from Entrepreneur, World Traveler, Health/Wealth Consultant, Mentor - Juliette Gray

How to enumerate running processes using WMI and Win32_Process class

see at How to enumerate running processes using WMI and Win32_Process class

SQL Sever - How to Create a Directory (Folder) - Using xp_cmdshell and mkdir command

SQL Sever - How to Create a Directory (Folder) - Using xp_cmdshell and mkdir command

How to Mass Rename Files from SQL using xp_cmdshell and rename command

SQL Server - using xp_cmdshell and rename command to mass rename files

... 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.

with Network Browser by Using WMI to retrieve Domain Information, Enumerate Computers on Network with WMI:

• Retrieve Domain Name - Using WMI Win32_ComputerSystem - ManagementObjectSearcher, SelectCommand(), ManagementObject
  
• Enumerate computers within a domain - Using DirectoryEntry
  
• Enumerate users within a domain - Using WMI Win32_UserAccount - ManagementObjectSearcher, SelectCommand(), ManagementObject
  
• Enumerate services on a computer - Using WMI Win32_Service - ManagementObjectSearcher, SelectCommand(), ManagementObject
  
• Enumerate services on a computer using WMI - Win32_Service
  

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

Event Log Watcher Process - Export Event Log as RSS feed - Part II - using WMI - Win32_NTLogEvent - ManagementEventWatcher

See how to develop a simple applciation to "export" Windows Event Log Entries as RSS Feeds using WMI - Windows Management Instrumentation - with Win32_NTLogEvent - ManagementEventWatcher at Siccolo Articles - Build Windows Event Log Watcher Service Process to Export Event Log Entries as RSS feed using Windows Management Instrumentation - with Win32_NTLogEvent - ManagementEventWatcher

Build Windows Event Log Watcher Service Process to Export Event Log Entries as RSS feed

See how to develop a simple applciation to "export" Windows Event Log Entries as RSS Feeds at Siccolo Articles - Build Windows Event Log Watcher Service Process to Export Event Log Entries as RSS feed

.... 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

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

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

Format to "Currency" with SQL

see it at Siccolo Articles - How to Create SQL Function To Format To Currency

Siccolo Web Client for Mobile devices - for PocketPC, SmartPhone, Blackberry, iPhone, Palm, Symbian!

Siccolo Web Client for PocketPC, SmartPhone, Blackberry, iPhone, Palm, Symbian helps MS SQL Server professionals save time and increase their productivity by utilizing a more efficient approach to database management - use their Mobile device while sipping margarita on the beach. Siccolo Web Client for PocketPC, SmartPhone, Blackberry, iPhone, Palm, Symbian extends support from mobile devices for Microsoft SQL Servers, enables database administrators to manage their SQL Server environments using a Mobile device, assures the availability of MS SQL Servers 24 X 7. Siccolo Web Client for PocketPC, SmartPhone, Blackberry, iPhone, Palm, Symbian allows to be mobile with Siccolo Mobile Management Tool! Engineered to help you extend your support for mobile devices.

Create Animated GIF right on windows mobile Smartphone!

Giffy for Smartphone (Based on Windows Mobile 5) allows to create Animated GIF right on users windows mobile based Smartphone!

Create Animated GIF right on PocketPC!

Giffy for PocketPC (Based on Windows Mobile 5) allows to create Animated GIF right on users PocketPC!

and now Siccolo for SmartPhones - SiccoloSP - coming to a phone near you!

Wanna manage your favorite SQL Server while sitting on a beach from your SmartPhone? - then SiccoloSP is for you! - view SiccoloSP screen-shots

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 | digg story

Siccolo .NET, VB.NET, C# and SQL development articles...

Siccolo Management Tool For SQL Servers is not just an application. Siccolo web site also contains various articles on .NET, VB.NET, C# and SQL development and Miscellaneous Tips - .NET, VB.NET, C#, SQL Development.

Siccolo development articles:

• Create a web service method to get NT service information


• Web service method to start/stop, restart a NT service
  
• Build Simple Event Log Montior/Watcher (Using TCP in .NET
  
• Create a network browser


• Print Document from Stored Procedure
  

---

and also SQL Server articles:

• Create Stored procedure to convert Excel file into SQL table
  
• SQL Function To Format To Currency
  
• SQL Function - How to Find Beginning and End of Week
  
• SQL Function - How to Find Number of Days in a Month
  
• SQL Function - How to Find Last Day of a Month
  
• Find SQL Server Job Execution Status
  How to Mass Export All Tables Into Excel Files
  
• SQL Function - How to Calculate Bank Routing Check Digit
  
• How to Create a Directory (Folder)
  
• How to Notify User via SMS from SQL trigger (send EMail/Text Message)
  

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.

Siccolo - SQL Server Management Tool For Mobile Devices is packed with built-in functionality and tools.

Siccolo delivers a rich set of management tools for both DBAs and sys admins.
SQL Server management has always been an area of DBA concern. The new Management Tool For Mobile Devices - Siccolo - has simple "Enterprise Manager" and the "Query Analyzer".

Siccolo is a management tool for the MS SQL Server with administration capabilities and a database query tool. The administration features provide users the ability to browse database structures. An integrated query tool allows users to quickly create, edit and execute SQL queries and scripts. Siccolo also provides an export tool to allow users to easily save and email execution results.

Siccolo helps database 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

For increased security, Siccolo is configured to run under SSL with IIS authentication.

Siccolo features are:

• Run SQL Query window (with semi-automated Insert/Update/Delete/Select Statements)
  
  Open/Save SQL Scripts in multiple tabs
  Save/Email results
  
  
• Explore SQL Server
  Browse databases and database objects (tables/views/stored procedures)
  Browse/Manage SQL Server jobs
  Browse/Manage windows services (start/stop)
  View event logs (Application, System)
  
  
• Manage SQL Server - restart MS SQL Server service and SQL Agent
  

...and more to come...future versions will include Backup and Restore...

see Siccolo screenshots


email me at siccolo_mobile_management@yahoo.com for more info

Are there any SQL Server DBA's outthere? - Need to manage from away?

Then check this out - Free SQL Management Tool for Mobile Devices - Engineered to help you extend your support from mobile devices for Microsoft SQL Servers, Siccolo mobile management tool is a portable administration tool for Microsoft SQL Server.

Stay warm and...

Somewhere, somehow got cold this February. but! not to worry - with a shot of B12 from Baltimore Clarity MediSpa - was back in business in no time. So, keep your servers healthy using Free Management Tool For SQL Servers - Siccolo.

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 mobile management tool 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!