Information Management News

Sponsors

Announcing Data Summit Connect 2020

With most people working from home offices and travel plans on hold, it's more important than ever to stay connected. That's why the annual Data Summit conference is going digital this year with Data Summit Connect, a free 3-day series of webinars presented by DBTA and Big Data Quarterly from Tuesday, June 9, to Thursday, June 11. Registration is now open. Read More

6 Steps to Win with Data: First, Get Out of Denial

What more companies need today is a "data lab" to create ideas from data and a "data factory" to turn those ideas into products. Google, Amazon, and other data-driven giants already work like this. So should companies outside of technology.  Read More

COVID-19 Accelerates Change for DBA Roles

COVID-19 has had a dramatic impact on organizations of all types. Recently, John Pocknell of Quest Software, talked with DBTA about trends in database management before and after the new crisis-forced shift to remote work and how DBAs' roles are being affected. As part of his responsibilities as senior market strategist at Quest, Pocknell looks at emerging challenges and speaks to customers to understand where future problems and opportunities may lie ahead to help map the company's database solutions to those needs. Before the crisis, DBA roles were undergoing radical change and that is only accelerating now, Pocknell says. Read More

After the Pandemic: IT Leaders Discuss What Will Change

Business and IT have, in the past, used times of crisis to adapt and transform themselves for the better. While the COVID-19 pandemic has undeniably had a devastating effect on business, and life itself, it may also be a catalyst for change, compelling organizations to rethink their long-term operations and spending amidst the short-term crisis brought on by the health emergency. Industry leaders recently discussed what "the new normal" may look like. Read More

Newsletters


Columnists

Todd Schraml

Database Elaborations

Todd Schraml

  • Future Facts and Type 2 Dimensions One creates the potential for some interesting anomalies when building a star schema wherein the fact table contains future-dated metrics and any of the dimensions are Type 2.  A Type 2 dimension tracks changes to the data items contained within it. Effectively, each dimension contains a surrogate key, a natural key with a start and stop date, and additional descriptor columns. If any of the descriptor column values change, the existing dimension row has the stop date populated while a new row is inserted with the same natural key, new start date, and new descriptor values. 
Recent articles by Todd Schraml
Craig S. Mullins

DBA Corner

Craig S. Mullins

  • Minimizing Database Lock Contention Issues As a database consultant, one of the things I am most frequently asked about is dealing with database locking issues. Every DBMS has different settings and parameters to control locking at the system and database levels. And, yes, it is important to set these up correctly, but they are rarely the core cause of performance problems caused by locking. So let's focus on the universal issue that is almost always the culprit: poor coding techniques and inappropriate oversight before code is moved to production.
Recent articles by Craig S. Mullins
Kevin Kline

SQL Server Drill Down

Kevin Kline

  • Azure Cosmos DB Adds Features and Free Tier I've kept you informed over the years about not just the latest news and features in SQL Server, but across the entire Microsoft Data Platform, both on-premise and in the cloud. This includes additional products such as SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and their cloud siblings, Azure Synapse Analytics, and Azure Data Factory (ADF). Another important and powerful sibling product is Azure Cosmos DB, previously known as Document DB, which I first wrote about here many years ago.
Recent articles by Kevin Kline
Guy Harrison

MongoDB Matters

Guy Harrison

  • How Will MongoDB Fare in Difficult Times? To predict how MongoDB may navigate COVID-19 and post COVID-19 environment would require an ability to predict how our industry as a whole will fare—which is a big ask. Nevertheless, let's give it a shot.
Recent articles by Guy Harrison
  • Maximizing the Value of Digital Data Even before the IT elements of data optimization begin, aligning organizational culture around a data-driven mindset will be a major challenge. Making the case for data optimization is important. Even before the IT elements of data optimization begin, aligning organizational culture around a data-driven mindset will be a major challenge. Making the case for data optimization is important.
Recent articles by  

Trends and Applications