(Pinal Dave) Every weekend I spend time learning something new and interesting. My primary focus is always on either performance of SQL Server or performance of myself. This weekend, I downloaded dbForge Studio for SQL Server.

(Dallas Snider) By default, SQL Server Analysis Services will sort and display dimension attribute values in alphabetical order. When displaying the days of the week or the months of the year (as shown below), we often want to see the data in chronological order instead of alphabetical order.

(Jason Brimhall) The calendar tells us that once again we have reached the second tuesday of the month. In the SQL Community, this means a little party as many of you may already know. This is the TSQL Tuesday Party.

(Igor Pagliai) SQL Server AlwaysOn Availability Group (AG) is a great technology for high-availability and disaster-recovery, and if you want to build an IaaS VM environment in Azure, you have to deal with it since Windows Server Failover Clustering (WSFC) is not supported here yet.

(Larry Leonard) The “Central Management Servers” functionality of SQL Server Management Studio is an excellent way to apply the same code to every server. By “every server”, I mean groups of servers that you define: you might have different servers in folders named “Production”, “Development”, “QA”,

(Tim Ford) The Template Explorer is a little known tool inside the SQL Server Management Studio (SSMS) IDE. It allows you to store custom scripts, parameterize them for re-use and have them at your fingertips without ever having to leave SSMS. Previously, we looked at how you gain access to the Temp

(Marcin Policht) In our recent articles published on this forum we have been discussing characteristics of the Microsoft Azure SQL Database offering. So far, we have been dedicating our attention to the process of its deployments (mainly by importing schema and data from an on-premises environment)

(Chris Webb) The Unorder() function is probably one of the least used functions in the whole of MDX. It exists only as a query performance hint and, since I had never up to now found a scenario where it did improve the performance of a calculation I had pretty much forgotten about it (as Books Onlin

(Pinal Dave) The heat is picking up and I am glad you are liking this series going so far. This particular report is close to my heart and the most recommended. At my recent trip to Delhi and the user group out there, I had the opportunity to meet a number of young DBA’s who were getting into their

(Greg Robidoux) One of the primary duties for a SQL Server DBA is to ensure that the database server stays online without causing disruption to users. DBAs do all types of things to improve performance, such as using new indexing strategies, maintaining indexes, optimizing code, and separating data