Monday , December 11 2017
Home / 2016 / November

Monthly Archives: November 2016

step by step Procedure for Creating DDL Triggers (Part-1)

DDL-Trigger

DDL triggers: DDL triggers fire in response to a variety of Data Definition Language (DDL) events. These events primarily correspond to Transact-SQL statements that start with the keywords CREATE, ALTER, DROP, GRANT, DENY, REVOKE or UPDATE STATISTICS. DDL triggers are fired when user performs DDL events(CREATE,ALTER and DROP) in the …

Read More »

what is Trigger and Types of Triggers in SQL Server

TYPESOFTRIGGERS

Triggers in Sql Server:- A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server.A trigger is executed implicitly whenever the triggering event happens, which performs their own operation when user performs any INSERT, UPDATE, DELETE operations on a specific table. …

Read More »

5 Tips for a Smooth SSIS Upgrade to SQL Server 2012

5-tips-for-a-smooth-ssis-upgrade-to-sql-server-2012

SSIS Upgrade Microsoft SQL Server 2012 Integration Services (SSIS) provides significant improvements in both the developer and administration experience. This article provides tips that can help to make the SSIS Upgrade to Microsoft SQL Server 2012 Integration Services successful. The tips address editing package configurations and specifically connection strings, converting …

Read More »

Best Call Recorder Apps For Android – 2016

Best Call Recording Apps

Having an important conversation while knowing that you’ll probably forget it all when the call ends? Discussing ideas that will be lost just because you don’t have a pen and paper? Or maybe wanting proof that someone did say something to you? Few Android based smart phones are provided inbuilt apps …

Read More »

Free ebook: Introducing Microsoft Power BI

Microsoft PowerBI

Microsoft Power BI: Get started quickly with Microsoft Power BI! Experts Alberto Ferrari and Marco Russo will help you bring your data to life, transforming your company’s data into rich visuals for you to collect and organize, allowing you to focus on what matters most to you. Stay in the …

Read More »