Outlook 2007 – Managing email messages with Rules

MS Office, Outlook, Varinder Sandhu

Microsoft Outlook provides a really useful feature as “Rules and Alerts” for managing emails messages. What is Rule? One or more automatic actions taken on e-mail messages and meeting requests that meet certain conditions, along with any exceptions to those conditions. Rules are also referred to as filters. Rules help you manage your e-mail messages by performing actions on messages that match a specific set of conditions. After you create a rule, Microsoft Outlook applies the rule when a message

» Read more
, , ,

How does SharePoint Still Manage to Give a Tough Fight

Guest Post, Share Point

SharePoint is a good fit for corporate needs as it is scalable and versatile. There are free SharePoint site solutions that will benefit small businesses to test its capabilities before going for a big investment. SharePoint has a blend of options for every group of user or business. Its capabilities can be easily exploited for a range of projects and management processes, such as front-end websites to reach customers and back-end programs to train employees. You can make tasks easier

» Read more
, , , , ,

SQL Server – How Like operator work with datetime

SQL, SQL-General, SQL-Query, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

Today, my one of the friend shared a very interesting fact about like operator. With the help of this post I am sharing with you all. We need to convert it to character data while comparing with the like operator. Let‘s check with example Like operator with datetime Like Operator with datetime using convert function If anybody have any suggestion please share as comment.

» Read more
, ,

How good to compare SQL server with MySQL

Guest Post, MySQL, SQL

Installing software programs is never a major factor when looking at databases. However, the right type of software program can till play some sort of crucial role in managing and upgrading specific servers. Comparisons are wider with SQL server and Mysql functions. There are obvious reasons behind such comparisons. The last SQL Server that came out in the market was 2012 edition. It’s 4.2 GB in size and requires a separate .NET framework software tool to get downloaded. Ironically, the

» Read more
, ,

SQL Server – Authentication Mode – Windows Mode and Mixed Mode

SQL, SQL-Advanced, SQL-Tips and Tricks, Varinder Sandhu

During the installation of SQL Server you can choose the authentication mode for Database Instance. SQL Server support the two authentication mode as Windows authentication mode: Windows Authentication mode enables Windows Authentication and disables SQL Server Authentication.  Even if you choose Windows Authentication mode during SQL Server installation “sa” user is created but disable for SQL Server Authentication. But later we you can use “sa” user by enabling for SQL Server Authentication .Any window user can configure as system administrator

» Read more
, , , ,

Things to know about major OpenStack components in Ubuntu Server

Guest Post, Operating System, Others

Every day or the other begins with some Linux release but none get the attention and fame that Ubuntu releases do. Cloud computing is another important release which has revolutionized the world. Reasons for cloud computing to be used: Provides compliance with established cloud standards which gives the users the freedom to move between cloud providers as and when desired. Gives high availability with features like node evacuation which ensures the cloud keeps running properly even if there is a

» Read more
, , ,

Tactics which help to creating custom report templates in SSRS

Guest Post, SQL, SQL-Reporting Services

Deploying the customized report on the SSRS templates is not a very complex task though it needs a lot of concentration. It is represented in a single form format along with the header and footer sections. When the starting phase is begun; the reports are explored in the enterprise level. It ensures the requirement on the consistent outlook. For an instance, the header of this kind of reports should have the associated company logo and also the address where on

» Read more
, , ,

Best way to fix SQL error 8942

Guest Post, SQL, SQL-Advanced, SQL-Tips and Tricks

Structured query language is applied to manage any kind of data extracted from relational database. But during these specific operations several errors can come up into the field. Amongst those, Error 8942 is much common in unexpected occurrence. Though Sql server is much reliable, effective and faster environmental platform, it creates a result like DBCC errors. The main reason is nothing but the overlapping of multiple slots. Here the offsets are greater than previous slots for any exceptional causes. So

» Read more
, ,

SQL Server – How to add column dynamically in where clause

SQL, SQL-Advanced, SQL-General, SQL-Query, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

In this post, we will learn with example how to add the column dynamically in where clause. Example: For demo we have table as shown in the snapshot Basically we want to execute following script (i.e. Script: 1) but column name (i.e. FIRST_NAME) added dynamically in where clause. Script: 1 SELECT * FROM EMPLOYEE WHERE FIRST_NAME = 'VARINDER' Created a table and insert the column name value (i.e. FIRST_NAME) as shown in the snapshot Now we will execute the Script:

» Read more
, ,

What is Guest Post?

Blog-News, Career Development, Others, Varinder Sandhu

Lot of detail information is available on the Guest Posting and its advantages. As I received few questions about guest post and it advantage that‘s why sharing a brief post/note on Guest Post.   Guest Post “A guest post is when someone other than the owner of a blog writes content, and the owner of the blog posts this content while giving credit to the original author, sometimes just by name and sometimes with a link to the content writer’s

» Read more
, ,

SQL Server – The multi-part identifier could not be bound State – Msg 4104 – Fix

SQL, SQL-Advanced, SQL-General, SQL-Query, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

Error Msg Server: Msg 4104, Level 16, State 1, Line 1 The multi-part identifier could not be bound. Cause of this Error Msg: Case: 1 This error usually occurs when an alias is used when referencing a column in a SELECT statement and the alias used is not defined anywhere in the FROM clause. Case: 2 This error occurs if we are using the tables from the two different databases in the join statement and not using the table alias

» Read more
, ,
1 … 5 6 7 8 9 … 26