Mobile Management For SQL Server(s!) - Siccolo - SQL Management Tool
Main  
How to Articles on .NET, VB.NET, C#, SQL development:
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. Siccolo is the premier GUI admin tool for Microsoft SQL Server management, control and development.

Siccolo gives you wide opportunities to perform all the necessary database admin routines such as creating, editing, dropping database objects; moreover, you can build queries, execute queries and SQL scripts, view data, export data, manage SQL Server users and their privileges, add jobs and alerts, and use a lot of other admin tools implemented to make your work with SQL Server highly enjoyable and efficient.

If you need the job done right and on time, do it with Siccolo on your team. Siccolo provides you with a number of easy-to-use features for performing the required data manipulation and server management easily and quickly.


List of articles on .NET and SQL Server development:

How to Articles on .NET, VB.NET, C#, SQL development you may find useful...


Miscellaneous Development Tips...
  How to add an event source - Using EventLog.CreateEventSource() and EventLog.SourceExists()
  How to monitor and react to event log changes - Using OnEntryWritten and EnableRaisingEvents
  How to check for Shared Open Files - Using WMI .NET Win32_ConnectionShare
  How to enumerate running processes - Using WMI .NET Win32_Process
  How to Use System.Net.NetworkCredential to connect to secure web site
  How to Open Dataset from Text File - reading and parsing CSV files
  How to address showModalDialog() problem
  
Custom File Upload Control - Javascript and Scripting.FileSystemObject , Web Service/ASP.NET and C#
  
Facebook Application Development with FBML and ASP.NET/C#
  Facebook Application Development with FBML and ASP.NET - Setup Facebook Application
  Using <asp:GridView> with FBML
  Using <fb:dashboard> in ASP.NET
  using FBJS Animation to show DIV
  Using <fb:friend-selector> with ASP.NET and FBML
  Using <fb:editor> with ASP.NET and FBML
  Adding FBJS client-side validation
  Using FBJS Dialogs
  Using <fb:iframe> with ASP.NET and FBML
  using FBJS AJAX with ASP.NET/C#
  Sending notifications with ASP.NET/C# and FBML
  Fix for FacebookAPI.CreateSession() - FacebookAPI.ErrorCheck() - Invalid Parameter
  using FBML Tabs - <fb-tabs/> and <fb:tab-item/>
  using <fb:request-form/>
  building Invite page with FBML multi friend selector
  access Facebook Data from ASP.NET (C#) using FQL and DirectFQLQuery()
  update Facebook user profile using SetFBML, <fb:subtitle/>, <fb:wide/>
  update Facebook user profile using <fb:ref/>, SetRefHandle
  build scheduled updates for Facebook - "cron job"
  populate user profile mini-feed using PublishAction(), Feed.publishActionOfUser
  handle Application unsintall/remove using Post Remove URL
  
.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 Keep Log File in Windows Mobile Application in C# Compact Framework
  
How To Develop SQL Mobile Management Tool
  
Create a web service method to get NT service information - Using System.ServiceProcess.ServiceController, RegistryKey, OpenRemoteBaseKey(), PathToExecutable
  
Web service method to start/stop, restart a NT service - System.ServiceProcess.ServiceController, Service.DependentServices, WaitForStatus(), Service.Stop(), Start()
  
Web Method To Display Server Logical Disks Remotely on Mobile Device
  
Web Method To Display Server Directory Tree Remotely
  
Web service method to backup database from mobile device - using SQL Backup command and asynchronous method calls
  
How to Build Remote Event Log Montior/Watcher (Using TCP in .NET) - Using EventLog.EnableRaisingEvents, OnEntryWritten, TcpListener, TCP.Send(), Receive()
  
Build Windows Event Log Watcher Service Process to Export Event Log Entries as RSS feed - Using EventLog.EnableRaisingEvents, OnEntryWritten
  
Build Windows Event Log Watcher Service Process to Export Event Log Entries as RSS feed using WMI (Windows Management Instrumentation) - Win32_NTLogEvent - ManagementEventWatcher
  
How open Dataset From Text File - Display Text File in GridView or ListView
How open Dataset From Comma delimited (CSV) File - Reading CSV files - Parsing CSV Files - using TextFieldParser
  
Create a network browser - .Net enumerate computers, users, active directory on network - Using WMI (Win32_ConnectionShare) with .NET
  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
  
  
Siccolo for SmartPhone - How to create Open File and Save File As Dialogs
  
Siccolo for PocketPC - How to create Open File Dialog with Filter
  
SQL Server - Create Stored procedure to convert Excel file into SQL table - Using SQL Server OLE: sp_OACreate sp_OAMethod, Excel.Application, WorkBooks.Open, WorkBook.SaveAs
  
SQL Server - Create SQL Function To Format To Currency
  
SQL Server - Create SQL Function - How to Find Beginning and End of Week
  
SQL Server - Create SQL Function - How to Find Number of Days in a Month
  
SQL Server - Create SQL Function - How to Find Last Day of a Month
  
SQL Server - How to Find SQL Server Job Execution Status - Using xp_sqlagent_enum_jobs
  
SQL Server - How to Mass Export All Tables Into Excel Files
  
SQL Server - Create SQL Function - How to Calculate Bank Routing Check Digit
  
SQL Server - How to Create a Directory (Folder) - Using xp_cmdshell and mkdir command
  
SQL Server - Mass Rename Files - Using xp_cmdshell and rename command
  
SQL Server - Print Document from Stored Procedure - Using SQL Server OLE: sp_OACreate sp_OAMethod sp_OADestroy, Word.Application, Word.Document.PrintOut
  
SQL Server - How to Notify User via SMS from SQL trigger (send EMail/Text Message): - Using xp_sendmail command - You can send SMS messages using a SQL Server database server with the help of SQL queries.
  
  
 Microsoft CRM Customization: - how to Customize MS CRM -
SQL Server - MS CRM Customization - How to import Leads records from Excel into CRM via Email
  
MS CRM Customization - How to add custom CRM Report to Reports Grid in CRM
  
MS CRM Customization - How to Qualify Leads in CRM - Set Lead State and Status in CRM


Web being sponsor - Mid-Atlantic Processing. Well being sponsor - Clarity MediSpa. Hairless sponsor - Clarity MediSpa Laser Hair Removal. Marketing - Resource and Marketing Consultant.
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
Application Development Articles - .NET, VB.NET, C#, SQL development - Using WMI with .NET - Watch Event Log With .NET - Microsoft CRM Customization and CRM Customization Tools - Siccolo - SQL Management Tool - Designed for Microsoft SQL Server
From CodeProject Latest Articles
Latest Articles from CodeProject  From: Mon, 25 Sep 2017 11:09:00 GMT
Day 12: Creating AI Movements For Enemies In Unity
Mon, 25 Sep 2017 11:09:00 GMT - CodeProject Here we are at Day 12 of the 100 days of VR. Yesterday, we looked at the power of rig models and Unity’s mecanim system (which I should have learned but ignored in the Survival Shooter tutorial…) Today, we’re going to continue off after creating our animator controller. We’re going to c
Day 11: Using Real Enemy Asset From The Unity Asset Store
Mon, 25 Sep 2017 11:08:00 GMT - CodeProject Welcome back to Day 11 of my 100 days of VR development! Continuing from where we left off, we have a cube as an enemy, we can do better than that. In fact, today, after playing around with creating my own character animations with rigging and Unity’s Mecanim system and I’ll tell you th
Day 7: Creating a VERY Simple First Person Shooter
Mon, 25 Sep 2017 11:08:00 GMT - CodeProject Welcome back to day 7, after the behemoth that was “yesterday’s” Survival Shooter tutorial, I’m itching to get back to coding something. At this point, we have gained enough experience to start making some very simple gameplays on our own. And that’s exactly what I’m going to do! Note h
Day 8: Creating a Character in a First Person Shooter
Mon, 25 Sep 2017 11:08:00 GMT - CodeProject Here we are on day 8! Yesterday we created a very simple map for a simple FPS feature. Today, I went to look to see how we can move a character around in the scenery that was created. Here’s what I got! Creating our character The first thing I figured out who was the “character”. Turns
Day 9 Setting up a Weapon
Mon, 25 Sep 2017 11:08:00 GMT - CodeProject Welcome back to day 9! Were you wondering why there was a large gap between today and the last post? Well that’s because I went to participate in the Seattle AR/VR hackaton #6! The hackathon was 3 days long and it took me 2 days to recover from it! Check out my hackathon postmortem! Wit
Day 10: Creating An Enemy
Mon, 25 Sep 2017 10:17:00 GMT - CodeProject Welcome to a very special day of my 100 days of VR. Day 10! That’s right. We’re finally in the double digits! It’s been an enjoyable experience so far working with Unity, especially now that I know a bit more about putting together a 3D game now. We haven’t made it into the actual VR as
Code Coverage Badges for TeamCity
Mon, 25 Sep 2017 09:01:00 GMT - Creating a Code Coverage badge from TeamCity
Getting Started With Raspberry Pi - Part III - How To Use Breadboard?
Mon, 25 Sep 2017 04:09:00 GMT - In this article we will how to use Breadboard- its a great we to connect circuits and you pi together.
How to Use Exchange Web Service in C++ With gSOAP
Sun, 24 Sep 2017 23:33:00 GMT - How to connect EWS with gSOAP to send, delete, and retrieve emails.
Color Topics for Programmers
Sun, 24 Sep 2017 17:05:00 GMT - Discusses color spaces, color generation, and other general color topics commonly faced by programmers.