Browse by Tags

All Tags » tools (RSS)
SQL Server 2008 Learning Live Webcast series from IDERA - win SQL admin toolset
Published 19 August 8 9:27 AM | SSQA.net
Date: Wednesday, August 20, 2008* Time: 4 PM Eastern | 3 PM Central | 1 PM Pacific Speaker: SQL Server MVP, Hilary Cotter Attend and win! Find out how! *Want to attend but can’t make this date? No worries! Each webcast will be archived for up to 6 months...
Filed under: , , , , , ,
SQL Server 2008 - Performance Studio
Published 20 June 8 11:50 AM | SSQA.net
I've been looking at this new feature of SQL Server 2008 in order to demo it to customers, and I have to say it's pretty cool ! Along with Resource Governor and compression, it's one of my favourite new features and a good reason to consider...
Filed under: , , ,
SQL Server: PERFMON counters to identify server utilization data
Published 18 June 8 7:21 AM | SSQA.net
Recently I have been involved to carry over an assesment of server utilization on the SQL estate farm (nearly 150+) instances, as it stands it is not an easy job to obtain the results when you have no influence on accessing required information on a shared...
Filed under: , , , , ,
Indexing Strategies
Published 17 June 8 2:2 AM | SSQA.net
I attended a SQL Server User Group meeting earlier this year and heard a presentation about favourite DMV's. Mentioned in the discussion was sys.dm_db_index_usage_stats and that got me thinking about indexing strategies. I have been involved in performance...
Filed under: , ,
SQL Server 2005 Performance Dashboard
Published 12 June 8 6:25 AM | SSQA.net
I've had one or two requests recently to set up the Performance Dashboard reports on SQL Server so I've created this blog post to step through the process. Firstly, the Performance Dashboard was created to allow customers and support engineers...
Filed under: , , ,
SQL Server troubleshooting tools PSSDiag, SQLDiag, SQLNexus, RML Utilities and ReadTrace: which one to choose?
Published 5 June 8 2:50 AM | SSQA.net
Not alone with SQL Server you would be able to identify the root cause of a performance issue or to monitor any kind of activity. As you may be aware SYSMON (PERFMON) and PROFILER will help to some extent of finding offending processes on the SQL Server...
Filed under: , , , , , , , , , , ,
Did You Know? Free SQL Server Troubleshooting Tools
Published 17 May 8 10:47 PM | SSQA.net
I'm very excited about the new Management Data Warehouse coming in SQL Server 2008 (which was called Performance Studio at one point), but keep in mind there are lots of available tools in the current versions. One of the students in my class last...
Filed under: , , ,
IDERA's new tool - SQL admin toolset: public BETA available
Published 7 April 8 2:57 AM | SSQA.net
IDERA's tools are helpful for the Database Management in specific to DBAs and in this fashion they are coming up with new tool called, SQL Admin toolset, check the following: NEW! SQL admin toolset: Incredibly useful tools for SQL Server people 24...
Filed under: , , , , , , , ,
SQL Server BI and Performance Point Server 2007 - good match
Published 13 March 8 5:10 AM | SSQA.net
Another tool within BI platform to use when you have the huge farm of Analysis Services data warehousing & mining database setup at your end. So the provision of BI within SQL Server 2005 is a complete enterprise-ready and scalable data warehouse...
Filed under: , , , , , , , , , , ,
SQL Server Upgrade Advisor Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Published 13 February 8 5:2 AM | SSQA.net
One of the client referred about the error during the execution of Upgrade Advisor: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Initial thoughts lead to checking the SQL Server timeout...
Filed under: , , , , , , ,
SQL Server Lockdown - Step by Step procedure
Published 13 February 8 2:31 AM | SSQA.net
Do you want to lockdown your SQL Server environment? Hope you dont'! Though it is not a good practice or recommendation to perform, but will atleast prove how far your SQL Server environment has securit compliance as per the industry best practices...
Filed under: , , , , , , , , , ,
Best way to deploy SQL Server 2005 with SAN
Published 28 January 8 2:1 AM | SSQA.net
If it is a first time you are deploying the SQL Server 2005 on a SAN, then there are few things you need to be considered that will be raised by installations that are either deploying SQL Server for the first time or are upgrading to SAN from direct...
Filed under: , , , , , , , , , , , , ,
Idera giving holiday gift to SQL Server users - free copy of SQL Job Manager - extended till Jan 31st
Published 19 January 8 4:3 AM | SSQA.net
A special “holiday gift” offer for a free copy of SQL job manager at http://www.idera.com/ Offer expires December 31st. SQL job manager is Idera's next generation solution for scheduling and managing SQL Server jobs across the enterprise. Designed...
Filed under: , , , , , , , ,
SQL Server Security & Compliance - webcast by IDERA
Published 18 January 8 8:58 AM | SSQA.net
"SQL Server Security & Compliance" Sponsored by Idera : SQL Server security and compliance go hand in hand. With the changes in legislation and new requirements to ensure that database platforms such as SQL Server are secure we will take...
Filed under: , , , , , , , , ,
Whitepaper on Predeployment I/O Best Practices, plus a few urban legends around SQL Server IO
Published 10 January 8 4:38 PM | SSQA.net
There's a new whitepaper on TechNet that I've just come across (even though it was published 6 months ago!) called Predeployment I/O Best Practices . It's really good - discussing the following: Guidelines for determining I/O capacity Disk...
Filed under: , ,
Snap-in failed to initialize, Name Microsoft SQL Enterprise Manager: CLSID : {00100100-1816-11D0-8EF5-00AA0062C58F}
Published 8 January 8 11:1 AM | SSQA.net
Few times I get such error Snap-in failed with a long CLSID string mentioned in the subject above. On this client machine previously I have SQL Server 2000 tools and recently installed 2005 version too, instantly error: Snap-in failed to initialize Name...
Filed under: , , , , ,
Idera giving holiday gift to SQL Server users - free copy of SQL Job Manager
Published 27 December 7 4:3 AM | SSQA.net
A special “holiday gift” offer for a free copy of SQL job manager at http://www.idera.com/ Offer expires December 31st. SQL job manager is Idera's next generation solution for scheduling and managing SQL Server jobs across the enterprise. Designed...
Filed under: , , , , , , , ,
Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?
Published 12 December 7 12:7 PM | SSQA.net
While we were in Barcelona we sat down with Richard Campbell and Greg Hughes from RunAs Radio to record a 1/2 hour interview on SQL Server 2008. We touch on a ton of different features (look at the number of Categories I've tagged this with!) and...
Filed under: , , , , , , , , , , , , , ,
How to read Database transaction log in SQL Server?
Published 27 September 7 7:13 PM | SSQA.net
Another frequently asked questions in the forums and newsgroups, I have seen similar ones recently. I believe most of the newbie users ask this question and even more as interview based questions. So here is the catch in order to accomplish the task,...
Filed under: , , , , , , , , , ,
Life of Simon, SQL Server DBA - hilarious video
Published 17 August 7 2:43 AM | SSQA.net
Also see Idera's hilarious new video! "Life of Simon, SQL Server DBA" http://www.youtube.com/ideradotcom View Video Format: ??? Duration: --:--...( read more ) Read More...
Filed under: , , , , , ,
More Posts Next page »