Browse by Tags

SQL Server BI - Managing Large Datawarehouse environment, guidelines

Published 17 September 8 3:24 AM | SqlServer-QA.net

What will be the main challenge for a DBA/User to manage a large Data Warehouse (DW) environment, size does matter and also think about downtime you need to deploy whenever any patches are required. Before that you need to be perfect or well-versed with...

Filed under: sql server, performance, management, databases, reporting, business intelligence, data warehouse, readonly

Get Control - Sharepoint Management with IDERA's PointAdmin tool!

Published 29 July 8 5:10 PM | SSQA.net

Introducing Idera's Point admin toolset BETA : 10 Tools To Simplify SharePoint Management Idera is pleased to announce our new SharePoint management tool, the Point admin toolset (TM) , is now in BETA and ready for download! If you're faced with...

Filed under: sql server, management, data, beta, sharepoint, idera

Webcast: The Key to Enforcing Compliance and Standardization: Policies

Published 17 June 8 4:53 AM | SSQA.net

Free webcast is convened by IDERA Wednesday, June 25, 2008 .. | .. 11:00 AM CST | .. 12:00 PM EST "The Key to Enforcing Compliance and Standardization: Policies" While managing complex database environments, one of the most challenging objectives...

Filed under: sql server, management, mvp, key, idera, compliance, standards, policy-based

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, management, webcast, bi, tools, reporting services, elearning, performancepoint, business intelligence, 2007, training, office

SQL Server 2008: Administer multiple servers by designating configuration servers

Published 27 February 8 3:0 AM | SSQA.net

Ok, they give you new tool and in next release it has been taken away! This is similar to Surface Area Configuration tool from SQL Server 2005 and after 3 years you don't see from next release which is SQL Server 2008. How do you manage or can administer...

Filed under: sql server, management, ssms, 2008, multiple, object explorer, configuration server

SQL Server Management Studio snap-in - get alerted when executing a TSQL code!

Published 15 February 8 4:26 AM | SSQA.net

Do you like color-coded alert say when you are executing a TSQL script or code against a SQL Server instance, say if its a production server with 'red' indicator or 'green' when it is on testing platform! I have no doubt in stating the...

Filed under: sql server, management, ssms, download, demo, alert, sample, tsql, code, toolkit, management studio, snap-in

What is Business Intelligence? How to obtain complete tools suite to test?

Published 8 February 8 12:11 PM | SSQA.net

Business Intelligence (BI) - is the new term from Microsoft for all Data Warehousing & Data Mining requirement since the SQL Server 2005 version is released. Say many organization face challenges with the Data Explode, this BI offers management and...

Filed under: sql server, management, microsoft, bi, data mining, labs, development, testing, business intelligence, links, operation guide

See how Resource Governor can help you 'in action' in managing SQL Server resources?

Published 8 February 8 2:11 AM | SSQA.net

As you may be aware about new features within SQL Server 2008, one of the them is Resource Governor which is a feature than you can use to manage SQL Server workload and system resource consumption. It will enable you to specify limits on the amount of...

Filed under: application, sql server, management, blogs, security, query, 2008, resource governor

How SQL Server manages when a database is created in terms of I/O and disk usage?

Published 29 January 8 5:46 AM | SSQA.net

One of the best features you have in the SQL Server is to create database data file (additional) on fly without having a slow performance affect on existing connections. But think about how SQL Server manages to use server threads for the data file that...

Filed under: sql server, performance, management, indexes, windows, i/o, sysmon, disk space, usage, resource, perflib, worker threads, task manager

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, management, tools, jobs, idera, third party, beginners, effective, job manager

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: sql server, management, webcast, security, tools, dba, manager, idera, third party, architect

TSQL to get a quick information on detailed distribution of memory allocated

Published 10 January 8 3:4 PM | SSQA.net

By design the components that are aware of the SQL Server memory management mechanisms use the buffer pool for small memory allocations. If the allocation is bigger than 8 KB, these components use memory outside of the buffer pool through the multi-page...

Filed under: sql server, management, memory, dmv, tsql, allocated, distribution, memory_clerk

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: sql server, management, tools, jobs, idera, third party, beginners, effective, job manager

What are advantages of 64-bit system in relation to SQL Server?

Published 19 December 7 8:40 AM | SSQA.net

We have most of our database systems on 64-bit environment, but one of the application user asked the question what is the advantage of a 64-bit environment in relation to SQL Server application. I would say with the evolution of SQL Server 2005 it has...

Filed under: sql server, package, management, microsoft, server, windows, best practices, 2008, consolidation, planning, x64, 2005, advantages, policies

SQL Server: How do I identify the queries that are worth tuning?

Published 16 November 7 7:2 AM | SSQA.net

Have you ever asked this question about how do I identify the queries that worth tuning? The simple answer it is neither easy or hard to obtain such information if you have managed your SQL Server by deploying industry best practices (wherever possible...

Filed under: sql server, performance, management, microsoft, blogs, technet, dmv, dba, best practice, slow query

Guidelines for enabling indexes and online index operations

Published 8 October 7 8:50 AM | SSQA.net

As a DBA you should now how locking works with tables and how best you can make use of indexing enhancements within SQL Server 2005 version. Until SQL 2000 there was a limited availability of documentation on the guidelines even in the Books online and...

Filed under: dashboard, sql server, performance, management, indexes, databases, indexed view, monitoring

Web Server: What’s New in IIS 7 for IT Pros

Published 4 September 7 8:34 AM | SSQA.net

So what's coming wth IIS7, the overview session will highlight the key points of interests for IT Pros in Internet Information Services version 7. IIS7 modularity increases security by allowing a reduced installation footprint and creation of specialized...

Filed under: application, sql server, management, webcast, reporting, iis, pool, websites

Reporting Services setup in Vista, simple resolution

Published 22 August 7 8:23 AM | SSQA.net

Recently on our Development platform we have deployed the Vista operating system to test an application against this installation. Part of the project is to deploy reports for the users using reporting services components, I was able to fix the issues...

Filed under: sql server, management, ssrs, services, report builder, iis

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: sql server, performance, management, tools, video, idera, third party

Disable SA account on a live SQL Server2005 instance, any drawbacks?

Published 13 August 7 4:3 AM | SSQA.net

Last week I have been delegated to finalize the security standards within a set of SQL 2005 instances that are used by a customer, though it is usual chores for me to apply industry best practices. On these SQL 2005 instances in particular I was more...

Filed under: sql server, management, microsoft, security, windows, login, sa, disable, authentication, mixed