By Otoniel D.
Hi everyone, last week I had to make a quick research about Dynamic Management Views (DMV) so I could create a quick technical session to give to my colleagues; a quick overview about this particular subject.
I really have to admit that I enjoyed it a lot. Mainly because I believe that DMVs are one of the greatest features that Microsoft SQL Server have.
But now that I’m writing this post, I found out that DMV’s are actually categorized. This means basically two things. First, that the sys schema is so intuitive that it allows you to use it easily and second that I need to look at the MSDN SQL Server 2008 Books Online more closely. J
Let’s take a look about how do I fin...
By Edith Colegio
If you haven’t already, you should think about adding social capabilities to your website. This will help you attract new users, and keep them on your website for longer and get them to come back more often. The use of existing toolkits like the Windows Live Messenger Web Toolkit can be very useful to achieve this.
Using the Windows Live Messenger Web Toolkit
You can use this toolkit to integrate presence, instant messaging, and contact information using the following interfaces
Windows Live Messenger UI Controls
These controls are a set of UI building blocks. The UI Controls are easy to add to an existing XHTML page. They provide a professional UI ...
By Cesar Olivas
When you start creating a website, you have to make some choices before you start. Some of these choices are using HTML or XHTML, Tables or Divs, Floats or Position, Inline Styling, etc. In this post I will give you some explanation of all the elements that you usually need to choose from.
DoctypeEvery website needs to have a doctype declared, failing to do so may result on your page rendered ineffectively. The best way is declaring a doctype like xhtml transitional, strict or html 4.01 and help meet standard requirements. As a personal experience, this has been an issue in SharePoint implementations, since default masterpages do not include a doctype. In a customizatio...
By Cesar Olivas
CSS has been around for some time now, since 1996, and it completely changed the way people used to make websites, for good. First came CSS1, with some support for fonts, color text, backgrounds, spacing between words, alignment, margins, paddings and some other attributes; it looked really good for its time.
Then same CSS level 2 in 1998, which introduced some powerful features like positioning, z-index, media types. Then came the revision we use right now, CSS level 2 revision 1(CSS2.1) which fixed some errors in CSS2 and removed some unsupported features.
But the web is evolving, turning into a more interactive, user-centered design; the technologies were bound to ev...
By Gabriel Palma
The situation
A customer asked recently for a quick daily report of about-to-expire items, he wanted something simple that could be sent via email to the people already registered in the database. Acquiring the information was very simple (as simple as writing a query). The problem was getting those results inside an email and sending it automatically every day.
We came up with a scheduled SQL Server job running daily, getting and shipping the results without passing through .Net code.
The steps
Step 1. Write the query to retrieve the raw data.
I used AdventureWorks database for the following example. Here I’ll get a report of work orders with due date ...
By Eduardo Chaccourt
For all of us working in software development industry, we are often seen as people with a very methodic, squared, always “inside the box” way of thinking. This is natural since most of us have had a very engineer-like formation in college. Subjects such as Binary math and circuit design, where everything has to be exact, this helped to achieve this way of thinking.
I’m not stating that this is necessarily wrong or “bad”, but not 100% precise. My thoughts are that software engineering is also a pretty creative profession. Imagine this scenario that was pretty recurring back in the day: You need to develop some software to control an onboard car computer, one of...
By Edith C
Building a SharePoint solution can be a mess, but using this tool, the process becomes very easy and intuitive.
Feature creation
Prerequisites:
· Install WSP Builder tool
1. Create a new project on Visual Studio (i.e. Feeds)
2. Add a new item on the project, right clicking Project Name, Add… New Item… WSP Builder Templates, select Web Part Feature set a name for it (i.e. Feeds), and click Add.
3. Set the name and description of the new feature, and set the scope: Web, Site, WebApplication or Farm. Click OK.
4. Your feature its created, and the generated files are:
· 12/TEMPLATE/FEATURES/Feeds folder (this is...
By Edith C.
If you've seen a blog (out of the box) in SharePoint, you will have noticed that even though you change the color, image, font, etc. of the document it still has the same style that at the very beginning.
To be able to change the "theme" of complete blog you need to change the MasterPages styles, and finally a very detailed and tedious task. I found a solution on CodePlex, a very professional solution to be able to achieve this.
The best of all is that this solution is a "Feature", meaning you can activate and deactivate it after creating your blog, and in a very quick and easy way. You only need to download it, unzip the zip file on the server, and ru...
Silverlight provides a great set of controls, with which you can capture and display data. While the properties for the controls can be assigned directly to each control, in our .XAML file using attributes, some properties can be duplicated among different controls, causing difficulties in our .XAML maintenance.Here is an example of this issue.
<Button x:Name=”btnSubmit” FontFamily=”Arial”
FontWeight=”Bold” Width=”100″ Height=”25″ Margin=”10″ />
<Button x:Name=”btnCancel” FontFamily=”Arial”
FontWeight=”Bold” Width=”100″ Height=”25″
Margin=”10″ />You can see that both controls define the same value for FontFamily, FontWeight, Width, Height and Margin. Maybe this XAML works...