Welcome to SqlAdvice Sign in | Join | Help

Browse by Tags

All Tags » Misc   (RSS)

Microsoft's direction with SQL Server Tools

Posted Thursday, November 08, 2007 9:42 PM by michael.k.campbell
I'm with Stephen Wynkoop on this one - I'm not sure I'm too hip on Microsoft's emerging direction to divide SQL Server Tools into Developer and Admin Roles. Stephen just posted an editorial based on an interview that he had with Matt Nunn, and points 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: ,

SQL Mag Article - Spotlight on SQL Server

Posted Monday, February 12, 2007 9:24 AM by michael.k.campbell
Just an FYI that my latest product review for SQL Server Magazine is in the February Edition. (My February edition only just BARELY showed up in the mail...). In this review I take a look at Quest Software's Spotlight on SQL Server 5.7 . It's a decent Read More...
0 Comments
Filed under:

SQL Team Article

Posted Monday, January 22, 2007 2:05 PM by michael.k.campbell
Quick heads-up on a recently published article I did for SQLTeam.com . The article examines SQL Server Integration Services' Fuzzy-Lookup transformation for use in data-cleansing routines. If you're interested, head over to the article - there's even Read More...
0 Comments
Filed under: ,

AspAlliance Article

Posted Thursday, August 24, 2006 5:33 PM by michael.k.campbell
If you're in to SQL Server Reporting Services, but want better/richer functionality in Word and Excel - then zip out and skim my article at the ASPAlliance: Using SoftArtisans' OfficeWriter with SQL Server Reporting Services 2005 . The article provides Read More...
0 Comments
Filed under: ,

ORDER BY and VIEWs in SS 2005

Posted Wednesday, June 14, 2006 3:20 PM by michael.k.campbell
ORDER BY has never been technically 'allowed' in a view definition. For example, the following code: CREATE VIEW dbo.[UsersByFirstName] AS SELECT * FROM dbo.[users] ORDER BY [FirstName] GO will throw an error if you attempt to run it. Books Online for Read More...
3 Comments
Filed under: ,

Yeay PostXING

Posted Friday, May 12, 2006 5:35 PM by michael.k.campbell
I love PostXING - now I've just configured it to work with the CS 2.0 upgrade that just happened on SqlAdvice. (I'm actually using the latest version of PostXING - right out of SVN - but it's working great, and setup was a breeze.) Setup was simple. I Read More...
1 Comments
Filed under: ,

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: ,

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...
10 Comments
Filed under: ,

Another Case for SET NOCOUNT ON

Posted Thursday, November 24, 2005 4:45 PM by michael.k.campbell
Dan Wahlin just posted a message to one of the lists on aspadvice about some interesting behavior that he noticed in VS 2005 - executing a sproc (against SQL Server 2000) from within VS 2005 wasn't returning the entire result set that he was expecting. Read More...
0 Comments
Filed under:

MSDE Pricing

Posted Wednesday, July 06, 2005 2:30 PM by RepeatableRead
One thing I forgot to cover in my previous 'cheet sheet' post of MSDE functionality was any mention of the price. I bring that up because it bit me in the hiney today. On aspadvice I said that MSDE wasn't free, only free-distributable by owners of certain Read More...
1 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: ,

SQL Server Personal Edition Facts

Posted Wednesday, June 01, 2005 9:55 PM by RepeatableRead
Following up on my previous MSDE Facts post, I wanted to provide the same coverage for SQL Server 2000 Personal, because it frequently gets confused, in many circles, with MSDE -- probably because it, like MSDE, is capable of being installed on non-server Read More...
1 Comments
Filed under:
More Posts Next page »