Geeks With Blogs

@GeeketteMai
  • GeeketteMai Someone try to send me a virus to ruin my computer. I hope I don't make any your guy mad , I mean no harm to anyone :-) about 1180 days ago
  • GeeketteMai I like this: "http://bit.ly/cd14ZO " one 1 blog can others blogs show the same nice like the first on. Instead it showed the entire links? about 1184 days ago
  • GeeketteMai First time using the Wii for work out :-) today!! about 1186 days ago
  • GeeketteMai Good night in 14 min and 12 second for sample twitter-search-monitor application complete download. Hope is worth it :( about 1187 days ago

News Internet - .Net user group technical events, emerging .Net technologies;
General - Eco-travel, health and fitness, current events;
Community - Active volunteer with Hands On Miami, Non-Profit Ways;
.Net Framework - Detected 3.5 SP1 .NET Framework. No update needed ;
creative zen converter

Geekette Mai Blog SQL Servers
ASP.NET AJAX Toolkit documentation
I am using Visual Studio 2008 and thereby utilizing the ASP.NET AJAX plumbing that comes along with it. Step 1: Open VS 2008. Click File > New > Website. Choose ASP.NET Website from the list of installed template, choose target platform as .NET Framework 3.5, choose the desired language and enter the location where you would like to store the website on your FileSystem. I have created a folder called VS2008 Projects, so the location over here is C:\VS2008 Projects\ GridViewPaginUsingSliderExt... ......

Posted On Thursday, January 14, 2010 9:47 PM

user interface, Toolbox, Common Controls, Properties, Pictures,and Containers
I am refreshing myself how to prgramming in VB again :-) The user interface is a very important part of any program: This is how people use your program it needs to look good and do its job well. Most important for beginner is how to use the Toolbox and how to make controls like buttons and checkboxes fit on the form better. Toolbox is where you will find all of things to add to your user interface like buttons and labels. If you don't see it (it's usually on the left) you can make it appear by clicking ......

Posted On Thursday, January 14, 2010 9:26 PM

Database Questions and Answers Concepts Part2
Q. What's the main difference between ACCESS and SQL SERVER? Ans: As said before access fulfill all of the CODD rules and behaves as a true RDBMS. But there's a huge difference from architecture perspective, due to which many developers prefer to use SQL SERVER as a major rather than access. Following is a list of architecture difference between them: Access uses file server design and SQL SERVER uses the Client/Server model. The major difference between SQL SERVER and ACCESS. NOTES: Just to clarify ......

Posted On Monday, February 19, 2007 9:18 PM

Database Questions and Answers Concepts Part1
Q. What is database or database management systems (DBMS)? TWIST: - What's the different between file and database? Can files qualify as a database? NOTE: Probably these questions are too basic for experienced SQL Server guys. But from freshers point of view it can be a difference between getting a job and to be jobless. Ans: Database provides a systematic and organized ways of storing, managing and retrieving from collection of logically related information. Secondly the information has to be persistent, ......

Posted On Saturday, February 17, 2007 8:47 PM

View in SQL Sever 2005
USE Northwind; ---------------------------... -- Create a view to format data for -- mailing labels ---------------------------... CREATE VIEW dbo.vwEmployeeAddressLabels AS SELECT Address FirstName + SPACE(1) + LastName + Char(13) + Char(10) + + Char(13) + Char(10) + City + CASE WHEN Region IS NULL THEN ' ' + PostalCodeELSE ', ' + Region + ' ' + PostalCodeEND + Char(13) + Char(10) + CountryAS Address FROM dbo.Employees; GO -- Select from the view: -- (best viewed with results to text) ......

Posted On Thursday, July 13, 2006 3:00 PM

Created Sample database SQL Server 2005
USE masterGOif exists (select * from sysdatabases where name='Northwind') drop database Northwindgo DECLARE @device_directory NVARCHAR(520)SELECT @device_directory = SUBSTRING(filename, 1, CHARINDEX(N'master.mdf', LOWER(filename)) - 1)FROM master.dbo.sysaltfiles WHERE dbid = 1 AND fileid = 1 EXECUTE (N'CREATE DATABASE Northwind ON PRIMARY (NAME = N''Northwind'', FILENAME = N''' + @device_directory + N'northwnd.mdf'') LOG ON (NAME = N''Northwind_log'', FILENAME = N''' + @device_directory + N'northwnd.ldf'')')go ......

Posted On Thursday, July 13, 2006 2:47 PM

TSQL in SQL Server 2005
---------------------------... -- Batches -- Create a table and a view ---------------------------... --This causes an error USE tempdb; CREATE TABLE dbo.Test ( ID TestName ); int NOT NULL, varchar(50) NOT NULL CREATE VIEW dbo.vwTest AS SELECT TestName FROM dbo.Test; --Creating multiple dependent objects requires a GO separator. USE tempdb; CREATE TABLE dbo.Test ( ID TestName ); int NOT NULL, varchar(50) NOT NULL GO CREATE VIEW dbo.vwTest AS SELECT TestName FROM ......

Posted On Thursday, July 13, 2006 2:38 PM

SQLCLR.sql in SQL Server 2005
-- Enable SQLCLR -- ************* sp_configure GO 'clr_enabled', 1 RECONFIGURE GO -- Install and register HelloSQLCLR -- ***************************... USE GO Northwind -- Install (change the directory to the actual location) CREATE ASSEMBLY MyUDFsLibFROM 'C:\SQL2005Core\SQLCLR\Hell... GO -- Register CREATE FUNCTION dbo.HelloSQLCLR() RETURNS NVARCHAR(50) EXTERNAL NAME MyUDFsLib.MyUDFs.HelloSQLCLR; -- EXTERNAL_NAME is assembly name, namespace/class, -- and method name -- Test ......

Posted On Thursday, July 13, 2006 1:47 PM

Trigger.sql in SQL Server 2005
USE Northwind; GO CREATE PROCEDURE dbo.ListEmployees AS SET NOCOUNT ON SELECT EmployeeID, LastName, FirstNameFROM dbo.Employees; GO EXECUTE dbo.ListEmployees; EXEC dbo.ListEmployees; GO CREATE @City PROC dbo.ListEmployeesByCityvarc... AS SET NOCOUNT ON SELECT LastName, FirstName, CityFROM dbo.EmployeesWHERE City = @City; GO EXEC dbo.ListEmployeesByCity @City = 'London'; EXEC dbo.ListEmployeesByCity 'London'; GO CREATE @City PROC dbo.ListEmployeesOptionalCi... = NULL AS SET NOCOUNT ON ......

Posted On Thursday, July 13, 2006 1:40 PM

SQL Server 2005 Features Comparison
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Posted On Tuesday, June 27, 2006 4:41 PM

SQL Sources

Select “SQL Sources”.  line above.   Well, by now you already get it right? one of my favor SQL Sources :)!!

Posted On Monday, May 29, 2006 4:37 PM

The Professional Association for SQL Server
The Professional Association for SQL Server Migrating to SQL Server 2005 - Tips and T... Regional Chapters and Groups OLAP Browser is a multi, data analysis and reporting, software application for MS SQL Server Clients Free SQL Server Resources on SearchSQLServer.com ER/Studio of Embarcadero.com ......

Posted On Monday, May 29, 2006 2:35 PM

Using Knowledge Management to vastly improve Database Management
Using Knowledge Management to vastly improve Database Management Database Management needs to continue move into direction by using Knowledge Management. She sees Data moving from being a cost center administrative function to an active contributor of corporate profits. Outcomes and Opportunities this Idea affords: Working closely with an organization's Database Management Team to apply her knowledge in finding the right tools and technique as well as the right assignment. One of the most important ......

Posted On Monday, May 29, 2006 12:05 PM

SQL Instruction
The presentation does not define the complete syntax -- see sqlgram.py for the precise syntax as BNF -- nor the complete semantics -- see a good book on SQL for more detailed coverage of semantic (or use the source, Luke ;c) ). Also, please have a look at my evolving database course notes for more coverage of SQL. Examples of all supported constructs are also shown in the test suite source file gftest.py. This document is only a very brief guide, primarily of use to those who already understand something ......

Posted On Sunday, May 28, 2006 9:05 PM

Other Procedure Guide
OTHER PROCEDURES sp_bcp: Create unix script to bcp in/out database sp_date: Who can remember all the date styles? sp_iostat: Loops n times showing active processes only sp_grep: Search for patern sp_isactive: Shows info about a single active process sp_lsLists specific objects sp_ quickstatsQuick dump of server summary information sp_whoactive: Show info about who is active The following is a list of errors generated by the auditing procedures 31001 User +name+ Is Locked 31002 Login +name+ Is Expired ......

Posted On Sunday, May 28, 2006 9:01 PM

a guide to a free set of stored procedures
These procedures are installed into sybsystemprocs on sybase and into master on sql server. All procedure names start with "sp__" (two underscores). This naming convention ensures that the procedures, when run, will be available from any database and that, when they are run, the database context will be the current database. This naming convention also ensures that there are no naming conflicts with Sybase's internal procedures. Thus, if you are in the statsdb database, you can get the space used ......

Posted On Sunday, May 28, 2006 8:57 PM

Checks Common Database Problems
Checks Common Database Problems Lists users in group public if groups are used. Warn about lack of groups if no groups exist besides public. List users aliased to another non dbo user. List aliases without logins (login previously dropped). List users without logins (login previously dropped). List objects owned by non-dbo (maybe poor code control?). Find objects with access to syslogins in them. This procedure excludes normal objects like sp__addlogin. Use of this procedure will identify potential ......

Posted On Sunday, May 28, 2006 8:51 PM

Copyright © Mai Nguyen | Powered by: GeeksWithBlogs.net | Join free