|
|
-
|
|
Its Chrismas and New Year holiday time. Both Google & Microsoft seems to be playing same "Let it snow" competition.
1. Go to google.com and search for "Let it snow". Press enter.
2. Go to below URL.
http://ie.microsoft.com/testdrive/p......
|
|
-
|
|
Today I just help my kid's to learn tables. I lean new technique for learn nine table like
Now Hold out both of your hands with palms facing away from you.Numbers your fingers from 1 to 10 from left to right. Make sure you know the number correspondi......
|
|
-
|
|
Recently, I came across a situation where I wanted to remove entries of "server name" from history of SQL server management studio.
and we can do that by following: Go to "%appdata%\Microsoft\Microsoft SQL Server\100\Tools\Shell" (For SQL Server 2008)......
|
|
-
|
|
It can't get simpler than this: Drag the "Email" to the "Tasks" Tab that you can find in Bottom Left corner. What I like about it is that It let's to specify start date, end date, priority, status, reminders. Just wonderful! I have been using it for a w...
|
|
-
|
|
@@ROWCOUNT returns the number of affected rows by last statement.
Below example illustrate the same
CREATE TABLE #t (id int)
INSERT INTO #t(id) values(1)
DELETE #t
SELECT @@ROWCOUNT
Here we will get @@ROWCOUNT AS 1
But same did not...
|
|
-
|
|
I just learned that we can record our slideshows (PowerPoint/PPT), save it as WMV and upload them to Youtube!. I just uploaded a presentation for testing purpose: ...
|
|
-
|
|
To help you move to the cloud, Microsoft is offering a limited time* "Two for One" exam offer. When you purchase and take a qualifying exam at full price between April 11, 2012 and June 30, 2012, you will be emailed a voucher valid for the next version ...
|
|
-
|
|
I tried uploading Adventure Works DW Image files which were > 100 in number on a SharePoint 2010 Shared Document and I got an error that says "Select less than 100 files to add to shared folder". I searched a little and figured this constraint is to not...
|
|
-
|
|
I just learned that SQL server (2008) was the last commercial database to support spatial data But then SQL Azure is the very first CLOUD based database to support spatial data. ...
|
|
-
|
|
Unfortunately SSIS does not provide regular expression or an IsNumeric check which is required very often to validate the data. I came across a neat work around. Here it goes:
In the derive column set up the following expression for a new column.
(...
|
|