Some questions never get old. Let me list a few of them. As the year 2012 is about to end, today I will talk about three of the most asked questions to me in an email. Let us learn about restoring databases.
SQL SERVER – Fix – Error: 4214: BACKUP LOG cannot be performed because there is no current database backup.
Here is the interesting conversation I recently heard between two teammates in one of the organizations I visited. DBA Jr: I can’t take transactional backup of the database. DBA Sr: What is the recovery model? DBA Jr: How to find the recovery model? DBA Sr: Go to SSMS >> Right…
Read More
SQLAuthority News – Chrome Browser – Personal Technology
Almost every computer you can buy these days will come with Microsoft Windows installed on it automatically. Also installed automatically – Internet Explorer, Microsoft’s web browser. Many of us use this browser without a second thought, but in this latest Personal Technology Tip and Trick I thought I’d expand your…
Read MoreSQL SERVER – Difference Between CURRENT_TIMESTAMP and GETDATE() – CURRENT_TIMESTAMP Equivalent in SQL Server
A common question – I often get from Oracle/MySQL Professionals: “What is the Equivalent to CURRENT_TIMESTAMP in SQL Server?” Here is a common question I often get from SQL Server Professionals: “What are differences between Difference Between CURRENT_TIMESTAMP and GETDATE ()?” Very simple question but have showed up so frequently that I…
Read MoreSQL SERVER – Select and Delete Duplicate Records – SQL in Sixty Seconds #036 – Video
Developers often face situations when they find their column have duplicate records and they want to delete it. A good developer will never delete any data without observing it and making sure that what is being deleted is the absolutely fine to delete. Before deleting duplicate data, one should select…
Read MoreSQL SERVER – Select the Most Optimal Backup Methods for Server
Backup and Restore are very interesting concepts and one should be very much with the concept if you are dealing with production database. One never knows when a natural disaster or user error will surface and the first thing everybody wants is to get back on point in time when…
Read MoreSQLAuthority News – First SQL Bangalore Event Report – Nov 24, 2012 – SQL Server User Group Bangalore
A very common question I often receive – Do we have SQL Server User Group in Bangalore? Yes! SQL Bangalore – we had very first meeting on Nov 24, 2012 and very soon we are going to have another User Group meeting. The goal is to keep up a monthly…
Read More