Fresh Tutorials
updated May 24, 2019
Posted May 23, 2019 by

How To Send Email Using Database Mail In SQL Server

How To Send Email Using Database Mail In SQL Server

Sending email is a routine task needed in any application. Emails used for sending an alert, message, query result, attachment or any other notification to users. SQL Server uses the Database Mail component to configure and send emails. Using this back end component rather than a frontend application for sending email is hassle-free. Giving more control to manage security and logging. Continue Reading

Category Database, SQL Server

Posted May 22, 2019 by

How to Calculate Percentage in Excel [ Shortcut for % Change]

You can calculate percentage in Excel through many different methods. Some involve formatting cells and use of complex formulae, while others do not. Our main focus will be on the latter. Continue Reading

Category Microsoft Excel

Posted May 21, 2019 by

How to Calculate Standard Deviation in Excel [STDEV.S Formula]

If you’re someone who has to deal with a lot of numbers on a daily basis, you must familiarize yourself with a large array of Excel formulae. To perform basic mathematical operations, such as addition, multiplication, subtraction and Standard deviation (SD), you must learn how these formulae work.
Continue Reading

Category Microsoft Excel

Posted May 21, 2019 by

How To Schedule SQL Agent Job Using SSMS GUI

SQL Server agent job is a windows service based scheduler. Agent job is used to schedule and automate SQL scripts, administrative tasks, SSIS packages and various other tasks using SQL agent job tool. This component is integrated along with SSMS and available under Object explorer as SQL Server Agent. Continue Reading

Category Database, SQL Server

Posted May 19, 2019 by

How to Use the Snapchat Gender Swap Filter to Get the Best Laughs

One little click and your jaw flattens out, hair transforms into these luscious wavy curls, and cheeks glow with a pinkish tinge. You gotta hand it to Snapchat. In a time when the gender fluidity movement is on the rise, their gender swap filter is a witty and well-informed introduction.

Continue Reading

Category Snapchat

Posted May 19, 2019 by

How To Read Uncommitted Dirty Data In SQL Server

Dirty Read Problem - Read Uncommitted Isolation - SQL Server_Feature

Transaction is an essential part of the database. No database design is complete without handing transaction behaviour correctly. Transaction defines that all the set of operations has to succeed or fail as a unit. Partial success or failure results in the unexpected output. Transaction is needed to maintain integrity in the database. Continue Reading

Category Database, SQL Server

Posted May 16, 2019 by

How To Use BCP Utility In SQL Server

How To Use BCP In SQL Server

BCP (bulk copy program) – a command line utility that bulk copies data between SQL Server database tables and data files. Using BCP, we can export data from a database table, view or a query to data files, generally text delimited files. Moreover, using BCP to import data into SQL Server database table from data text files. It is recommended to use BCP for loading a large number of data rows between SQL Server instances or data files. Continue Reading

Category Database, SQL Server

Posted May 14, 2019 by

How to Enable Dark Mode in Fb Messenger [Latest Update]

Facebook has finally responded to the wishes of its users with a new update for Facebook Messenger.

For an app that is the talk of the town, a simple vision-friendly dark mode feature is a no-brainer. But the management at Facebook, for some odd reason, didn’t think so for many many years.

Before, you could enable the dark Mode in FB messenger through a root hack or by way of a moon emoji. There was, however, no direct or built-in option to toggle it on. Continue Reading

Category Apps, Facebook

Posted May 12, 2019 by

How to Add Page Numbers in Word [ to the First and a Specific Page]

Whether you’re creating the manuscript of your first novel or working on a research proposal, learning how to add page numbers in Word is an essential part of the formatting process. Continue Reading

Posted May 10, 2019 by

How to Change your Relationship Status on Facebook — 2019 Latest

Did you recently go through a bad breakup? Is keeping your personal life a secret important to you? Is Facebook a big part of your life? Or are you simply looking for eligible suitors to approach and hook up with you? If you said yes to all those questions then you’re in the right place. This tutorial will show you how to change your relationship status on Facebook, with commanding ease.

Continue Reading

Category Facebook

Posted May 10, 2019 by

How To Use IF…ELSE Statement In SQL Server

How To Use IF…ELSE Statement In SQL Server

A conditional statement IF…ELSE included in many programming languages. IF…ELSE works on boolean expression resulting in TRUE or FALSE. Besides, different actions can be performed on boolean expression results.

IF…ELSE in SQL Server is used to check expression and based on the results (TRUE or FALSE) execute another SQL statements block. Continue Reading

Category Database, SQL Server