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...
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
03-13-2008
Filed under: sql server, management, webcast, bi, tools, reporting services, elearning, performancepoint, business intelligence, 2007, training, office
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...
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
02-15-2008
Filed under: sql server, management, ssms, download, demo, alert, sample, tsql, code, toolkit, management studio, snap-in
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
02-08-2008
Filed under: sql server, management, microsoft, bi, data mining, labs, development, testing, business intelligence, links, operation guide
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...
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
01-29-2008
Filed under: sql server, performance, management, indexes, windows, i/o, sysmon, disk space, usage, resource, perflib, worker threads, task manager
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 specifically to eliminate the time-consuming and...
"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 a look at how to secure your SQL Server environment...
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 allocator interface. select type, sum(multi_pages_kb...