Tag Archives: Tool

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 16: Tool: Database Recovery Advisor –SSMS tool

Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool As blogged on “Denali – Day 11: SSMS enhancement” about Features added on SSMS, now you can restore a page using SSMS, to add to it SSMS has another tool … Continue reading

Posted in Backup and Restore, Denali | 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

Basics QA on Extended Event

Basics QA on Extended Event     I am learning Extended Event so this is my first blog on extended event, There is a great whitepaper on XEvent by Jonathan Kehayias. Q1. What is extended event? A1. It is a … Continue reading

Posted in Troubleshooting | Tagged , , | Leave a comment

Performance Tunning Part 2

After checking on the net found that there are lots of lots of good stuff (queries) already describe the performance related information, so I would like the share and refer some of the very good site. I have already blog … Continue reading

Posted in DMV, Lock/Blocking, Performance Tuning, Whitepapers | 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