November 2003 - Posts

Performance Difference T-SQL vs. CLR

Niels Berglund shows us an example on SqlJunkies WebLogs
posted Thursday, November 27, 2003 8:52 AM by admin with 1 Comments

Do you run a Movabletype blog?

Originally posted here: http://www.dslreports.com/shownews/36011

Do you run a Movabletype blog?
spam vulnerability
One of the most popular blog packages, Movabletype, comes with a utility, not even used in the default configuration, that can (and is) being hijacked by spammers trying to sell Viagra© to turkeys. If you operate a Movabletype blog, please make sure you read the front page of movabletype.org urgently.

If you get a spam email that says, in its message body, "... has sent you a link .. Title: .. Link: ...", then please refer to its FROM address. For once, it will be correct. A courtesy email to the blog owner (visit their domain) should wake them up.

posted Wednesday, November 26, 2003 5:03 PM by admin with 1 Comments

New Fortune 1000 Corporate Web Server Survey by Port80 Software Challenges the Business Relevance of Popular Netcraft Survey

SAN DIEGO, November 24, 2003 /PRNewswire/ -- A new survey of Fortune 1000 corporate Web sites by Port80 Software, a developer of Microsoft Web server tools, challenges the business relevance of the popular Web Server Survey published by the Internet services company Netcraft.

Netcraft's November 2003 Web Server Survey claims that the Apache Web server "has a significant percentage gain" over the Microsoft Internet Information Services (IIS) Web server and now controls over two-thirds of the global Web server market. This recent survey builds on Netcraft's long-term view of Apache as holding the majority share of the Web server market.

Read More: http://www.port80software.com/surveys/top1000webservers/relevance || http://www.port80software.com/about/press/112403

posted Monday, November 24, 2003 1:42 PM by admin with 1 Comments

New Article by Alan Dean

Alan Dean has just put out his first article on DotNetJunkies:

Using Satellite Assemblies to Isolate Localised Resources
By Alan Dean
Utilizing the support in .NET for satellite assemblies is a powerful way to approach the problem of application globalization . The essential idea behind satellite assemblies is to isolate localizable resources from your main application, and from each other. If you thoroughly isolate your resources, then you will not need to recompile your application code in order to support any new culture. (Monday, November 17, 2003)

Read More     Discuss in the Forums     See More Articles

posted Monday, November 17, 2003 12:46 PM by admin with 2 Comments

New SqlJunkies Articles (Including Yukon Beta 1)

We published the following articles on SqlJunkies.com today:
 
Yukon Demo: AdventureWorks Contacts
By Jason Stowe - An Example Using SQLCLR Stored Procedures with HTTP Endpoint using HttpWebRequest/HttpWebResponse and Generated Proxy Classes
 
SQL WebBench is a stand alone browser based application that demonstrates Native SQL Web Services in Microsoft® SQL Server™ Yukon Beta 1. SQL Web Bench allows for HTTP SOAP endpoint manipulation and the ability to invoke remote SQL web services right from your browser via a WSDL XSL transform. SQL Web Bench demonstrates and exposes the raw SOAP that is sent and received from the server.
 
This step-by-step article describes how to move a database diagram that was created in SQL Server Enterprise Manager. Database diagrams are contained in the dtproperties system table of the database.
 
This article describes how to implement a callback function during the installation of the SQL Server 2000 Desktop Engine (MSDE 2000) and also discusses all the conditions that must be met to make sure the callback function runs properly.
 
Using the sp_fixindex Stored Procedure
This article discusses how to use the undocumented sp_fixindex system stored procedure to correct problems in the indexes of SQL Server system tables.
 
When you query a linked server, you frequently perform a pass-through query that uses the OPENQUERY, OPENROWSET, or OPENDATASOURCE statement. You can view the examples in SQL Server Books Online to see how to do this by using pre-defined Transact-SQL strings, but there are no examples of how to pass a variable to these functions. This article provides three examples of how to pass a variable to a linked server query.
posted Thursday, November 13, 2003 1:51 PM by admin with 2 Comments

Help Make SQL Server 2000 Best Practices Analyzer a Great Tool With your Feedback

Originally published here

posted Thursday, November 13, 2003 1:02 AM by admin with 1 Comments

Lots of Good Posts on SQL PASS Conference

http://www.sqljunkies.com/Weblog/ and New tools coming out such as SQL Server 2000 Best Practices Analyzer
posted Wednesday, November 12, 2003 12:29 PM by admin with 1 Comments

New Build - Bigger, Better, and Much More to Come

We've done it. We built a bigger, better, more generic runtime for DotNetJunkies, Sqljunkies, and ????

The base framework is almost finished, and pretty lock solid. CPU is little, RAM is little and when we're finished, the generic framework will be open.

We still have base features to add to the base framework but they will come quickly now that we've devoted our time to our online properties rather than spreading it out amoung consulting and websites.

Stay tuned - Doug, TSHAK, Russ, and I are working night and day to finish the websites ASAP. And our awesome new aquisition and technical editors are working hard on getting cutting edge content out to you on a regular basis.

See http://www.sqljunkies.com/ and http://www.dotnetjunkies.com/ for new articles, how to's, news, events, great forums, and the best bloggers out there.

posted Wednesday, November 12, 2003 2:37 AM by admin with 1 Comments

Yukon: Has anyone Installed Yukon Yet?

As you know we've launched SQL Junkies now and we're running the Offiical Yukon Forums so if you think you can help out please help! If you have questions please post them here, we have a lot of the SQL Server team and SQL Server support staff moderating the forum since Microsoft can't officially support the Yukon!

And don't forget to check out the blogs they're really starting to get active!

Thanks

posted Sunday, November 09, 2003 9:16 PM by admin with 1 Comments

Distributed Computing, Large Databases and SQL Server, Grid Computing and Much More

Originally posted here: http://sqljunkies.com/weblog/donnymack/posts/382.aspx

The guy is just brilliant so I had to spread the knowledge

Great Presentations on many different cutting edge topics::http://research.microsoft.com/users/gray/jimgraytalks.htm

BIO

Jim Gray is a "Distinguished Engineer" in
Microsoft's Scaleable Servers Research Group
and manager of Microsoft's Bay Area Research Center (BARC).

Jim's primary research interests are in databases and transaction processing systems. His current work focuses on building supercomputers with commodity components, thereby reducing the cost of storage, processing, and networking by factors of 10x to 1000x over low-volume solutions. This includes work on building fast networks, on building huge web servers with CyberBricks, and building very inexpensive and very high-performance storage servers.

Jim also is working with the astronomy community to build the world-wide telescope . When all the world's astronomy data is on the Internet and is accessible as a single distributed database, the Internet will be the world's best telescope. This is part of the larger agenda of getting all information online and easily accessible (digital libraries, digital government, online science, ...).

posted Saturday, November 08, 2003 6:56 PM by admin with 1 Comments

SqlJunkies WebLogs Rockin

Ok I’m a little biased but the SqlJunkies WebLogs are kicking ass (excuse my language). We are getting some seriously good posts by our Bloggers and we’re getting more new bloggers almost every day.

 

If you haven’t checked them out I highly recommend it.

posted Friday, November 07, 2003 6:37 PM by admin with 1 Comments

Yukon @ The Borland Developer Conference

Product Unit Manager of SQL Server Euan Garden talks about their experience at the Borland Conference Read More
posted Wednesday, November 05, 2003 10:48 AM by admin with 1 Comments

Red Hat Cans Linux Distribution

Interesting...

Full Story: Red Hat CEO says you should buy Windows

“Leading Linux distributor Red Hat Inc. on Monday made clear its intention to focus on the enterprise space, telling customers that it will no longer be maintaining or releasing any of the its Red Hat Linux line after the end of April 2004. “

 Red Hat Linux Migration Resource Center

More Reading

 

 

posted Wednesday, November 05, 2003 10:37 AM by admin with 1 Comments