Data Mining with Microsoft SQL Server 2008 - Sample Chapter
Another sample chapter from Wiley, this time for one of the hot topics in business intelligence: data mining.
2010-03-02
2,579 reads
SQL Server 2008
Introducing SQL Server 2008 and 2008 R2 Integration Services
The latest release of SSIS strengthens its position as one of the primary foundations of Business Intelligence, delivering a powerful framework for solutions that combine data from disparate sources, facilitating its analysis and reporting. Join Marcin Policht as he reviews its general characteristics.
2010-02-09
3,387 reads
Performance Analysis Using SQL Server 2008 Activity Monitor Tool
While looking through the new features and improvements in SQL Server 2008 Management Studio (SSMS) we found a potentially interesting one called Activity Monitor. Database developers and Database Administrators can use Activity Monitor to get a quick overview of an SQL Server 2008 system performance. Can you give us a detailed explanation of how we go about using Activity Monitor?
2010-01-26
4,406 reads
2010-01-11
3,506 reads
2010-01-01
2,981 reads
SQL Server 2008 Administration in Action - Sample Chapter
A sample chapter on clustering from Manning Publishing. Read it to learn a bit on clustering and preview this new book.
2009-12-18
1,594 reads
Installing SQL Server 2008
The installation process for SQL Server 2008 has many different options. These options allow you more control over your SQL Server Instance configuration. Having this additional control allows you to set up your SQL Server 2008 instances out of the box with the appropriate configuration, like directory structure, accounts, etc. In this article I'll walk you through the SQL Server installation process.
2009-11-24
3,680 reads
SQL Server 2008 Upgrade Gotchas & Fixes
Preparation for upgrading SQL Server 2005 production database servers to SQL Server 2008, I tested upgrade in dev/test env.
2009-11-17
9,705 reads
Using SQL Server 2008 Reporting Services with SAP NetWeaver Business Intelligence
This paper discusses the integration of SAP NetWeaver BI ® with Microsoft ® SQL Server ® 2008 Reporting Services (SSRS). The paper provides an overview of using the Reporting Services SAP Netweaver BI data provider and related query designer, to build high quality reports against SAP NetWeaver BI sources. For Reporting Services users who are new to working with SAP NetWeaver BI, this paper will help you connect and build datasets. For users already familiar with SAP NetWeaver, the paper will show how some of that system’s notable features can be leveraged in Reporting Services reports. It also presents some tips and tricks that can help you make the most of the integration between the two products.
2009-11-02
2,111 reads
2009-10-19
3,601 reads
Blogs
First Time Speaking with a Mask at an Event
By DataOnWheels
Over the past couple of months, I have started losing my ability to talk...
A New Word: Apolytus
By Steve Jones
apolytus– n. the moment you realize you are changing as a person, finally outgrowing...
Tired of Tedious SQL Queries? AI Tools Can Automate The Boring Parts
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
Forums
Do you listen to music when you work?
Comments posted to this topic are about the item Do you listen to music...
Slow update on temp table
I have a job running each night starting at 4:30AM and usually finishing at...
Table Partitioning - remove null range
hi guys, I have a partitioned table AM_ITM_INSTNC_MSS and I want to get...
Question of the Day
Read Only Replica in SQL Server Standard
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers