Microsoft’s Subject Query Language (SQL) Server is one of the strongest, most powerful database management systems available to date.
Topics: SQL Server
Whether your company runs on Oracle, Microsoft SQL Server, IBM Db2, MySQL, IBM Informix, PostgreSQL, or MongoDB, your database is a complex machine that relies on maintenance to function well. A database health check is essential to identify problematic sections so you can enhance your database in the areas that aren’t operating at their fullest potential.
Storage for DBAs:
Ever been to one of those sushi restaurants where the food comes round in dishes on a conveyor belt?
Suspend disbelief for a moment and ponder the following questions: What would your business look like if we made it economical to run your storage infrastructure at speeds closer to that of memory than that of disk storage? How fast would your applications run? What business models would it open up? How much competitive advantage can you gain?
SSD’s are like cordless phones and DVD’s. They made an improvement on an existing technology but didn’t revolutionize its use. In technology there is a difference between the concept of modernizing and revolutionizing. Modernizing is finding a way to do the same thing, just a little bit faster or little bit easier. Revolutionizing is either eliminating or vastly changing how something is done.
Flash is about latency and IOPs so why would it be good for Data Warehousing or Business Intelligence?
Excellent question. Yes, the typical marketing and wow-factor stats around flash are based on latencies and IOPs (Input Output Per Second). Data warehousing (DW) and Business Intelligence (BI) is normally a throughput game, so what gives?
Transactional workloads are commonly defined as being small atomic pieces of work. This is in contrast to decision support, Data Warehouse, Business Intelligence or otherwise labeled reporting systems that require fewer, larger, more sequential workloads. Updates, inserts, deletes and even small result-set selects are all included in OLTP, transactional efforts.