By Posted on Posted in Business Intelligence, DBA, SSAS Tagged with , ,

I was trying to deploy my AdventureWorksDW2012 Cube Sample  and got interesting error as below OLE DB error: OLE DB or ODBC error: Login failed for user ‘MYDOMAIN\MYSERVER$’.; 28000 If you receive above error most likely your SSAS Instance running …

SSAS Cube Deploy/Processing Error – OLE DB or ODBC error: Login failed for user ‘[MyServer1\user1$]’.; 28000 Read more »

By Posted on Posted in SQL Server, T-SQL Tips No Comments Tagged with ,
T SQL Date format convert function

Recently I had to work on database migration project from SQL 2000 to SQL 2008 and one of the challenges you face is scripting correct permissions to new database. There is no way to script user permissions in right way …

How to Script user permissions for SQL Server 2000/2005/2008 for all or single user Read more »

By Posted on Posted in SQL Server No Comments Tagged with ,
T SQL Date format convert function

Here is the script which can give you SQL Server file IO Statistics for each file and file group. Using this data you can find out sql server read/write performance of your disks. DECLARE @TotalIO BIGINT, @TotalBytes BIGINT, @TotalStall BIGINT …

Measure the I/O load on database files and file group using fn_virtualfilestats Read more »

By Posted on Posted in Amazon AWS, Cloud Computing, Windows Azure No Comments Tagged with , ,

Here is the presentation which compares Amazon AWS vs Windows Azure services. Hope this gives you enough information to get it going. Again try out both Cloud Services and the decide based on several factors. Things changing fast so some …

Compare Amazon AWS vs Windows Azure Cloud Services Read more »

By Posted on Posted in Cloud Computing, SQL Azure Database, Windows Azure No Comments Tagged with , ,

Here is the list of videos from TechEd for Azure General IaaS Best Practices from Real Customers: Deploying to Windows Azure Infrastructure Services (IaaS) http://channel9.msdn.com/Events/TechEd/NorthAmerica/2013/MDC-B361#fbid=HXConkFs07x Building Your Lab, Dev, and Test Scenarios in Windows Azure Infrastucture Services (IaaS) http://channel9.msdn.com/Events/TechEd/NorthAmerica/2013/MDC-B370#fbid=HXConkFs07x Infrastructure …

TechEd Videos for Windows Azure Platform Read more »

By Posted on Posted in SQL Server, T-SQL Tips No Comments Tagged with , ,
T SQL Date format convert function

Northwind is my favorite database for trying out sample T-SQL scripts because of its simplicity. Here is the full script you can just copy/paste and run in SSMS (for sql server) or SQL Developer (for oracle) to create Northwind database …

Northwind Database Creation Script for SQL Server and Oracle Read more »