<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
  <channel>
    <title>BCM - 数据库</title>
    <link>https://bcmorning.com/forum.php?mod=forumdisplay&amp;fid=113</link>
    <description>Latest 20 threads of 数据库</description>
    <copyright>Copyright(C) BCM</copyright>
    <generator>Discuz! Board by Comsenz Inc.</generator>
    <lastBuildDate>Wed, 27 May 2026 11:11:26 +0000</lastBuildDate>
    <ttl>60</ttl>
    <image>
      <url>https://bcmorning.com/static/image/common/logo_88_31.gif</url>
      <title>BCM</title>
      <link>https://bcmorning.com/</link>
    </image>
    <item>
      <title>When to Use MongoDB Rather than MySQL (or Other RDBMS): The Billing Example</title>
      <link>https://bcmorning.com/forum.php?mod=viewthread&amp;tid=116762</link>
      <description><![CDATA[NoSQL is a hot buzz in the air for a pretty long time (well, it\'s not only a buzz anymore).
However, when should we really use it?

Best Practices for MongoDB
 NoSQL products (and among them MongoDB) should be used to meet challenges. If you have one]]></description>
      <category>数据库</category>
      <author>Test</author>
      <pubDate>Fri, 04 Jul 2014 10:14:13 +0000</pubDate>
    </item>
    <item>
      <title>Apache Cassandra</title>
      <link>https://bcmorning.com/forum.php?mod=viewthread&amp;tid=76774</link>
      <description><![CDATA[Apache Cassandra is an open source distributed database management system designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure. Cassandra offers robust support for cluster ...]]></description>
      <category>数据库</category>
      <author>MySense</author>
      <pubDate>Wed, 26 Feb 2014 17:32:28 +0000</pubDate>
    </item>
    <item>
      <title>免费1T空间，无需备案，即时开通！</title>
      <link>https://bcmorning.com/forum.php?mod=viewthread&amp;tid=5828</link>
      <description><![CDATA[免费1T空间，无需备案，即时开通！ http://www.xgkjw.com/free/(这里填写上你的会员帐户:vandave)]]></description>
      <category>数据库</category>
      <author>vandave</author>
      <pubDate>Thu, 21 Nov 2013 22:28:20 +0000</pubDate>
    </item>
    <item>
      <title>Setup utf-8 as standard character set for a mysql server</title>
      <link>https://bcmorning.com/forum.php?mod=viewthread&amp;tid=4928</link>
      <description><![CDATA[add this into my.cnf:It looks like default-character-set is no longer allowed in the [mysqld] section]]></description>
      <category>数据库</category>
      <author>MySense</author>
      <pubDate>Wed, 20 Nov 2013 04:19:11 +0000</pubDate>
    </item>
    <item>
      <title>\'Dedicated administrator connections are not supported.\'</title>
      <link>https://bcmorning.com/forum.php?mod=viewthread&amp;tid=3561</link>
      <description><![CDATA[Dedicated Administrator Connection (DAC) is a new feature of SQL Server 2005; it is a special diagnostic connection for administrators that can be used to connect to a server when standard connections are not possible.

If you are trying to connect t ..]]></description>
      <category>数据库</category>
      <author>demo</author>
      <pubDate>Mon, 24 Jun 2013 22:02:38 +0000</pubDate>
    </item>
    <item>
      <title>Decrypt stored procedure in SQL Server 2008</title>
      <link>https://bcmorning.com/forum.php?mod=viewthread&amp;tid=3558</link>
      <description><![CDATA[Solution 1:
Just download Optillect\'s SQL Decryptor freeware
A modern tool that decrypts T-SQL procedures, functions, triggers, and views on any SQL Server. It gives you a couple of options. You can see the code of the sp if you just wanted to see it .]]></description>
      <category>数据库</category>
      <author>demo</author>
      <pubDate>Fri, 21 Jun 2013 22:55:25 +0000</pubDate>
    </item>
    <item>
      <title>Import csv data into mysql with Chinese characters</title>
      <link>https://bcmorning.com/forum.php?mod=viewthread&amp;tid=3517</link>
      <description><![CDATA[prety simple but expended my lots time.
Here it is.Please note: character set may be GB2312, UTF8, BIG5, or other code. you can see the details using:]]></description>
      <category>数据库</category>
      <author>demo</author>
      <pubDate>Fri, 31 May 2013 08:35:14 +0000</pubDate>
    </item>
    <item>
      <title>Grant EXECUTE to user on XP_CMDSHELL</title>
      <link>https://bcmorning.com/forum.php?mod=viewthread&amp;tid=3503</link>
      <description><![CDATA[For my example code (which follows), the first thing you need to do is to setup a Windows user called \&quot;TestDummy\&quot; with just normal user privs.  You also need to setup a user called SqlCmdUser and give it privs to whatever drives you want someone with ..]]></description>
      <category>数据库</category>
      <author>Test</author>
      <pubDate>Tue, 21 May 2013 22:33:41 +0000</pubDate>
    </item>
    <item>
      <title>Microsoft® SQL Server® 2008 R2 Feature Pack</title>
      <link>https://bcmorning.com/forum.php?mod=viewthread&amp;tid=3020</link>
      <description><![CDATA[The Microsoft® SQL Server® 2008 R2 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2008 R2.
OverviewThe Microsoft® SQL Server® 2008 R2 Feature Pack is a collection of stand-alone pa ...]]></description>
      <category>数据库</category>
      <author>demo</author>
      <pubDate>Tue, 21 Aug 2012 18:43:53 +0000</pubDate>
    </item>
    <item>
      <title>Free ebook: Introducing Microsoft SQL Server 2012</title>
      <link>https://bcmorning.com/forum.php?mod=viewthread&amp;tid=3019</link>
      <description><![CDATA[Friends, the final and complete version of Introducing Microsoft SQL Server 2012, by Ross Mistry (@RossMistry) and Stacia Misner (@StaciaMisner), is now ready as a free download! You candownload the PDF version of this title here (288 pages; 10.8 MB) ...]]></description>
      <category>数据库</category>
      <author>demo</author>
      <pubDate>Tue, 21 Aug 2012 17:34:00 +0000</pubDate>
    </item>
    <item>
      <title>Access to the remote server is denied because the current security context is...</title>
      <link>https://bcmorning.com/forum.php?mod=viewthread&amp;tid=2895</link>
      <description><![CDATA[What I did:
Created a SQL Job that accesses another database on some other server.

I get the error:
Access to the remote server is denied because the current security context is not trusted. [SQLSTATE 42000] (Error 15274).

I have the remote server]]></description>
      <category>数据库</category>
      <author>demo</author>
      <pubDate>Tue, 17 Jul 2012 23:36:52 +0000</pubDate>
    </item>
    <item>
      <title>Regular Expressions in MS SQL Server 2005/2008</title>
      <link>https://bcmorning.com/forum.php?mod=viewthread&amp;tid=2592</link>
      <description><![CDATA[[*]Download source code - 23.2 KB
[*]Download SQL Regular Expressions, ver. 2 (SQL Server project) - 8.67 KB


Introduction
The Regular Expressions feature is available in MS SQL Server 2005/2008. You can use all .NET Framework Regular Expression st]]></description>
      <category>数据库</category>
      <author>demo</author>
      <pubDate>Tue, 22 May 2012 18:01:34 +0000</pubDate>
    </item>
    <item>
      <title>Use T-SQL to list all files in a directory</title>
      <link>https://bcmorning.com/forum.php?mod=viewthread&amp;tid=2570</link>
      <description><![CDATA[Execute the following T-SQL example scripts in Microsoft SQL Server Management Studio Query Editor to list all files and all directories in a directory using xp_cmdshell extended system stored procedure. 
              Warning article:
               ..]]></description>
      <category>数据库</category>
      <author>demo</author>
      <pubDate>Fri, 18 May 2012 21:29:42 +0000</pubDate>
    </item>
    <item>
      <title>Tapping Into Your Reporting Services Database</title>
      <link>https://bcmorning.com/forum.php?mod=viewthread&amp;tid=2006</link>
      <description><![CDATA[For every instance of SQL Server Reporting Services (2005+) there are two databases, a primary and a TempDB.  The primary database holds all of the data for your instance, such as: Users, Folder Structure, Roles, Security, Subscriptions, Data Sources ...]]></description>
      <category>数据库</category>
      <author>Southhill</author>
      <pubDate>Wed, 22 Feb 2012 19:09:40 +0000</pubDate>
    </item>
    <item>
      <title>A simple string function to make a list in SQL</title>
      <link>https://bcmorning.com/forum.php?mod=viewthread&amp;tid=1976</link>
      <description><![CDATA[We have a table with a list like:

We can break it down into two seperate fields using T-SQL language like:


We get the result as:]]></description>
      <category>数据库</category>
      <author>Test</author>
      <pubDate>Thu, 16 Feb 2012 22:19:48 +0000</pubDate>
    </item>
    <item>
      <title>BCP using format files</title>
      <link>https://bcmorning.com/forum.php?mod=viewthread&amp;tid=924</link>
      <description><![CDATA[If the format of the file matches the table then it is simple to bcp the file without use of a format file.Whenever you have problems with a bcp start with a simple structure and build on that until you find the error.Start with a single row. If that ...]]></description>
      <category>数据库</category>
      <author>Test</author>
      <pubDate>Fri, 28 Oct 2011 17:45:02 +0000</pubDate>
    </item>
    <item>
      <title>OPENROWSET problem on Microsoft.ACE.OLEDB.12.0</title>
      <link>https://bcmorning.com/forum.php?mod=viewthread&amp;tid=779</link>
      <description><![CDATA[PROBLEM: I am trying to use OPENROWSET with an Excel 2007 file. It seems to be partially working. Here is what I am doing:

select * FROM OPENROWSET(
  \'Microsoft.ACE.OLEDB.12.0\',
  \'Excel 12.0;Database=C:\\Test.xlsx;HDR=YES\',
  \'SELECT * FROM []]></description>
      <category>数据库</category>
      <author>Test</author>
      <pubDate>Thu, 29 Sep 2011 17:33:55 +0000</pubDate>
    </item>
  </channel>
</rss>