News in the Category: SQL Subscribe to the rss of this category.

Total posts: 7775 | Sort by Views | Sort by Hits

SqlXml 3.0 SP3 Now Available!

Irwin Dolobowskys Blog, October 26, 2004
Views: 237 | Hits 2

SqlXml 3.0 SP3 has just been released and is now availalbe for download from http://www.microsoft.com/downloads/details.aspx?FamilyId=51D4A154-8E23-47D2-A033-764259CFB53B&displaylang=en.  &n...

SqlXml 3.0 SP3 Now Available!

Irwin Dolobowskys Blog, October 26, 2004
Views: 1,412 | Hits 94

SqlXml 3.0 SP3 has just been released and is now availalbe for download from http://www.microsoft.com/downloads/details.aspxFamilyId=51D4A154-8E23-47D2-A033-764259CFB53B&displaylang=en.  &nb...

Still Here, New Beginnings

Irwin Dolobowskys Blog, October 25, 2004
Views: 281 | Hits 2

Yes, for my faithful readers, I am still here.  It has been quite some time since I last posted, but I hope to make these much more frequently again.  Curious what I've been working on? ...

SQL 2005 Developer Webcasts coming...

Love that ASP.NET and SQL Server, October 25, 2004
Views: 1,067 | Hits 69

  Help us get the word out on the Webcasts that will begin in Decmeber 2004.  Everyone who attends a WebCast will receive a copy of the Beta 2 Resource Kit and the Beta 3 Resource Kit when i...

Enumerating SQL Servers

Sushils WebLog, October 14, 2004
Views: 31 | Hits 1

Continuing with the discussion on enumeration, I will go over ways to enumerate active SQL servers on the network in this blog. Pre-Whidbey, to get list of active servers on the network, we could have...

Enumerating SQL Servers

Sushils WebLog, October 14, 2004
Views: 1,448 | Hits 96

Continuing with the discussion on enumeration, I will go over ways to enumerate active SQL servers on the network in this blog. Pre-Whidbey, to get list of active servers on the network, we could have...

Sample Code: Bidirectional Sorting in ASP.NET Repeater control

Sushila Patels Weblog, October 9, 2004
Views: 8,080 | Hits 134

.aspx <asp:Repeater ID="Repeater1" Runat="server" EnableViewState="False"> <ItemTemplate> <table width="100%" cellspacing="0" cellpadding="0"> <tr>&n...

Win-Dev 2004 talks on XQuery in SQL Server and System.Xml V2.0

Mark Fussells WebLog : XML, October 5, 2004
Views: 1,071 | Hits 152

I am doing two talks at the Win-Dev 2004 Conference on the Web Services track and the Databases and Data Access so if you are going to the conference or live in the Boston area and...

Injection Attacks

Sushila Patels Weblog, September 1, 2004
Views: 2,050 | Hits 81

 To prevent SQL-injection attacks, never use string concatenation to build a SQL command, always use the SqlCommand class (or OleDbCommand class, etc) with parameterized commands. if possible...

Back from Vacation

Bryant Likess Blog, August 9, 2004
Views: 949 | Hits 1

I'm back from spending a week camping in Yosemite with my wife and some of her family. I think the highlight of the trip was hiking to the top of Vernal Falls with my 3-year-old nephew on my...

A Quick Introduction to SQL Server Management Objects (SMO)

YukonXML.com - SQL Server 2005 Resources, July 29, 2004
Views: 1,315 | Hits 96

Microsoft SQL Server 2000 supports a COM-based object model, called SQL-DMO, which can be used to programmatically manage the SQL Servers. SQL Server 2005 replaces SQL-DMO with two .NET based object l...

SQL Server 2005 DTS and ODBC Connections

Bryant Likess Blog, July 28, 2004
Views: 1,153 | Hits 44

I ran into while using DTS in SQL Server 2005. If you want to use an ODBC connection you have to do the following: Pretend to create a ADO.Net SQL connection first (or managed OLEDB,whatever works)....

Service Broker "Hello World"

Bryant Likess Blog, July 27, 2004
Views: 1,046 | Hits 45

Pretty interesting hello world example using SQL Server 2005 Service Broker. I'm definately going to dig into this product as I can see some good usage senarios that will leverage my existing SQL skil...

SQL Server 2005 Beta 2 Released

Bryant Likess Blog, July 26, 2004
Views: 774 | Hits 2

[via MSDN SQL Server Developer Center] If you are an MSDN Subscriber, SQL Server 2005 Beta 2 is now available for you to download. Click here for a link to the subscriber downloads site.  &...

Instance Based Custom Code in Reporting Services

Bryant Likess Blog, July 21, 2004
Views: 696 | Hits 8

In response to a question posted in the comments of my last article I've created a Writing Custom Code Part II article. In this article I explain the basic of how to use instance based custom code in ...

Accessing Databases via Custom Code

Bryant Likess Blog, July 21, 2004
Views: 925 | Hits 3

Another good question in response to my Custom Code in Report Services article. I am trying to access a database through a custom assembly and I already have the following in the rssrvpolicy.co...

Two New Articles - Bulkload in .Net and FOR XML in SQL Server 2005

Irwin Dolobowskys Blog, June 28, 2004
Views: 1,553 | Hits 105

There are a few new SqlXml-related articles up on MSDN. First we have Amar Nalla's XML to SQL: Using SQLXML Bulkload in the .NET Framework which gives great examples on constructing annotated sch...

Article on the XML Support in SQL Server 2005

Mark Fussells WebLog : XML, May 24, 2004
Views: 1,134 | Hits 101

I worked with Shankar to write this article on the XML Support in Microsoft SQL Server 2005 which has just been published on the MSDN XML Developer Center. I would be very interested in comm...

BizTalk Server 2004 Configuration Management Report Generator

BizTalk Server 2004, May 19, 2004
Views: 22 | Hits

Originally posted on: http://blog.loethen.net/cyoung/archive/2004/05/19/5070.aspxIn case you've missed it, Scott Woodgate has published a new reporting tool on his blog site.   The BizT...

BizTalk Server 2004 Configuration Management Report Generator

BizTalk Server 2004, May 19, 2004
Views: 26 | Hits

Originally posted on: http://geekswithblogs.net/archive/2004/05/19/5070.aspxIn case you've missed it, Scott Woodgate has published a new reporting tool on his blog site.   The BizTalk S...

BizTalk Server 2004 Configuration Management Report Generator

BizTalk Server 2004, May 19, 2004
Views: 252 | Hits 1

Originally posted on: http://geekswithblogs.net/cyoung/archive/2004/05/19/5070.aspxIn case you've missed it, Scott Woodgate has published a new reporting tool on his blog site.   The Bi...

FIX: SqlDecimal.Round method incorrectly rounds up with some decimal values

kbAlertz.com :: ADO.NET 1.1, April 13, 2004
Views: 2,704 | Hits 37

839423 ... FIX: SqlDecimal.Round method incorrectly rounds up with some decimal values (839423) - Provides a fix for a problem that causes certain decimal values to be incorrectly rounded up with t...

Hierarchical XML - importing into SQL Server 2000

XML, XSL, XSD, February 25, 2004
Views: 1,316 | Hits 178

I've just finished my first draft of a new article on how to import infinite-depth XML trees into a parent/child table in SQL Server 2000.It uses table variables and OPENXML to do most of the tricks, ...

XML in SQL Server 2000 and SQLXML

YukonXML.com - SQL Server 2005 Resources, January 26, 2004
Views: 1,331 | Hits 102

Microsoft SQL Server 2000 first introduced native support for XML and HTTP. Since then, to keep up with XML, Web services and .NET advancements, Microsoft has made available add-ons to SQL Server ...

Undocumented SQL 2003 Encryption Routines

Scott Cate .net Knowledge Base and Weblog, November 30, 2003
Views: 1,435 | Hits 46

My good friend Brady Gaster, once again, comes through with the best tip of today. A SQL guru he works with tipped him to this and he shared with me (just so proper credit gets served). Really pretty ...