SQL Server Magazine UPDATE, October 27, 2005

Learn where to get the latest info about SQL Server 2005 launch events, read about upcoming BI features in Microsoft Office 12, demystify T-SQL 2005 debugging, and more!

ITPro Today Contributors

October 26, 2005

27 Min Read
ITPro Today logo in a gray background | ITPro Today

Subscribe to SQL Server Magazine: http://lists.sqlmag.com/t?ctl=17C8A:285886

To ensure that future email messages you receive from SQL Server Magazine UPDATE aren't mistakenly blocked by antispam software, be sure to add [email protected] to your list of allowed senders and contacts.

This Issue Sponsored By
This email newsletter comes to you free and is supported by the following advertisers, who offer products and services that might interest you. Please take a moment to visit these advertisers' Web sites and show your support for SQL Server Magazine UPDATE.

PLAY IDERA 5IQ TODAY AND WIN!
    http://lists.sqlmag.com/t?ctl=17C90:285886

Rapid Database Restoration Using LiteSpeed
    http://lists.sqlmag.com/t?ctl=17C85:285886

ALERT: "How Hackers Launch Blind SQL Injection Attacks"
    http://lists.sqlmag.com/t?ctl=17C83:285886

Microsoft ASP.NET Connections Conference
    http://lists.sqlmag.com/t?ctl=17C92:285886

October 27, 2005

1. Perspectives

  • Launch Events: A Free Lunch

2. SQL Server 2005 Watch

  • SQL Server 2005: Ready to Launch

3. News & Views

  • Microsoft to Add Business Intelligence to Office 12

  • Results of Previous Instant Poll: Home Databases

New Instant Poll: Express Hobbies

4. Events and Resources

  • Get Ready for the SQL Server 2005 Roadshow in Europe--Get the facts about migrating to SQL Server 2005!

  • Two Minute SQL Server Stumpers

  • XML 2005--The reliable source for everything XML!

  • All High Availability Solutions Are Not Created Equal--How Does Yours Measure Up?

5. Featured White Paper

  • Dashboard Development and Deployment--A Methodology for Success

6. Peer to Peer

  • Hot Tip: Loading Text Into Analysis Services

  • Hot Article: Demystifying Debugging in SQL Server 2005

  • In a Nutshell: A Week in London

  • Hot Threads

7. Announcements

  • Become a VIP Subscriber!

  • The Exchange & Outlook Administrator Newsletter

8. New & Improved

  • Give Users Access to Analysis Services Cubes

Sponsor: PLAY IDERA 5IQ TODAY AND WIN!
Test your knowledge of SQL Server 2005--you could win $100 a day or a $2005 grand prize! How it works: Sign up at www.idera5iq.com and answer a trivia question based on SQL Server 2005. Play every day! The more you play, the more you could win! One $100 winner will be chosen randomly each day from all correct answers for that day. We'll email you if you win! At the end, we'll choose one $2005 grand-prize winner from all players! Idera 5IQ online trivia game is sponsored by Idera, NEC America, Scalability Experts & SQLServerCentral.com. Sign up now to play Idera 5IQ!
    http://lists.sqlmag.com/t?ctl=17C90:285886

1. Perspectives


Launch Events: A Free Lunch by Brian Moran, [email protected]

Eleven days and counting to the biggest SQL Server release of all time. Are you going to one of the official Microsoft launch events? Microsoft does launch events all the time. I've known for months and months that Microsoft would sponsor multiple launch events for SQL Server 2005. But it wasn't until recently that I had a good sense of how BIG Microsoft was trying to make these events. Many of the larger events expect more than 3000 attendees, and I've heard that some events are expecting as many as 5000 people. I guess there's plenty of money in the party budget when you haven't shipped for a while.

The events are free, but will feature some great content. Many of the events will also include speakers from the SQL Server development team. And every event has been stocked with top-notch speakers and a large number of people at "Ask the Experts" booths to field questions about the new release.

3000+ attendees at an event might sound like a lot of open spaces, but you might have to hurry to get a spot. The first launch event, scheduled for November 7 in San Francisco, is already full. Detroit is full too. But the last time I checked, the other cites still had availability.

Perhaps you're somewhat new to SQL Server land? I've been waiting for SQL Server 2005 for quite a while, and I'm excited that launch time has finally arrived. Of course, it's just my luck to live outside of Washington DC, which is where the very LAST launch event is scheduled, so I'm stuck waiting until January 11 to attend the big party.

Don't live near one of the 15 major launch events? Don't fret--there are almost 40 smaller events scattered around the United States (I'll update you on international events as I learn about them), and you can find information about them at http://lists.sqlmag.com/t?ctl=17C8E:285886 .

BTW, everyone who attends will receive a free copy of SQL Server 2005 and Visual Studio 2005. Free event, free software--and yes, lunch is included. Who said there's no such thing as a free lunch?

Microsoft has published plenty of information about its major launch events at
    http://lists.sqlmag.com/t?ctl=17C87:285886

Rapid Database Restoration Using LiteSpeed
LiteSpeed for SQL Server with Object Level Recovery (OLR) enables you to rapidly recover only the specific database objects that you want, without having to generate native SQL Server commands. From stored procedures and users to indexes and primary and foreign keys, retrieve only the objects you need. Now you can eliminate entire database restores through rapid, Object Level Recovery of single stored procedures. Only from LiteSpeed and Quest Software. Download Your Free Trial Today.
    http://lists.sqlmag.com/t?ctl=17C85:285886

2. SQL Server 2005 Watch


SQL Server 2005: Ready to Launch
Amid the flurry of anticipation surrounding the upcoming launch of SQL Server 2005 on November 7, database professionals are inundated with news about the new release, its features, and its benefits. To help customers wade through this sea of information, Microsoft has created a portal page that organizes links to various types of SQL Server materials. Customers can easily see how to find articles, product demos, Webcasts, white papers, and e-learning opportunities. To find the SQL Server 2005 information you're seeking, go to the Introducing SQL Server 2005: Ready to Launch site at
    http://lists.sqlmag.com/t?ctl=17C8B:285886

Sponsor: ALERT: "How Hackers Launch Blind SQL Injection Attacks"
The newest web app vulnerability: Blind SQL Injection! Even if your web application does not return error messages, it may still be open to a Blind SQL Injection Attack. Blind SQL Injection can deliver total control of your server to a hacker giving them the ability to read, write and manipulate all data stored in your backend systems! Download this *FREE* white paper from SPI Dynamics for a complete guide to protection.
    http://lists.sqlmag.com/t?ctl=17C83:285886

3. News & Views


  • Microsoft to Add Business Intelligence to Office 12


    by Paul Thurrott, [email protected]

On October 23, Microsoft revealed that it would add its business intelligence (BI) technologies into the next version of Microsoft Office, currently known as Office 12 and due in late 2006. Additionally, next month the company will release a new BI server product, called Microsoft Office Business Scorecard Manager 2005 and code-named Maestro.

"One way to increase the impact that people can have in an organization is to give them access to the information they need," said Jeff Raikes, president of the Microsoft Business Division. "Until now, BI software has been too complex, costly, and disconnected from the software tools people use every day to do their jobs. But the investments we're making in Microsoft Office, from significant extensions in existing products such as Excel and SharePoint, to new server investments such as the Office Business Scorecard Manager, will make BI and the business insights gleaned from it more pervasive, thereby enhancing the impact of people throughout an organization, which leads to greater overall business success."

New BI connectivity features in Office 12 will maintain persistent connections between Excel spreadsheets and server-based data sources. New server-based Excel functionality, called Excel Services, will help users "secure, share, and manage spreadsheets" on the server and let users view spreadsheets either in a Web browser or locally on the PC desktop. And new SharePoint/SharePoint Portal features will help users easily create Web dashboards that combine data and charts from numerous back-end data sources.

Microsoft says that these new BI features, coupled with Microsoft's historically low prices and mainstream availability, will fundamentally change the BI landscape, making it a collaborative, rather than individual, activity. Previously, businesses had to perform complex and costly BI activities outside of the usual business process structure. BI competitors, such as SAP and Oracle, however, note that Microsoft is late to the game, while offering fewer features.

Results of Previous Instant Poll: Home Databases
"What do you use at home for a database?" Here are the results from the 82 votes (deviations from 100 are due to a rounding error):

  • 12% SQL Server Express

  • 12% MSDE

  • 39% Microsoft Access

  • 12% Another database

  • 24% I don't use databases at home

New Instant Poll: Express Hobbies
"Who do you know who would use SQL Server 2005 Express to create "hobby" databases (e.g., inventory of music CDs)?" Go to the SQL Server Magazine home page ( http://lists.sqlmag.com/t?ctl=17C95:285886 ) and submit your vote for

  • I'd use it

  • My kids would use it

  • My significant other would use it

  • My friends would use it

  • I can't imagine anyone I know using it

4. Events and Resources


Get Ready for the SQL Server 2005 Roadshow in Europe--Get the facts about migrating to SQL Server 2005!
SQL Server experts will present real-world information about administration, development, and business intelligence to help you implement a best-practices migration to SQL Server 2005 and improve your database-computing environment. Receive a one-year membership to PASS and one-year subscription to SQL Server Magazine. Register now.
    http://lists.sqlmag.com/t?ctl=17C81:285886

  • Two Minute SQL Server Stumpers


Get prepared for your next interview, or get a few good questions to ask your next DBA candidate. SQLServerCentral.com has compiled our famous Question of the Day into a small pocket book that is a great reference guide, study aid, or just for stump-the-DBA fun. Get your copy now at:
    http://lists.sqlmag.com/t?ctl=17C8D:285886

  • XML 2005--The reliable source for everything XML!


XML 2005, produced by IDEAlliance, where IT professionals gather to review the latest in XML-related technologies and applications. Hear in-depth talks from industry leaders. Visit the expo floor for the most advanced products being offered today. Complimentary expo pass offered until 11/7!
     http://lists.sqlmag.com/t?ctl=17C93:285886

  • All High Availability Solutions Are Not Created Equal--How Does Yours Measure Up?


In this free, on-demand Web seminar you'll get the tools you need to ensure your systems don't go down. You'll learn what solutions help you take preemptive, corrective action without resorting to a full system failover, that perform a non-disruptive, automatic switchover to a secondary server in extreme cases.
    http://lists.sqlmag.com/t?ctl=17C7E:285886

  • See the complete Windows IT Pro Network guide to Web and live events.


    http://lists.sqlmag.com/t?ctl=17C91:285886


  • Dashboard Development and Deployment--A Methodology for Success


Business information carries little value unless it reaches the right person at the right time. This free white paper tells you what you need to know to remain competitive while improving the speed and quality of decision-making. Learn how a well-designed dashboard can provide critical information to decision makers, enable them to monitor the health of your organization and bring immediate ROI to your business.
    http://lists.sqlmag.com/t?ctl=17C82:285886

6. Peer to Peer


  • Hot Tip: Loading Text Into Analysis Services


    by Microsoft's SQL Server Development Team, [email protected]

I have a string column in a Fact table that I want to show up in my MDX queries. Although I'd normally use member properties for this functionality, because of a data warehousing consideration, I can't go that route. How can I get the column into MDX as a string so that it will show up as a string in my analysis cubes?

  • Read the answer to this question today at


    http://lists.sqlmag.com/t?ctl=17C7F:285886

  • Hot Article: Demystifying Debugging in SQL Server 2005


To debug a T-SQL stored procedure in SQL Server 2000, you use Query Analyzer. You simply right-click the stored procedure and choose Debug. In SQL Server 2005, SQL Server Management Studio replaces Query Analyzer. It's logical to assume that to debug a T-SQL stored procedure in SQL Server 2005, you simply right-click a stored procedure and select Management Studio's debug feature. Unfortunately, it's not that straightforward. A debug option is nowhere to be found. In his November feature article "Demystifying Debugging in SQL Server 2005," Niels Berglund shows you how to use the Visual Studio 2005 development environment to debug a stored procedure. Read this article today and post your comments at
    http://lists.sqlmag.com/t?ctl=17C80:285886

  • In a Nutshell: A Week in London


Although he's suffering from jetlag, In a Nutshell author Kevin Kline reflects on the joys of visiting London and particularly in meeting with customers. In this week's installment "A Week in London," Kevin explains that he loves hearing what high-end SQL Server users are working on--and what constraint they toil under. What are their problems? Where are they feeling pain? Where do they spend much of their time? Read the blog today and let Kevin know about your SQL Server pain points today at
    http://lists.sqlmag.com/t?ctl=17C84:285886

Hot Threads: Check out the following hot threads, and see other discussions in our 30 SQL Server forums. http://lists.sqlmag.com/t?ctl=17C8C:285886

SQL Server General Discussion: SP Default Value
    http://lists.sqlmag.com/t?ctl=17C79:285886
T-SQL: Script Database and Objects in T-SQL
    http://lists.sqlmag.com/t?ctl=17C78:285886
Reporting Services: Exception from HRESULT: 0x80131500
    http://lists.sqlmag.com/t?ctl=17C7A:285886
Administration: What is Query Spew?
    http://lists.sqlmag.com/t?ctl=17C7B:285886
Performance: Controller Cache Setting
    http://lists.sqlmag.com/t?ctl=17C7D:285886
Replication: Transactional Replication and Deadlock
    http://lists.sqlmag.com/t?ctl=17C7C:285886

Hot Spot


  • Microsoft ASP.NET Connections Conference


Celebrate the release of Visual Studio 2005 and SQL Server 2005 at Microsoft ASP.NET Connections, November 7-10, in Las Vegas. Every attendee goes home with a fully-licensed copy of SQL Server 2005 Standard Edition and Visual Studio 2005 Professional. Register now and attend sessions at Visual Studio Connections for FREE!
    http://lists.sqlmag.com/t?ctl=17C92:285886

7. Announcements


  • Become a VIP Subscriber!


Get inside access to ALL the articles, tools, and helpful resources published in Windows IT Pro, SQL Server Magazine, Exchange and Outlook Administrator, Windows Scripting Solutions, and Windows IT Security--that's more than 26,000 articles at your fingertips. Your VIP subscription also includes a valuable one-year print subscription to Windows IT Pro and two VIP CDs (includes the entire article database on CD). Sign up now:
    http://lists.sqlmag.com/t?ctl=17C88:285886

  • The Exchange & Outlook Administrator Newsletter


If you haven't already subscribed to the Exchange & Outlook Administrator newsletter, you're missing out on key information related to preventing serious messaging problems and downtime. This newsletter encompasses tools and solutions you won't find anywhere else to help you migrate, optimize, administer, backup, recover, and secure Exchange and Outlook. Order now:
    http://lists.sqlmag.com/t?ctl=17C86:285886

8. New & Improved


    by Dawn Cyr, [email protected]

Share Your Story and Get a T-Shirt!


Have you used a product that saved you time or made your job easier? Tell us how your favorite product solved a SQL Server problem for you, and if we print your submission in the magazine's Hands On department we'll send you a SQL Server Magazine t-shirt. Send your email today to [email protected]!

Give Users Access to Analysis Services Cubes
IQub announced OLAP Browser Version 4, an on-demand, point-and-click analysis-and-reporting solution for non-technical SQL Server users. The software turns raw data into relevant information for supporting business decisions that users can access through a direct connect or through LAN access to SQL Server Analysis Services cubes by means of a standard network connection. Remote or Internet users can access Analysis Services cubes through HTTP. The software gives users the ability to create and access local cubes for offline processing when they're working at home or on the road. Once they've got the information they need, users have the ability to edit, filter, and replicate cubes for distribution and the ability to create reports or share cube interactive views with other users for collaborative analysis. Pricing for OLAP Browser Version 4 is on a per-seat or per-desktop basis, and the software is available to download for a free trial. For more information, contact IQub at 800-680-4782 or [email protected].
    http://lists.sqlmag.com/t?ctl=17C96:285886

Contact Us


SQL Server Magazine UPDATE is brought to you by SQL Server Magazine, the only magazine devoted to helping developers and DBAs master new and emerging SQL Server technologies and issues. Subscribe today.
https://store.pentontech.com/index.cfm?s=9&promocode=eu215xdb

View the SQL Server Magazine Privacy Policy
http://www.winnetmag.com/aboutus/index.cfm?action=privacy

SQL Server Magazine is a division of Penton Media, Inc. 221 East 29th Street, Loveland, CO 80538, Attention: Customer Service Department

Copyright 2005, Penton Media, Inc. All Rights Reserved.

Subscribe to SQL Server Magazine: http://lists.sqlmag.com/t?ctl=17C8A:285886

To ensure that future email messages you receive from SQL Server Magazine UPDATE aren't mistakenly blocked by antispam software, be sure to add [email protected] to your list of allowed senders and contacts.

This Issue Sponsored By
This email newsletter comes to you free and is supported by the following advertisers, who offer products and services that might interest you. Please take a moment to visit these advertisers' Web sites and show your support for SQL Server Magazine UPDATE.

PLAY IDERA 5IQ TODAY AND WIN!
    http://lists.sqlmag.com/t?ctl=17C90:285886

Rapid Database Restoration Using LiteSpeed
    http://lists.sqlmag.com/t?ctl=17C85:285886

ALERT: "How Hackers Launch Blind SQL Injection Attacks"
    http://lists.sqlmag.com/t?ctl=17C83:285886

Microsoft ASP.NET Connections Conference
    http://lists.sqlmag.com/t?ctl=17C92:285886

October 27, 2005

1. Perspectives

  • Launch Events: A Free Lunch

2. SQL Server 2005 Watch

  • SQL Server 2005: Ready to Launch

3. News & Views

  • Microsoft to Add Business Intelligence to Office 12

  • Results of Previous Instant Poll: Home Databases

New Instant Poll: Express Hobbies

4. Events and Resources

  • Get Ready for the SQL Server 2005 Roadshow in Europe--Get the facts about migrating to SQL Server 2005!

  • Two Minute SQL Server Stumpers

  • XML 2005--The reliable source for everything XML!

  • All High Availability Solutions Are Not Created Equal--How Does Yours Measure Up?

5. Featured White Paper

  • Dashboard Development and Deployment--A Methodology for Success

6. Peer to Peer

  • Hot Tip: Loading Text Into Analysis Services

  • Hot Article: Demystifying Debugging in SQL Server 2005

  • In a Nutshell: A Week in London

  • Hot Threads

7. Announcements

  • Become a VIP Subscriber!

  • The Exchange & Outlook Administrator Newsletter

8. New & Improved

  • Give Users Access to Analysis Services Cubes

Sponsor: PLAY IDERA 5IQ TODAY AND WIN!
Test your knowledge of SQL Server 2005--you could win $100 a day or a $2005 grand prize! How it works: Sign up at www.idera5iq.com and answer a trivia question based on SQL Server 2005. Play every day! The more you play, the more you could win! One $100 winner will be chosen randomly each day from all correct answers for that day. We'll email you if you win! At the end, we'll choose one $2005 grand-prize winner from all players! Idera 5IQ online trivia game is sponsored by Idera, NEC America, Scalability Experts & SQLServerCentral.com. Sign up now to play Idera 5IQ!
    http://lists.sqlmag.com/t?ctl=17C90:285886

1. Perspectives


Launch Events: A Free Lunch by Brian Moran, [email protected]

Eleven days and counting to the biggest SQL Server release of all time. Are you going to one of the official Microsoft launch events? Microsoft does launch events all the time. I've known for months and months that Microsoft would sponsor multiple launch events for SQL Server 2005. But it wasn't until recently that I had a good sense of how BIG Microsoft was trying to make these events. Many of the larger events expect more than 3000 attendees, and I've heard that some events are expecting as many as 5000 people. I guess there's plenty of money in the party budget when you haven't shipped for a while.

The events are free, but will feature some great content. Many of the events will also include speakers from the SQL Server development team. And every event has been stocked with top-notch speakers and a large number of people at "Ask the Experts" booths to field questions about the new release.

3000+ attendees at an event might sound like a lot of open spaces, but you might have to hurry to get a spot. The first launch event, scheduled for November 7 in San Francisco, is already full. Detroit is full too. But the last time I checked, the other cites still had availability.

Perhaps you're somewhat new to SQL Server land? I've been waiting for SQL Server 2005 for quite a while, and I'm excited that launch time has finally arrived. Of course, it's just my luck to live outside of Washington DC, which is where the very LAST launch event is scheduled, so I'm stuck waiting until January 11 to attend the big party.

Don't live near one of the 15 major launch events? Don't fret--there are almost 40 smaller events scattered around the United States (I'll update you on international events as I learn about them), and you can find information about them at http://lists.sqlmag.com/t?ctl=17C8E:285886 .

BTW, everyone who attends will receive a free copy of SQL Server 2005 and Visual Studio 2005. Free event, free software--and yes, lunch is included. Who said there's no such thing as a free lunch?

Microsoft has published plenty of information about its major launch events at
    http://lists.sqlmag.com/t?ctl=17C87:285886

Rapid Database Restoration Using LiteSpeed
LiteSpeed for SQL Server with Object Level Recovery (OLR) enables you to rapidly recover only the specific database objects that you want, without having to generate native SQL Server commands. From stored procedures and users to indexes and primary and foreign keys, retrieve only the objects you need. Now you can eliminate entire database restores through rapid, Object Level Recovery of single stored procedures. Only from LiteSpeed and Quest Software. Download Your Free Trial Today.
    http://lists.sqlmag.com/t?ctl=17C85:285886

2. SQL Server 2005 Watch


SQL Server 2005: Ready to Launch
Amid the flurry of anticipation surrounding the upcoming launch of SQL Server 2005 on November 7, database professionals are inundated with news about the new release, its features, and its benefits. To help customers wade through this sea of information, Microsoft has created a portal page that organizes links to various types of SQL Server materials. Customers can easily see how to find articles, product demos, Webcasts, white papers, and e-learning opportunities. To find the SQL Server 2005 information you're seeking, go to the Introducing SQL Server 2005: Ready to Launch site at
    http://lists.sqlmag.com/t?ctl=17C8B:285886

Sponsor: ALERT: "How Hackers Launch Blind SQL Injection Attacks"
The newest web app vulnerability: Blind SQL Injection! Even if your web application does not return error messages, it may still be open to a Blind SQL Injection Attack. Blind SQL Injection can deliver total control of your server to a hacker giving them the ability to read, write and manipulate all data stored in your backend systems! Download this *FREE* white paper from SPI Dynamics for a complete guide to protection.
    http://lists.sqlmag.com/t?ctl=17C83:285886

3. News & Views


  • Microsoft to Add Business Intelligence to Office 12


    by Paul Thurrott, [email protected]

On October 23, Microsoft revealed that it would add its business intelligence (BI) technologies into the next version of Microsoft Office, currently known as Office 12 and due in late 2006. Additionally, next month the company will release a new BI server product, called Microsoft Office Business Scorecard Manager 2005 and code-named Maestro.

"One way to increase the impact that people can have in an organization is to give them access to the information they need," said Jeff Raikes, president of the Microsoft Business Division. "Until now, BI software has been too complex, costly, and disconnected from the software tools people use every day to do their jobs. But the investments we're making in Microsoft Office, from significant extensions in existing products such as Excel and SharePoint, to new server investments such as the Office Business Scorecard Manager, will make BI and the business insights gleaned from it more pervasive, thereby enhancing the impact of people throughout an organization, which leads to greater overall business success."

New BI connectivity features in Office 12 will maintain persistent connections between Excel spreadsheets and server-based data sources. New server-based Excel functionality, called Excel Services, will help users "secure, share, and manage spreadsheets" on the server and let users view spreadsheets either in a Web browser or locally on the PC desktop. And new SharePoint/SharePoint Portal features will help users easily create Web dashboards that combine data and charts from numerous back-end data sources.

Microsoft says that these new BI features, coupled with Microsoft's historically low prices and mainstream availability, will fundamentally change the BI landscape, making it a collaborative, rather than individual, activity. Previously, businesses had to perform complex and costly BI activities outside of the usual business process structure. BI competitors, such as SAP and Oracle, however, note that Microsoft is late to the game, while offering fewer features.

Results of Previous Instant Poll: Home Databases
"What do you use at home for a database?" Here are the results from the 82 votes (deviations from 100 are due to a rounding error):

  • 12% SQL Server Express

  • 12% MSDE

  • 39% Microsoft Access

  • 12% Another database

  • 24% I don't use databases at home

New Instant Poll: Express Hobbies
"Who do you know who would use SQL Server 2005 Express to create "hobby" databases (e.g., inventory of music CDs)?" Go to the SQL Server Magazine home page ( http://lists.sqlmag.com/t?ctl=17C95:285886 ) and submit your vote for

  • I'd use it

  • My kids would use it

  • My significant other would use it

  • My friends would use it

  • I can't imagine anyone I know using it

4. Events and Resources


Get Ready for the SQL Server 2005 Roadshow in Europe--Get the facts about migrating to SQL Server 2005!
SQL Server experts will present real-world information about administration, development, and business intelligence to help you implement a best-practices migration to SQL Server 2005 and improve your database-computing environment. Receive a one-year membership to PASS and one-year subscription to SQL Server Magazine. Register now.
    http://lists.sqlmag.com/t?ctl=17C81:285886

  • Two Minute SQL Server Stumpers


Get prepared for your next interview, or get a few good questions to ask your next DBA candidate. SQLServerCentral.com has compiled our famous Question of the Day into a small pocket book that is a great reference guide, study aid, or just for stump-the-DBA fun. Get your copy now at:
    http://lists.sqlmag.com/t?ctl=17C8D:285886

  • XML 2005--The reliable source for everything XML!


XML 2005, produced by IDEAlliance, where IT professionals gather to review the latest in XML-related technologies and applications. Hear in-depth talks from industry leaders. Visit the expo floor for the most advanced products being offered today. Complimentary expo pass offered until 11/7!
     http://lists.sqlmag.com/t?ctl=17C93:285886

  • All High Availability Solutions Are Not Created Equal--How Does Yours Measure Up?


In this free, on-demand Web seminar you'll get the tools you need to ensure your systems don't go down. You'll learn what solutions help you take preemptive, corrective action without resorting to a full system failover, that perform a non-disruptive, automatic switchover to a secondary server in extreme cases.
    http://lists.sqlmag.com/t?ctl=17C7E:285886

  • See the complete Windows IT Pro Network guide to Web and live events.


    http://lists.sqlmag.com/t?ctl=17C91:285886


  • Dashboard Development and Deployment--A Methodology for Success


Business information carries little value unless it reaches the right person at the right time. This free white paper tells you what you need to know to remain competitive while improving the speed and quality of decision-making. Learn how a well-designed dashboard can provide critical information to decision makers, enable them to monitor the health of your organization and bring immediate ROI to your business.
    http://lists.sqlmag.com/t?ctl=17C82:285886

6. Peer to Peer


  • Hot Tip: Loading Text Into Analysis Services


    by Microsoft's SQL Server Development Team, [email protected]

I have a string column in a Fact table that I want to show up in my MDX queries. Although I'd normally use member properties for this functionality, because of a data warehousing consideration, I can't go that route. How can I get the column into MDX as a string so that it will show up as a string in my analysis cubes?

  • Read the answer to this question today at


    http://lists.sqlmag.com/t?ctl=17C7F:285886

  • Hot Article: Demystifying Debugging in SQL Server 2005


To debug a T-SQL stored procedure in SQL Server 2000, you use Query Analyzer. You simply right-click the stored procedure and choose Debug. In SQL Server 2005, SQL Server Management Studio replaces Query Analyzer. It's logical to assume that to debug a T-SQL stored procedure in SQL Server 2005, you simply right-click a stored procedure and select Management Studio's debug feature. Unfortunately, it's not that straightforward. A debug option is nowhere to be found. In his November feature article "Demystifying Debugging in SQL Server 2005," Niels Berglund shows you how to use the Visual Studio 2005 development environment to debug a stored procedure. Read this article today and post your comments at
    http://lists.sqlmag.com/t?ctl=17C80:285886

  • In a Nutshell: A Week in London


Although he's suffering from jetlag, In a Nutshell author Kevin Kline reflects on the joys of visiting London and particularly in meeting with customers. In this week's installment "A Week in London," Kevin explains that he loves hearing what high-end SQL Server users are working on--and what constraint they toil under. What are their problems? Where are they feeling pain? Where do they spend much of their time? Read the blog today and let Kevin know about your SQL Server pain points today at
    http://lists.sqlmag.com/t?ctl=17C84:285886

Hot Threads: Check out the following hot threads, and see other discussions in our 30 SQL Server forums. http://lists.sqlmag.com/t?ctl=17C8C:285886

SQL Server General Discussion: SP Default Value
    http://lists.sqlmag.com/t?ctl=17C79:285886
T-SQL: Script Database and Objects in T-SQL
    http://lists.sqlmag.com/t?ctl=17C78:285886
Reporting Services: Exception from HRESULT: 0x80131500
    http://lists.sqlmag.com/t?ctl=17C7A:285886
Administration: What is Query Spew?
    http://lists.sqlmag.com/t?ctl=17C7B:285886
Performance: Controller Cache Setting
    http://lists.sqlmag.com/t?ctl=17C7D:285886
Replication: Transactional Replication and Deadlock
    http://lists.sqlmag.com/t?ctl=17C7C:285886

Hot Spot


  • Microsoft ASP.NET Connections Conference


Celebrate the release of Visual Studio 2005 and SQL Server 2005 at Microsoft ASP.NET Connections, November 7-10, in Las Vegas. Every attendee goes home with a fully-licensed copy of SQL Server 2005 Standard Edition and Visual Studio 2005 Professional. Register now and attend sessions at Visual Studio Connections for FREE!
    http://lists.sqlmag.com/t?ctl=17C92:285886

7. Announcements


  • Become a VIP Subscriber!


Get inside access to ALL the articles, tools, and helpful resources published in Windows IT Pro, SQL Server Magazine, Exchange and Outlook Administrator, Windows Scripting Solutions, and Windows IT Security--that's more than 26,000 articles at your fingertips. Your VIP subscription also includes a valuable one-year print subscription to Windows IT Pro and two VIP CDs (includes the entire article database on CD). Sign up now:
    http://lists.sqlmag.com/t?ctl=17C88:285886

  • The Exchange & Outlook Administrator Newsletter


If you haven't already subscribed to the Exchange & Outlook Administrator newsletter, you're missing out on key information related to preventing serious messaging problems and downtime. This newsletter encompasses tools and solutions you won't find anywhere else to help you migrate, optimize, administer, backup, recover, and secure Exchange and Outlook. Order now:
    http://lists.sqlmag.com/t?ctl=17C86:285886

8. New & Improved


    by Dawn Cyr, [email protected]

Share Your Story and Get a T-Shirt!


Have you used a product that saved you time or made your job easier? Tell us how your favorite product solved a SQL Server problem for you, and if we print your submission in the magazine's Hands On department we'll send you a SQL Server Magazine t-shirt. Send your email today to [email protected]!

Give Users Access to Analysis Services Cubes
IQub announced OLAP Browser Version 4, an on-demand, point-and-click analysis-and-reporting solution for non-technical SQL Server users. The software turns raw data into relevant information for supporting business decisions that users can access through a direct connect or through LAN access to SQL Server Analysis Services cubes by means of a standard network connection. Remote or Internet users can access Analysis Services cubes through HTTP. The software gives users the ability to create and access local cubes for offline processing when they're working at home or on the road. Once they've got the information they need, users have the ability to edit, filter, and replicate cubes for distribution and the ability to create reports or share cube interactive views with other users for collaborative analysis. Pricing for OLAP Browser Version 4 is on a per-seat or per-desktop basis, and the software is available to download for a free trial. For more information, contact IQub at 800-680-4782 or [email protected].
    http://lists.sqlmag.com/t?ctl=17C96:285886

Contact Us


SQL Server Magazine UPDATE is brought to you by SQL Server Magazine, the only magazine devoted to helping developers and DBAs master new and emerging SQL Server technologies and issues. Subscribe today.
https://store.pentontech.com/index.cfm?s=9&promocode=eu215xdb

View the SQL Server Magazine Privacy Policy
http://www.winnetmag.com/aboutus/index.cfm?action=privacy

SQL Server Magazine is a division of Penton Media, Inc. 221 East 29th Street, Loveland, CO 80538, Attention: Customer Service Department

Copyright 2005, Penton Media, Inc. All Rights Reserved.

Read more about:

ITPro Today
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like