Welcome to SqlAdvice Sign in | Join | Help

Browse by Tags

All Tags » Raves   (RSS)

Full Text Indexing Overhead

Posted Friday, November 09, 2007 3:26 PM by michael.k.campbell
I think that there's a tendency among DBAs and SQL Server wonks to be a bit dismissive of Full Text Indexing. I think that in a lot of cases people tend to think of it in terms of adding significant overhead. For a long time I actually looked at it as Read More...
0 Comments
Filed under: ,

SQL Server 2005 SP2 Improvements

Posted Monday, February 19, 2007 11:02 AM by michael.k.campbell
If you do a lot of scripting, SP2 for SS 2005 is going to be a must-have. Luckily it was just released . Here are some of the BIG improvements for people who like to script a lot: Generate Script Wizard . You can now specify that the scripted objects Read More...
0 Comments
Filed under: ,

Using Virtualization to fight ... Virtualization

Posted Thursday, April 20, 2006 4:54 PM by michael.k.campbell
VPN Software should come with big warning labels: "WARNING: Does not play well with others." As a consultant I frequently need to gain access to remote networks via VPN. This means I'm frequently hosing myself by installing yet another VPN client. That, Read More...
1 Comments

Recent Book Reviews

Posted Thursday, April 13, 2006 3:44 PM by michael.k.campbell
I recently did some book reviews for the ASP Alliance (which will be throwing up a SQL Server Reporting Services portal in the near future). The reviews are for (links are to the reviews): Hitchhiker's Guide to SQL Server 2000 Reporting Services and The Read More...
0 Comments
Filed under: ,

SQL Server Unit Testing: Sprocs

Posted Thursday, April 06, 2006 9:41 AM by michael.k.campbell
As a consultant, it's not uncommon for me to need to rewrite a poorly performing query or sproc without a full understanding of the underlying biz rules or context. Improved performance is the stated goal, but data fidelity is implied as critical. Enter Read More...
1 Comments

Shout Out: Paolo Pignatelli

Posted Thursday, March 02, 2006 3:30 PM by michael.k.campbell
Paolo has started up his own blog on SqlAdvice. Make sure to check it out and subscribe. The focus of his blog will be on Experimental SQL technologies, including AI and self generating SQL entities. Should be a great ride. Share this post: email it! Read More...
0 Comments
Filed under: ,

SQL Server 2005 fixes WITH NOCHECK scripting bug

Posted Tuesday, February 21, 2006 9:41 PM by michael.k.campbell
In SQL Server 2000, if you use Enterprise Mangler to script your tables, you need to watch out that your constraints don't get turned off. For example, here's a snippet generated from the Northwind.dbo.Employees table (just using the right click > Read More...
9 Comments
Filed under: ,

Mikeey Likes it

Posted Friday, February 17, 2006 10:05 PM by michael.k.campbell
I've just stumbled upon some very good news, in the form of two books: 1) Inside Microsoft SQL Server 2005: The Storage Engine - Kalen Delaney 2) Inside Microsoft SQL Server 2005: T-SQL Programming -Itzik Ben-Gan Kalen Delany's Inside Microsoft SQL Server Read More...
0 Comments
Filed under:

BookPool.com wins

Posted Friday, July 01, 2005 11:28 AM by RepeatableRead
I've got a new project coming up that Involves SQL Server 2005 reporting services. I've got a good handle on the basics, but the project will be on a tight deadline, and I'd like to have as much 'backup' as possible, so I went out to Amazon.com to find Read More...
1 Comments
Filed under: ,

SQL Server 2005 Release Date

Posted Tuesday, June 07, 2005 7:33 AM by RepeatableRead
Microsoft's Paul Flessner just sent out an email to all of the official Yukon Beta Testers: SQL Server 2005 will ship the week of November 7, 2005. Very cool news. One of my favorite new features: The Oracle Conversion Wizard... muhahahah. Share this Read More...
0 Comments
Filed under: ,

Shout Out: Bill Swartz

Posted Wednesday, April 13, 2005 8:29 PM by RepeatableRead
Welcome to SqlAdvice's newest blogger. Read More...
1 Comments
Filed under: ,