|
|
|
|
|
|
|
<<
Page 1 of 7
>>
OUTER APPLY - SQL Server 2005 provides the way to calculating paths between connecting nods.
Tony Rogerson
writes "How do we go about calculating paths between two connecting nodes, and how do...we go about doing this in SQL Server? This comes from a question I answered on the Microsoft NNTP news groups. To learn more, read below.."
Don't miss the Developer security events coming up in London and Reading!
Steve Lamb
writes "The MSDN team will be presenting an evening of Application Security in London on the 21st September. They describe the event as follows: " In this session we will cover the new security features that are available in Visual Studio 2005 and Visual Studio Team System....along with guidance to enable you to secure your data access and a review of the new security features available in SQL Server 2005."
"
SQL Server Reference Guide > An Introduction to the CLR in SQL Server 2005
Buck Woody
writes "Beginning in SQL Server 2005, Microsoft has added an entirely new layer to the code arsenal for SQL Server, called the Common Language Runtime (CLR). It's based on the .NET architecture, and opens up new options for code design and logic placement. In this tutorial, I'll give you the basics of this new methodology and show you a simple example that you can try on your system. "
Management Studio Reports - Part 2 - Disk Usage Report
SQL Server Relational Engine Manageability Team
writes "One of my favorite reports is Disk Usage. It prepares two useful graphs breaking down the MDF and LDF space usage. It also provides information about disk space used by tables, partitions, and indexes. This data can also be exported to Excel so you can perform your own calculations..."
Stored Procedures vs Dynamic SQL
Simon Ince
writes "If you're not bored of this age old debate yet, have a read of this post from Andres Aguiar.
A lot of people still claim stored procedures are faster... which is not technically (always) true - it all depends on ..."
SQL Server 2005 coding standards
Gabriel Lozano-Moran
writes "I have noticed that Steven Bates blogged on the SQL Server 2005 coding standards here..."
SQL Server Web Admin "Alpha" Released on Codeplex
Dan Winn
writes "The first iteration of the SQL Server Web Admin tool has been released! This toolset enables hosters (or anyone for that matter) to set up a web interface for management of SQL databases..."
Analysis Services Support And You
Richard Waymire
writes "There's a thread on our MSDN forum ... about OLAP support.
Please jump into that thread or send me mail if you have thoughts on what support for Analysis Services in our database projects. I'd like to understand how big the demand is here...
"
Microsoft SQL Server 2005 Everywhere Edition CTP
Federal Developer
writes "We've release the first CTP of SQL Server Everywhere. If you aren't familiar with SQL Server Everywhere, here's the description from...
"Microsoft SQL Server 2005 Everywhere Edition offers essential relational database functionality in a compact footprint ideal for embedding in mobile and desktop applications including a new generation of occasionally connected dynamic applications.
Sharing a familiar SQL syntax and ...
"
Monitoring SQL Server Using SQL Server Business Intelligence
SQL Server
writes "Thanks to all who attended the presentation at TechEd and at PASSMN. For all who are interested, attached are the projects to support the Analysis Services cubes and Reporting Services reports demonstrated during the presentation...."
She Sells SQL By The Seashore...
teched06
writes "If you work with SQL, you know who she is (or should!). Check out this ..."
SQL Server Express--Deploying the database
Bill Vaughn
writes "Steve Lasker came by and recommended this blog article written by Rob Walters. It includes a number of good tips you'll need when building and deploying SQL Server Databases on client application platforms...."
SSIS Packages in the tune of c#
Mike Benkovich
writes "So now I’m all excited this week, because in this 11 part webcast series I finally get to write some code. Today’s webcast Advanced SQL Server 2005 DTS will give us the chance to see how an Integration Services package can be constructed dynamically at runtime from code that we will develop. I’ll be writing the code in C#, but if you’re familiar with ..."
Whitepaper: Migrating from Crystal Reports to SQL Server 2005 Reporting Services
Federal Developer
writes "I just saw this on Brian Welcker’s blog. How to migrate from Crystal Reports to Reporting Services is a frequently asked question I get all the time. Now we have some documented guidance. Here’s a description of the whitepaper:
“This document focuses on the manual migration effort for Crystal Reports 8.5 and above to SQL Server Reporting Services (SSRS), including a section-by-section comparison of report information from Crystal Reports to SSRS.
Include in this document:
"
Subquery returned more than 1 value
Tony Rogerson
writes "I've had so many referrals from google on this error because of my previous blog entry on the T-SQL Value assignment SET vs SELECT I've decided to expand into this specific error and in what situations you get it, what causes it and how to get round it.
Msg 512, Level 16, State 1, Line 12
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Some test data...
"
SQL Server Migration Assistants
Kimberly L Tripp
writes "In part 11 of the TechNet webcast series for the ITPro, I spoke briefly about the Oracle Migration Assistant and the recent release of the Community Tech Preview versions of both the Access and Sybase Migration Assistants... A few of you asked for their download location and there were even a few replies that folks had found them... However, after looking around, I figured out that what was found were the OLD and very outdated Access Upsizing Wizards (and that's not this!). The new SQL Server Migration Assistant tools are truly..."
Padding a string with leading zeros
Tony Rogerson
writes "I've need to do this a lot of times when outputing a fixed length data export where for instance a numeric column is 9 characters long and you need to prefix with leading 0's. This type of data export dates back to PL/1, COBOL era.
For a two character string you can do this...
"
TechNet Webcast Series for the ITPro - Series Links
Kimberly L Tripp
writes "Hey there everyone - The series has completed and I know that many of you struggled to get access to the surveys... Microsoft has asked me to post links to the surveys...so, for completeness, I decided to create this blog entry to have links for every session, every blog link (resources, demo scripts, etc.) and the survey links. I really did have a lot of fun on the series and I hope we can do this again! "
SQL Server's cross-version collation support
Michael Kaplan
writes "I had the day off today, though I did end up going to a meeting or two with some SQL Server folks (they set the meeting up before I was told we were getting the day, and I didn't want to make them suffer for the tardy notice!).
In between meetings, I was talking to someone who pointed out that although they enjoyed reading my blog that they thought I had the wrong take in ..."
SQLPrompt - Intellisense in Query Analyzer - Initial Review
Mark Caldwell (a.k.a. AjarnMark)
writes "I just downloaded and installed the free tool SQLPrompt, now from Red-Gate Software, and I'm really liking it. It provides Intellisense or statement-completion features in SQL Query Analyzer, SQL Server Management Studio, Visual Studio, and other development tools. For example, it not only ..."
<<
Page 1 of 7
>>
|
|
|
|
|
|
s
|
|
|