(John Miner) Many institutions have the requirement to take a weekly backup of a user defined database. The actual timing of the backup is not important; however, keeping restore points for several years is important. How can this business requirement be solved with Azure SQL database?

(Pinal Dave) This blog is about another common error reported by many DBA to me. He faced error related to create file in OS.

(Jack Vamvas) The best way to set the database default locations for data and logs is when you first install the SQL Server Instance. They can be set through the configuration.ini file.

(Arun Sirpal) Have you ever wanted SQL Server Management Studio (SSMS) 17 to have a dark theme? Seeing the below image (visual experience color theme options) really got me excited.

(Kenneth Fisher) The BEGIN/END block is a fairly standard thing if you’ve ever done any coding, but it never hurts to do a little review. Not to mention that there are always people just starting to learn about a subject.

(Jorg Klein) One of the major benefits of Azure is scalability, the cloud is built to be elastic, to be as cost-effective as possible. Azure solutions can be scaled in ways that would never be possible with your own hardware.

(Chris Webb) In almost 20 years of using Analysis Services I have never, ever used HOLAP storage. However the other week I was with a customer that was using ROLAP storage on top of Exasol and while query performance was generally good, I wondered whether building an aggregation or two in SSAS might

(Pinal Dave) In this blog post we will discuss 7 points to remember while taking effective backup for SQL Server.

(James Serra) There are a tremendous amount of Microsoft products that are cloud-based for building big data solutions. It’s great that there are so many products to choose from, but it does lead to confusion on what are the best products to use for particular use cases and how do all the products

(Ahmad Yaseen) When designing a data warehouse, it is recommended to use numeric or integer keys to filter records or in the join operator predicates, rather than using string columns. Applying these predicates on string values is very expensive and will significantly slow down your analytical quer