Geeks With Blogs
My Digital Life in Data Flow Data Warehouse, MDX, Cube, SSIS, BizTalk, SQL, XML, SSAS, SSRS, .NET March 2014 Entries
SQL Cast versus Convert: CAST should be first choice

I've always been a fan of CONVERT because of datetime CONVERT takes in a style argument and allows me to format the string quickly.  I have since learned that CAST is the standard SQL, and should be first choice of use.

Once I read through the entire article here on MSDN, it's pretty clear that's the rule, but seem to be an unwritten one.  http://msdn.microsoft.com/en-us/library/ms187928.aspx

Posted On Tuesday, March 25, 2014 2:32 PM

Very happy with my Windows Phone so far
I got a HTC 8XT windows phone from Sprint a month ago. So far I've been very happy. The list of app is certainly disappointing, and that's on Microsoft to have to incentivize developers and companies to put out apps, because they certainly wouldn't do it now based on current market share. However, the UI is clean, and I can completely customize it to give me the level of notifications I want. I can bypass most of the apps that I need by using the mobile website from the company, so I haven't lost ......

Posted On Thursday, March 20, 2014 11:01 AM

Very honored to be referenced by MSSQLTIPS
I am very honored that one of my blogs is being referenced by MSSQLTips as exam material help. I started this blog a while ago because I got frustrated with forgetting some cool stuff I've done before, and I am very glad that it not only helped me, but help some in the community. Microsoft developer community has been so great, I'm happy to do my part. http://www.mssqltips.com/sq... My blog being ......

Posted On Thursday, March 20, 2014 10:46 AM

Very honored to be referenced by MSSQLTIPS
I am very honored that one of my blogs is being referenced by MSSQLTips as exam material help. I started this blog a while ago because I got frustrated with forgetting some cool stuff I've done before, and I am very glad that it not only helped me, but help some in the community. Microsoft developer community has been so great, I'm happy to do my part. http://www.mssqltips.com/sq... My blog being ......

Posted On Thursday, March 20, 2014 10:28 AM

Real-time report VS Application
It is very often that we report developers get requests about "real-time" reports. I don't know about you, but I cringe every time I hear about this. For some people, "real-time" report means I have a report that executes a query in the database to get result back. But when you think about it, if you answer "yes" to any of the following questions, you don't really have a real-time report: Is your dataset cached on the report server? Is the query result cached on the database server? Does your source ......

Posted On Thursday, March 20, 2014 10:18 AM

Copyright © Kevin Shyr | Powered by: GeeksWithBlogs.net