|
|
-
|
|
SQL Server 2008 R2 has two new additions to its Analysis Services (BI) hat, PowerPivot for Excel and PowerPivot for SharePoint.
Similarly SQL Server 2012 also includes new features for PowerPivot component that features for both SharePoint and Excel. To ch...
|
|
-
|
|
MAP Toolkit is a very helpful tool (personally I have been using this since last 5 years) whenever you have a migration task in your IT environment. Not only for the migration tasks I believe it is useful to get an audit of information on the IT inventory....
|
|
-
|
|
In my earlier post Blip at 2 AM - Scene 1, I had introduced to a situation wherein I had to figure out performance issue of a busy 24x7 system with a problem statement in a one liner. That was Scene 1 of Act 1, and here is what happened in the Scene 2 of A...
|
|
-
|
|
Whenever you are presented with performance requirements or dragged into some serious performance related issues on SQL Server, the first place to look is disk. Let it be any type of server or hardware bottlenecks can occur due to server resources as follo...
|
|
-
|
|
For most of the day today, I had been scourging the web to find out if anyone had done comparison of different ETL tools that are available in the market. I found bunch of links which had good information on how to evaluate different parameters before narr...
|
|
-
|
|
Have you ever had a one liner issue from the clients saying "Blip at 2 AM!". If you have then I am happy that I have a company, and if you haven't one like mine then you are saved.
A little old case, but great learning on how to handle performance issues t...
|
|
-
|
|
Error Management is a key task in any project or task that you handle.
Since the SQL Server 2005 version the Management Tools (SQL Server Management Studio) equipped with majority of tools to obtain such information related to the instance or database. One...
|
|
-
|
|
SQL Server administration is one of the key responsibilities for every DBA to keep up the availability, performance, and scalability of the data platform. Well not an easy or small job/task to manage MultiServer administration unless the automation is incl...
|
|
-
|
|
I treat Scalability and Performance like a two-side coin whenever the SQL Server operability consulting is involved. The Scalability and Performance is guaranteed when the reliable storage is configured at the hardware level. In general, the storage conf...
|
|
-
|
|
As a DBA we can relate ''SQLAzure'' as Database As A Service, nothing but offering database hosting and in Microsoft terms its relational database in the cloud!
If you know about SQL Data Services (SQL2008 days) then SQLAzure is the one which was built on ...
|
|