: In this episode of the Notes from the Field series database expert Mike Lawell explains about Availability Group and the Six Critical Steps for DBAs to Follow. 881 more words
Tags » SQL Tips And Tricks
The databases world is expanding and I have been fortunate enough to learn and share my experiences around databases like MySQL, PostgreSQL apart from working with SQL Server. 502 more words
In this world of change, the SQL Server product is also changing. One thing which is very clear is that Microsoft is listening to feedbacks from customers and enhancing the setup experience also. 274 more words
Question: How @@DATEFIRST and SET DATEFIRST are related?
Answer: The master database’s syslanguages table has a DateFirst column that defines the first day of the week for a particular language. 125 more words
There are a number of blogs around using SPARSE columns here. Here are few of them for reference and can be used as a great learning experience. 537 more words
I had recently gone to my hometown to visit my parents as it was holidays for my daughter because of festival. These are relaxing times and hardly try to get in front of my computer during these 2-3 days of family time. 532 more words