(Daniel Calbimonte) I would like to know if I should use a Tabular or a Multidimensional solution for my data analysis. Which one is the best solution?

(Pinal Dave) I have been using Microsoft Azure, SQL Virtual Machine (IaaS) for quite some time because few of my clients ask questions about them. My clients generally use images from gallery to deploy SQL Server. Once they realized that they want to change the SQL Server collation instance.

(Kenneth Fisher) I’ve playing around with AdventureWorks and managed to found some hidden code! Truly odd stuff. I’m so shocked I couldn’t wait until the time I usually post.

(Jack Vamvas) An important DBA security management skill is the principle of least privilege.

(Tim Smith) We have several hundred servers and want to know if there is a simple way in PowerShell to obtain the VLF (virtual log file) counts in all of the databases on our servers. We want to keep a record of these counts and track over time, especially after we make configuration changes.

(Glenn Berry) As I have been watching what has been going on recently in the Windows and SQL Server world, I have come to the conclusion that it is a particularly exciting time to be a database professional working with SQL Server, largely because of all of the recent and upcoming advances in techno

(Srini Kumar) Who does not hate being stopped and given a traffic ticket? Invariably, we think that something is not fair that we got it and everyone else did not. I am no different, and living in the SF Bay Area, I have often wondered if I could get the data about traffic tickets, particularly sinc

(Pinal Dave) Sometimes making a change in something for which the impact is not known, could cause a heavy loss. A similar situation happened when one of my clients called me and told that he is in big trouble and losing a lot of money every minute.

(Richard Carr) In some situations it can be necessary to fail quickly when a query is blocked, rather than wait for locks to be released. This can be achieved simply using the NOWAIT hint.

(Jen McCown) As often as I have to pull a job’s name based on its job_id in the MSDB system tables, I’m truly stunned that I’ve never done this before: