|
|
SQL Server
-
|
Have you ever thought of using data mining with children? Here's someone that did: http://sqlservercode.blogspot.com/2006/10/datamining-speech-in-sql-server-2005.html...
|
-
|
Did you know that you can contribute to MSDN documentation ? http://msdnwiki.microsoft.com/en-us/mtpswiki/default.aspx...
|
-
|
This is a must see white paper written by Robert Dorr ! I won't say more but if you are a serious dba then you've got to read this: SQL Server I/O Basics, Chapter 2...
|
-
|
Script Repository: SQL Server 2005 If you follow the above link you will find scripts that will help you manage your SQL Server. To give you an idea of what you can get from this site I included the list of topics: Buffer Cache CPU and Optimization Indexes...
|
-
|
If you are a developer then you should take a look here: MSF for Agile Software Development Process Guidance MSF for CMMI® Process Improvement and the how to: Extracting Files and Password Needed Prompts By the way, do you know that a new MSF book is...
|
-
|
According to Windows Server Division WebLog the Service Pack 2 for Windows 2003 will improve SQL Server 2005 performance by introducing some changes in Winsock API. However you won’t notice the change unless you have a server with 8 or more CPUs and multiple...
|
-
|
If you try to code a DDL managed trigger there is a small chance to have problems with the parameters of SqlTrigger attribute: Name, Target and Event. Here’s an example that works : Imports System Imports System.Data Imports System.Data.SqlClient Imports...
|
-
|
Let's take a look at the following example from Books Online: DECLARE @price money SET @price=2500.00 SELECT CatalogDescription.query(' declare namespace pd=" http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription "; <Product...
|
-
|
If you want the complete answer you should take a look at the following post What are the different cached objects in the plan cache? from the SQL Programmability & API Development Team Blog . [quote] The following caches are included in procedure...
|
-
|
If you are interested in taking the 70-431 exam you may find interesting this webcast: MSDN Webcast: Preparing for Exam 70-431 SQL Server 2005 Implementation and Maintenance (Level 200) . "... In this presentation, we help prepare you for the Microsoft...
|
-
|
If high-availability is one of your interests then you should definitely take a look at this white paper: SQL Server 2005 Failover Clustering White Paper You can find complimentary information to clustering topics from Books Online such as planning, implementing,...
|
-
|
Thursday, September 7, 2006 at 9:30am ) Pacific Time, Paul A. Mestemaker II, Program Manager in Microsoft SQL Server team will deliver the following webcast TechNet Webcast: Using the SQL Server Upgrade Advisor and New SQL Server 2005 Best Practices Analyzer...
|
|
|
|