SqlServer-QA.net

Make information archival a component of your SharePoint content lifecycle management strategy Organizations are generating large volumes of mission-critical information on Microsoft SharePoint. As hundreds of gigabytes or even terabytes of unstructured content are being accumulated in SQL Server, managing, accessing, and storing this information ...

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 Data partitioning & Data lifecycle within that DW environment.  Also buidling up ...

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 SharePoint sprawl, out-of-control backups and compliance issues, Get Control! today using Point admin ...

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 IT executives, managers and administrators face is enforcing the company's ...

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 platform you can set, with the  features and functionality you need to ...

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 the multiple servers with the configuration settings & setup! It is changed now where ...

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 new 'Server Alert' snap-in for SQL Server Management Studio from Danny in SQLBlogcasts will do the rest of job ...

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 development tools for IT department and Business segment within your organization with ...

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 CPU and memory that incoming application requests can use and it is configurable in SQL Server ...

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 is used for the databases and how big disk queue length in terms of I/O ...