As RDX gears up for an exciting 2016 full of user groups, trade shows, and regional events, there are a handful of upcoming SQL Saturdays at which you can find experts from RDX. SQL Saturdays are free, one-day training events and are held in cities worldwide throughout the year. SQL Server professionals of all levels are encouraged to attend as speaking sessions range from beginner to advanced. There are also a variety of networking opportunities available such as pre-conference sessions in select cities and after parties.
As business intelligence continues to make a big splash into businesses, SSAS and cubes are becoming a requirement. One of the limitations that DBAs face every day is converting from reading and writing T-SQL statements to being able to read and write MDX with ease. In order help others who may have been thrown into the role, I am going to start a series on MDX code writing. This blog post will be geared towards translating a simple T-SQL SELECT statement into an MDX SELECT statement.
I have found that database snapshots are under-utilized and wanted to show an example of how efficient it is to use them prior to a code deploy for the purpose of recovering a single table or reverting an entire database from a snapshot in the event of unexpected functionality within an application.
From database configuration to performance and maintenance, DBAs are responsible for the most critical data essential to business functionality and success. The knowledge they hold regarding database security, availability, recoverability, performance, and numerous other areas makes them critical to the success of the company. Also tasked with designing database data stores, a DBA’s expertise allows them to consult on company solutions aimed at reducing operation costs, improving margins, and more – simply put, they allow organizations to make better business decisions.