|
|
-
|
|
Recently I needed to convert a float value to nearest integer...
I used Convert.ToInt32
The problem found with is it will convert decimal like 7.5,8.5 to nearest even integer
Convert.ToInt32(7.5)=>8
Convert.ToInt32(8.5)=>8 !!!
The solution f...
|
|
-
|
|
I love the track changes feature in Word. But a similar feature is not available in PowerPoint. The workaround is to post "comments" in PowerPoint. it's not as elegant as "track changes" feature in word but it's OK for now. ...
|
|
-
|
|
There's no way to return a resultset and set variables using a single SELECT statement.
But there's one way to do it using a MERGE statement.
It's quite simple, you first declare a variable table which will be used to store some data.
You then use a ME...
|
|
-
|
|
I Just Learned that Micorosoft Reporting also support reporting services for Apple iPad Devices in line with some other properietory Tools (Microstrategy)....
|
|
-
|
|
Today, during the Meet Windows Azure event, I learned that we can run SQL Server on Windows Azure VM role (which are now persistent in nature)! ...
|
|
-
|
|
From inside a content page you might want to alter the DOM tree when your master page layout prevents you to achieve a peculiar layout effect (for instance when doing a full-screen inline popup).
But whenever you manipulate the DOM with javascript, be ...
|
|
-
|
|
A simple method to find out who altered/modified an object in SQL server using trace.
SELECT I.*
FROM
sys.traces T
CROSS Apply ::fn_trace_gettable(T.path, T.max_files) I
Join sys.trace_events E On I.eventclass = E.trace_event_id
...
|
|
-
|
|
I just learned there is a difference between slicing and dicing in world of Data warehouse. Slicing refers to applying filters on a single dimension in a cube whereas dicing refers to applying filters on more than one dimension in a cube...
|
|
-
|
|
In context of Master Data Management (MDM), I just learned the difference between reference data vs. master data (a.k.a master reference data). Reference data is business data used in a "single" app/system/process. Whereas Master Data is business data u...
|
|
-
13
Liked
| 10
Learned
| 9
Comments
|
|
Sometimes when SQL Server is configured to use some port other than default port number (1433), then you may not be able to connect directly in SSMS just by specifying the name of the server in the **Server Name** field in **Connection to Server** dialo...
|
|