The History of Business Intelligence

Saturday, 18 April 2009 12:49 Alex Rosa Database - General

(3 Votes)

Posted by: Joey Snow | Apr 13th @ 7:00 AM

There is a lot of talk these days around business intelligence, and it's important that we at IT Professionals understand what is is, what it came from, and where it's going. The folks over on the Business Intelligence team sent me this video that tells the story of B.I. in a very unique way.

The History of Microsoft

Thursday, 09 April 2009 21:54 Alex Rosa Career - DBA

(1 Vote)

Visit the CHANNEL9 at MSDN and know the Microsoft's history with text and videos.

Very interesting to know the Microsoft's evolution through the years.

Backup And Restore Remain Time

Saturday, 06 December 2008 18:56 Alex Rosa SQL Server - Scripts

(2 Votes)

If you execute a BACKUP or a RESTORE using the SQL Server Management Studio (GUI), the percentage completed will be shown on the screen for each 10% completed, ex.: 10%, 20%, 30%....

If you need to know, how long does it take?...use the DMVs and a simple SELECT, check the script below.

Columns:
START TIME, PERCENT COMPLETED, COMMAND, DATABASE NAME, STIMATED COMPLETION TIME, MINUTES TO FINISH.

Rebuilding Indexes and Updating Statistics, the correct sequence...

Wednesday, 24 December 2008 10:11 Alex Rosa SQL Server - Indexes

(3 Votes)

Rebuilding Indexes or Updating Statistics, which do you do first?
Why?
Are there differences?

Rebuilding an index will update statistics with the equivalent of a full scan - doesn't matter whether you use DBCC DBREINDEX or ALTER INDEX...REBUILD, the effect is the same. It can do this because it sees a complete picture of the index while it’s doing the rebuild.

Reorganizing an index (using the old DBCC INDEXDEFRAG, or the new ALTER INDEX...REORGANIZE) will NOT update statistics at all, because it only sees a few pages of the index at a time.

So, which is the correct sequence?

Windows Sysinternals

Saturday, 15 November 2008 20:56 Alex Rosa Windows Server - Troubleshooting

(1 Vote)

There are some free tools that we can use in Windows environment that help us in performance analysis, troubleshooting, documentation usage, and server configuration.

You can download these tools from Windows Sysinternals website:

More Articles...