This is the 1st post out of my 10 post series of my 10th book – SQL Basics. Today will show the importance of data and information.
SQLAuthority News – Releasing Author’s 10th Book – SQL Basics Joes 2 Pros: A Getting Started Guide to Administering and Developing SQL Server Databases for Beginners
I authored 10 books so far and my 10th book is released today. You can get that in Paperback (USA) and Kindle (Worldwide) . Idea of the Book I have been blogging for over 6 years now and have been receiving over 1000s email every day since last year. I have been keeping every…
Read MoreSQL SERVER – Understanding Restrict Access to Restricted_User Database Property
Recently I received an empty email with the subject “Question for you”. I was bit surprised as the email had no content at all. It was absolutely empty. I wrote back to user asking if he has missed the text in the email. He responded that there was an image…
Read MoreSQL SERVER – Weekly Series – Memory Lane – #040
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…
Read More
SQL SERVER – Disk Space Monitoring – Detecting Low Disk Space on Server
A very common question I often receive is how to detect if the disk space is running low on SQL Server.
SQL – Crossword Puzzle Based on Course Building Successful High Traffic Profitable Blog
Do you like Crossword Puzzles? I personally love it. Everytime I open the newspaper, I try to resolve at least one crossword or sudoku. It is just fun to tease a brain little and stretch its limits.
Regular readers of the blogs are aware that I have recently published two courses on how to build successful high traffic profitable blog.
SQL SERVER – How to Compare the Schema of Two Databases with Schema Compare
Earlier I wrote about An Efficiency Tool to Compare and Synchronize SQL Server Databases and it was very much well received. Since the blog post I have received quite a many question that just like data how we can also compare schema and synchronize it. If you think about comparing the schema manually, it is almost impossible to do so. Table Schema has been just one of the concept but if you really want the all the schema of the database (triggers, views, stored procedure and everything else) it is just impossible task. Let us learn about Schema Compare.