Geeks With Blogs
Geekette Mai Blog June 2006 Entries
Security.sql in SQL Server 2005- All others SQL Server 2005 Script have moved to Article under SQL Server
------------------------- -- *** Windows Logins *** -- ********************** -- This code assumes that JoeAppdev and JaneAppdev already exist as a Windows login -- Add a Windows login to SQL Server -- Note that the brackets are required for a Windows login CREATE LOGIN [APPDEV\JaneAppDev] FROM WINDOWS; GO USE GO CREATE WITH DEFAULT_SCHEMA = Production GO -- Or, rename the user in the database DROP GO CREATE GO -- Alter the login to add a default schema ALTER WITH DEFAULT_SCHEMA = Production GO -- ......

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

Encryption.sql in SQL Server 2005
Set up sample encryption database USE -- Set up three logins CREATE LOGIN User1 WITH password = '3f@$fWDY3QvP&K0' GO CREATE GO USE CREATE CREATE TABLE Customer ( CustId int, Name nvarchar(30), City varchar(20), CreditCardType varbinary(1000), CreditCardNumber varbinary(1000), Notes varbinary(4000)) GO -- Grant access to user GRANT -- ***************************... -- DATABASE MASTER KEY -- ***************************... ......

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

Transaction.sql in SQL Server 2005
USE Northwind; GO -- Execute these statements in Connection1: BEGIN TRAN UPDATE dbo.Categories SET CategoryName = 'Drinks' WHERE CategoryID = 1; -- Open a new connection and execute this statement SELECT CategoryName from dbo.Categories WHERE CategoryID = 1; -- Create a table to demonstrate compile errors CREATE (ID INT PRIMARY KEY, ColValue CHAR(4)); GO -- Create the batch INSERT INTO dbo.CompileErrors VALUES (1, 'aaaa'); INSERT INTO dbo.CompileErrors VALUES (2, 'bbbb'); INSERT INTO dbo.CompileErrors ......

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

Functions.sql in SQL Server 2005
USE Northwind; ---------------------------... -- Scalar Functions ---------------------------... CREATE RETURNS int BEGIN DECLARE @Total AS int; SELECT @Total = SUM(Quantity) FROM dbo.[Order Details]; RETURN @Total; END GO SELECT dbo.fnProductsSold(); GO SELECT dbo.fnProductsSold() AS TotalSold FROM Products; -- Scalar function with parameter CREATE (@ProductID int = null) RETURNS int WITH RETURNS NULL ON NULL INPUT AS BEGIN DECLARE @total int; SELECT @Total = SUM(Quantity) ......

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

My Computer Crashed?. As a result I lost all the .NET Applications that has been saved. I have recovered all the files from hardware failures(06/25/06)
My desktop computer crashed and died today, and I though, “oh well what the hey“. Now I have to clearn my house and see if I still have my hubby. However it started out with a weird frustrations combined with mild hard palpitations, and then I blamed everyone that I communicated last night. Some of them could hack my computer. Hence I was wrong again(?). I wired in front panel buttons (Power, restart, an IDE LED, and a Power LED). I took these front panel buttons and LEDs from an old computer. Needless ......

Posted On Thursday, June 22, 2006 11:48 AM

use byval for object in method signature
This was a question in one of my interview with American Express, and this was how I understand the question: that I In VB.NET, I found there are a lots methods passing object parameter by value. For example, Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click It's impossible in vb6.In vb6, the object is always passed by reference. How come we can pass object byval in .NET? An object in both VB6 & VB.NET is a Reference Type! ByVal & ......

Posted On Thursday, June 22, 2006 9:34 AM

Themes (skin & css files) in ASP.NET 2.0
Posted on Friday, June 02, 2006 7:29 PM --> I created http://maisworkandfriends.com on Themes (skin & css files) in ASP.NET 2.0. Still trying to decide when it's best to use skin files over css files. Already figured out that an object property should not belong to both. Tested some, and haven't been able to receive consistent results. Is it because... Caching - How does the ASP.NET Developer server work? When using multiple CSS / skin file- Are they always applied in the same sequence Who knows???? ......

Posted On Saturday, June 17, 2006 11:10 PM

404 Error -- File Not Found
404 Error -- File Not Found The page you are looking for (http://vijay.8k.com/index.... is not here. Possible Reasons: You may have spelled the URL incorrectly. This site may have been removed due to a violation of the FreeServers "Acceptable Use Policy". This site may have been moved to a different server ......

Posted On Tuesday, June 13, 2006 11:36 AM

MaiJohnsworkandfamilyGallery
I went fishing /ComputerConference CA/my first sport car/KeyWest2001/ Winter in Rochester! More pictures in pictures gallaries section ......

Posted On Monday, June 12, 2006 9:32 AM

Many psychics’ stopped me
Many psychics’ stopped me in the malls, restaurant, drug stores, bookstores, department stores...etc, and told me about my past love life, and future career, family love life. All of them made me believed that some evils have came into my life from the past has had harm my life for a long time. I needed them to unharm all my bad luck so this will help me be lucky again :) The first few times, I believed in some of them, because they with children, or older folks. For examples: “You are thinking of ......

Posted On Friday, June 9, 2006 9:34 PM

Creating a Windows Forms Application
Developers will create Windows Forms applications much like they do Visual Basic-based forms today (although with Windows Forms, they get the same level of productivity in all of the languages in Visual Studio, not just Visual Basic). In the following image, you can see that a design surface is used to visually lay out the form with rich controls. To edit source code, developers simply double-click a control and the source editor will appear, enabling quick access to the full event model for the ......

Posted On Tuesday, June 6, 2006 6:25 PM

Sometimes your mind is clear and sharp
Sometimes your mind is clear and sharp, but every once in a while, you get lost in a dream world and can't seem to find your way back to reality. Don't pressure yourself to step down to reality at this time. Instead, you should take this time to dream ......

Posted On Sunday, June 4, 2006 11:07 PM

First SharePoint at Devry University in Miramar
I attended the first SharePoint (Session #1 - Level 100 - June 3rd, 2006) at Devry University in Miramar, Room #240, from 2:00 pm to 5:00 pm this weekend. I am very impress with the SharePoint class today, and from Duray Akar's lecture and I have learned more about: 1. List items in calendar 2. Automatically convert Office documents in SharePoint repository, such as World and Excel to Adobe ® allow distribution of read-only, non-editable copies 3. Establish a referential integrity relationship between ......

Posted On Saturday, June 3, 2006 6:24 PM

I should doing this...
But instead me and my computer right now ......

Posted On Friday, June 2, 2006 8:12 PM

South Florida Code Camp Feb 2, 2006
I attended my 1st Code Camp– 2006 South Florida Code Camp, Feb 2, 2006. Not only did I learn a lot, I had a great time. I learned which of the presentations I should goto...( I have seen David Silverlight, Alex Funhouse, and Russ Fustino’s presentations many times during the year). I think that I should attend new presenters that I have never seen before, and I did. I also learned from every session I attended, and from the many conversations I had with other speakers and attendees. I could easily ......

Posted On Friday, June 2, 2006 8:10 PM

Geekette maisblogette
For those of you keeping up with my Geekette maisblogette, I am between jobs again. No, I didn't get fired; I completed working for SunCruzCasino, Inc. So what does a geekette do with the time off liked this? Well, among other things (yeah yeah...geeky things), I decided to catch up on some entertainment. I started with Showtime than HBO. I have been interested in the show for some times. Nevertheless, I head on down to the local video rental store (which is not so local, if you take my meaning) ......

Posted On Friday, June 2, 2006 3:49 PM

Copyright © Mai Nguyen | Powered by: GeeksWithBlogs.net