This article is the 5th edition in the memory lane series. 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. Let me know which one of the following is your favorite article from memory lane.
SQL SERVER – Fix Visual Studio Error : Connections to SQL Server files (.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL
In one of the virtual environment while I was trying to add SQL Server Database (.mdf) file to asp.net project I encountered following error: Connections to SQL Server files (.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: …
Read MoreSQL Contest – Win USD 300 Worth Gift – Cartoon Contest is Back
There are two excellent contests and we have lots of winning to do this year end. In this blog post we are going to have a cartoon contest again.
SQL SERVER – Auto Recovery File Settings in SSMS – SQL in Sixty Seconds #034 – Video
Every developer once in a while facing an unfortunate situation where they have not yet saved the work and their SQL Server Management Studio crashes. Well, you can minimize the loss by optimizing auto recovery settings. In this video we can see how to set the auto recovery settings.
SQL SERVER – Shard No More – An Innovative Look at Distributed Peer-to-peer SQL Database
There is no doubt that SQL databases play an important role in modern applications. In an ideal world, a single database can handle hundreds of incoming connections from multiple clients and scale to accommodate the related transactions. However the world is not ideal and databases are often a cause of…
Read MoreSQL SERVER – Sends backups to a Network Folder, FTP Server, Dropbox, Google Drive or Amazon S3
Let me tell you about one of the most useful SQL tools that every DBA should use – it is SQLBackupAndFTP. I have been using this tool since 2009 – and it is the first program I install on a SQL server. Download a free version, 1 minute configuration and…
Read More
SQL SERVER – Find Weekend and Weekdays from Datetime in SQL Server 2012
Yesterday we had very first SQL Bangalore User Group meeting and I was asked following question right after the session. This question is about to Find Weekend and Weekdays from Datetime in SQL Server 2012.
SQL SERVER – Cursor, Log File and More – Memory Lane #004
This is the 4th episode 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 article this week is an article discussing cursor and log file. Let me know which one of the following is your favorite article from memory lane.
SQLAuthority News – Android Efficiency Tips and Tricks – Personal Technology Tip
I use my phone for lots of things. I use it mainly to replace my tablet – I can e-mail, take and edit photos, and do almost everything I can do on a laptop with this phone. And I am sure that there are many of you out there just…
Read MoreSQL SERVER – Removing Leading Zeros From Column in Table – Part 2
Earlier I wrote a blog post about Remvoing Leading Zeros from Column In Table. It was a great co-incident that my friend Madhivanan (no need of introduction for him) also post a similar article over on BeyondRelational.com. I strongly suggest to read his blog as well as he has suggested…
Read More