Category Archives: Tool

Denali – Day 27: System Center Advisor (aka ‘Atlanta’)

Denali – Day 27: System Center Advisor (aka ‘Atlanta’) As Microsoft is working more on Cloud base system, on that basis Microsoft has introduced a Tool for sql server called “System Center Advisor – SCA – aka Atlanta. Its internet … Continue reading

Posted in Denali, Performance Tuning, Tool | Tagged | Leave a comment

Denali – Day 26: Tool: Power View- Reporting Power View (Aka Crescent)

Denali – Day 26: Tool: Power View -Reporting Power View (Aka Crescent)   If you are good with: Xls Pivot table Power point   And you are on administration position to get reports and want to get stats. Power View … Continue reading

Posted in Denali, SSRS, Tool | Tagged , , | Leave a comment

Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)

Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)   MDS and Best Practice Analyzer new features were introduced in sql server 2008 R2, System Health Session – Introduced in Sql server 2008 in Denali Microsoft tried to … Continue reading

Posted in Denali, Tool | Tagged , | Leave a comment

Denali — Day 11: SSMS enhancement

Denali — Day 11: SSMS enhancement SSMS is a separate tool now, and it has enhanced features on it. This helps developer/DBA to manage the system efficiently. Like IntelliSense/Debug is introduced in sql server 2008 now in Denali it has … Continue reading

Posted in Denali, Tool | Tagged , | Leave a comment

Denali — Day 8: Startup Parameter

Denali – Day 8: Startup Parameter Startup Parameters means you are providing the parameter to sql server at the start of sql server, what needs to assign internally, by default you must have to provide following 3 parameters -d: Specify … Continue reading

Posted in Denali, Tool, Whats New | Tagged , | Leave a comment

Find Login in Active Directory

Find Login in AD Many times we require to know if particular login is a part of ad user group. Or sometimes we need to know a AD group and wanted to know who all logins are part of it. … Continue reading

Posted in Computers and Internet, Others, Tool | Tagged | Leave a comment

Miscellaneous Info

Some undocumented and important stuff   DMV: dbcc showcontig – index_physical_stats will scan complete index pages even if you use where clause Backup : uses 960k speed can reduce to 64k. Virtual File Space … for 32 bit system. Default big … Continue reading

Posted in DMV, Experts, General, Others, Tool | Tagged , , | Leave a comment

SQL Server Migration Assistant v5.0

I blog about mysql to sql server migration lastly here Today found very good migration tool Free Downloads: 1. SSMA for Access v5.0 2. SSMA for MySQL v5.0 3. SSMA for Oracle v5.0 4. SSMA for Sybase v5.0 Ref: http://blogs.technet.com/b/dataplatforminsider/archive/2011/04/28/sql-server-migration-assistant-v5-0-is-now-available.aspx

Posted in Migration, Tool | Tagged , | Leave a comment

unistall sql server completely (Must Read)

Everyone know how to uninstall sql server very easy : control panel -<Add remove programs ->sql server some times you can also uninstall using setup cd/setup dump. found a very great forum answer which shows how to unistall sql server … Continue reading

Posted in Add/remove, General, Installation, Software, Tool, What I learned today | Tagged | Leave a comment

Mirroring

As discussed about Disaster Recovery and High Availbility topic here continue on this. today would like to discuss some more information about mirroring. As stated in my ealier post about mirroring, today I would like to write about how to conifigure … Continue reading

Posted in Disaster Recovery, General, High Avaliability, Installation, Tool, Webcast, What I learned today, Whitepapers | Tagged | Leave a comment