(Basit Farooq) With strengthened security management guidance from the industry, Microsoft is building more security and auditing features into SQL Server. These SQL Server auditing features not only help DBAs generate audit trails of schema changes and security-related events, but also allow compan

(Rohatash Kumar) Today, I have provided an article showing you how to utilize the new logical functions in SQL Server 2012. These are the two functions:

(Kun Lee) As with many companies, we are trying to make our Test environment as close to our Production environment as possible. Our production environment is very replication intensive and we want to have our Test environment mimic Production as much as possible.

(Rui Inacio) The company that I work at the present time has received the new SQL Sever hardware, so now is the time to upgrade from the SQL server 2008 to the 2012.

(Robert Sheldon) Developers are always looking for ways to make their lives easier. That’s just as true for the business intelligence (BI) community as anyone. So, when Microsoft released SQL Server 2012 — along with an updated version SQL Server Integration Services (SSIS) — the BI folks were gri

(Vinoth NM) One of most under utilized function by DBA for monitoring SQL server is EVENTDATA() function, With Evendata function you can monitor many database and instance level changes at a granular level.

The most effective way to assure stability and sustainability is to make sure your boss isn’t your only conduit to success. If he is the only one that knows your value and potential, then (once he is gone) it is much like jumping out of an airplane with no parachute. It’s a little too late to creat

(Manvendra Singh) A database snapshot is a very useful feature in SQL Server. This can be used to fulfill many requirements like point-in-time reporting requirements and reverting a database back to a point in time. In this tip I will explain how to revert a database snapshot to recover your databas

(Pinal Dave) Yesterday I wrote a real world story of how a friend who thought they have an issue with intrusion or virus whereas the issue was really in the code. I strongly suggest you read my earlier blog post Curious Case of Disappearing Rows – ON UPDATE CASCADE and ON DELETE CASCADE – Part 1 of

(Rohatash Kumar) Today, I have provided an article showing you how to use a return value with a Stored Procedure in SQL Server 2012. In this article we create a stored procedure to avoid duplicate record insertion in the SQL Server database prior to insertion into the database.