SQL Server 2008 July Community Technology Preview has been released. With SQL Server 2008 July CTP release, customers can immediately utilize new capabilities that support their mission-critical platform and enable pervasive insight across the enterprise. SQL Server 2008 lays the groundwork for innovative policy-based management that enables administrators to reduce their time spent on maintenance tasks. SQL Server 2008 provides enhancements in the SQL Server BI platform by enabling customers to provide up-to-date information with Change Data Capture and MERGE features, and develop highly scalable analysis services cubes with new development environments.
SQLAuthority News – My Favorite Articles of This Blog
The question I receive very often is I have more than 250 articles so far on this blog, which are my most favorite articles so far? Yesterday while talking with my parents on occasion of my birthday, they asked the same question to me. Answer is I keep running list…
Read MoreSQLAuthority News – Birthday of SQL Authority Author
Today is Birthday of SQL Authority Author. Thought of the day : Family is everything. https://www.pinaldave.com/ http://www.SQLAuthority.com Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQL SERVER – Data Warehousing Interview Questions and Answers Complete List Download
Click here to get free chapters (PDF) in the mailbox It was a great pleasure to write latest series about Data Warehousing Interview Questions and Answers. Just like always again, I received lots of suggestion and follow up questions. I have tried to accommodate all of them in the last…
Read MoreSQL SERVER – Data Warehousing Interview Questions and Answers – Part 3
Click here to get free chapters (PDF) in the mailbox What are slowly changing dimensions (SCD)? SCD is abbreviation of Slowly changing dimensions. SCD applies to cases where the attribute for a record varies over time. There are three different types of SCD. 1) SCD1 : The new record replaces…
Read MoreSQL SERVER – Data Warehousing Interview Questions and Answers – Part 2
Click here to get free chapters (PDF) in the mailbox What are normalization forms? Please visit this article. Describes the foreign key columns in fact table and dimension table? Foreign keys of dimension tables are primary keys of entity tables. Foreign keys of facts tables are primary keys of Dimension…
Read MoreSQL SERVER – Data Warehousing Interview Questions and Answers – Part 1
Let us learn about Data Warehousing Interview Questions and Answers.