Saturday, January 29, 2011

Re-generating SQL Server Logins

Migrating database servers is quite a frequent task which is carried out by a DBA. In migrating, it is very important to transfer the logins. When transfering logins and users, you need to make sure that you transfer roles and password as well.
By querying the system tables, database administrators can produce a comprehensive report for login permission including original password, the server and database roles assigned, down to granular level object permission.
This article describes how to achive this and other information behind this.

Friday, January 21, 2011

Tips & Tricks for DBAs Writing Their First Article

I have been writing articles from 2003 (only 7+ years not much, still more to go) in some SQL sites like www.SQLServerCentral.com ,www.sql-server-performance.com , www.sqlserveruniverse.com etc.

Brad Mc Gehee is one of few who inspired me to write articles.Now he has comeup with some tips and tricksfor writing articles.

Hope you will take a leaf out of this and start writing. Good luck.

Friday, January 14, 2011

SQLskills Free Online MCM Training

These videos are designed to give an overview of the breadth of subject knowledge required, plus some indication of the depth to which you should know it.

Monday, January 10, 2011

SQL Server Data Mining with Microsoft Office Excel

Data mining is made easier with Excel. This is my first article with data mining.

Thursday, January 6, 2011

Importing dbf files

dbf files (dbase 3+, clipper or foxpro) to SQL Server is something that you won't get frequently. However, it might not be as simple as importing other data sources.

This faq by me, tells you how to do that.

Wednesday, January 5, 2011

Sending Email to Different Domains using Database Mail

This FAQ tells you how to send mail to difference domains using Database Mail.

SEQUENCE in SQL Server 2011

SEQUENCE is a core new feature of SQL Server 2011 (Denali). It is a more performant, flexible alternative to the INDENTITY attribute. This article introduces sequence and demonstrates how to use it and its performance advantage.

Read my first article on Denali

Tuesday, January 4, 2011

Ten Techniques to Guarantee a Successful DW/BI Solution

The ingredients to a successful Data Warehouse / Business Intelligence deployment include good project management, effective communication and using DW/BI tools to their full potential. Denise Rogers presents her top 10 techniques to guarantee a successful DW/BI deployment.

The ingredients to a successful Data Warehouse / Business Intelligence deployment include good project management, effective communication and using DW/BI tools to their full potential. A Data Warehouse / Business Intelligence application is being built, NOT an OLTP application. So use the ETL solution and its features in support of the solution, the Business Intelligence software to its full potential, the DBMS and its Data Warehouse functionality. Other essential ingredients include getting the resources trained or experienced hires or both that know how to exploit the features and functionality that each of the components of the solution has to offer.

Read more at here