-
Utilize SSAS for data predictions and classification using Excel
Using Excel as a tool for data mining and predictions is very powerful. Learn how to take advantage of SSAS in SQL Server 2005 with Microsoft Office Excel 2007.23 Dec 2008
-
The sqlcmd utility in SQL Server
The sqlcmd utility in SQL Server is a handy tool for running ad hoc queries or creating script files to perform routine tasks or automate procedures. Robert Sheldon provides a guide to getting star...18 Dec 2008
-
Top 10 SQL Server Tips of 2008
Here are the top 10 SQL Server tips of 2008. From stored procedures that determine table and log file size to the basics of DATETIME and SMALLDATETIME in SQL Server 2005 and date/time value data co...16 Dec 2008
-
Tutorial: Performance tuning SQL Server via queries, indexes and more
If you are looking to tune your SQL Server in the hopes of improving performance, this tutorial has the expert advice you need. Learn how to optimize queries, employ the best indexing practices, ut...09 Dec 2008
-
A guide to basic new features in SQL Server Management Studio 2008, part 1
SQL Server Management Studio 2008 comes packed with the new features that have been on your wish list, including syntax help, word completion and a list of stored procedure parameters.09 Dec 2008
-
How to create a SQL inner join and outer join: Basics to get started
When you're querying a SQL Server database and want to pull related data from more than one table, you'll need to create a join, and here's how.03 Dec 2008
-
Tutorial: SQL Server indexing tips to improve performance
Significantly improve your SQL Server performance with this tutorial on proper indexing choices, configuration and design.03 Dec 2008
-
SQL Server virtualization pros and cons: Weigh the performance impact
Virtual machines in the SQL Server world can save money and power. But what's the performance impact on I/O, RAM, memory and your Windows operating system? To help you decide whether virtualization...02 Dec 2008
-
data mining
Data mining is the analysis of data for relationships that have not previously been discovered. For example, the sales records for a particular brand of tennis racket might, if sufficiently analyz...01 Dec 2008
-
SQL Server Service Broker Tutorial and Reference Guide
Discover the basics of the SQL Server Service Broker, including a general overview on how this addition to SQL Server works.01 Dec 2008