Why use a Date Dimension Table in a Data Warehouse

Why use a Date Dimension Table in a Data Warehouse

In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you are using the Kimball Dimensional Modeling method. In the beginning of Dimensional Modeling, it was called a Time dimension. Since then, the Time dimension has...

Get Started with Execution Plans in our June #SQLChat!

Get Started with Execution Plans in our June #SQLChat!

Our next #SQLChat will be held Wednesday, June 8 at 12 PM Noon CT with IDERA ACE, Thomas LeBlanc (@TheSmilingDBA). We will be discussing how to get started with reading execution plans. Whether you are an expert at reading execution plans, or new to the concept, this...

Encryption vs. Security Analytics

I recently read 2 articles on security; The first covered the new model in which analytics are used to detect security issues; And a second advocating the need for encryption and why it was much better than the new model of security analytics. The two articles...

Using the Floating Form Designer in Delphi

Using the Floating Form Designer in Delphi

The Floating Form Designer is often commented as one of the reasons many developers still love using Delphi 7 after almost 14 years. In that time Delphi has moved on a long way, firstly moving to the Galileo (docked) IDE, added unicode, 64bit compiler, Generics,...

May #SQLChat – “Uncovering Data Modeling Myths”

May #SQLChat – “Uncovering Data Modeling Myths”

Our next #SQLChat will take place Wednesday, May 11 at 11 AM CT with host Karen Lopez (@datachick) as she leads a conversation exploring the myths and misunderstandings that surround data modeling. This #SQLChat will allow members from the SQL community to discuss SQL...

April #SQLChat Wrap-Up: SQL Server Migrations

IDERA hosted its April #SQLChat on Tuesday, April 12 at 11 AM CT with Rie Irish, Director of Database Administration with Paymetric, Inc. This Twitter Chat covered SQL Server Migrations and was hosted on the date SQL Server 2005 fell out of service. This was the...

SSRS Report Won’t Render in VS Preview

SSRS Report Won’t Render in VS Preview

I love getting get a laptop, but getting all the software reinstalled and making sure everything works can be trying. Last week, I was lucky enough to get a new one and spent two days getting it setup just right. At least so I thought…. once I started working on it of...

Enabling a Data Culture Through Continuous Improvement

Progressive organizations recognize data as a strategic asset and rely upon it for critical decision making. Business intelligence spending has been steadily increasing and is forecast to be upwards of $16 billion worldwide in the next year. Major investment and...

1 92 93 94 95 96 124