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 MoreSQL SERVER – What is Hekaton? – Simple Words Explanation
Readers of this blog will know that I recently attended SQL Server (PASS) Summit 2012. There were, of course, a lot of fascinating subjects and people, but let me talk about one of my favorites right now. Ted Kummert, corporate vice president of the Data Platform group at Microsoft, announced that the new version of SQL Server will include a feature called “Hekaton.” Hekaton is Greek for “hundreds,” and it was given this name for its ability to speed up database function 100x (possibly). It certainly increases application speed by 10x and nearly 50x for new, optimized applications.
SQL SERVER – Log File Very Large, TempDB and More – Memory Lane #008
This is the 8th episode of the weekly series of memory lane. Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. My favorite articles this time are about the solution when the log file very large as well as T-SQL script to find details about TempDB. Let me know which one of the following is your favorite article from memory lane.
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 More
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.