|
|
| SQL Server Tips |
RSS Feed URL : http://www.perfect-computing.com/Sql_server_news.xml
Category : SQL & databases
Total Views : 76 |
| Latest entries from this feed url |
SQL Server CE
Perfect Computing, Inc utilizes .NET and SQL Server CE to create remote applications.
SQL Server CE is an enabling technology for Windows .NET Compact Framework applications. When you use Visual Studio .NET 2003 to test an application that references the SQL Server CE assembly, the IDE automatically installs SQL Server CE as part of the test deployment. As a result, you probably won't need to download SQL Server CE. However, if you need to install it, you can download it for free from http://www.microsoft.com/sql/ce/downloads/ce20.asp. Note that the Web page says you must have Microsoft eMbedded Visual Tools (EVT) 3.0. If you installed the Compact Framework, you've already met this requirement. Like all Compact Framework applications, SQL Server CE installs by copying the .cab file to your handheld device.
SQL Server Workgroup?
Most developers have heard of MSDE, the free/scaled-down version of SQL Server, but have you heard of SQL Server Workgroup Edition?
Microsoft decided to add a new version of SQL Server to the 2005 product line. Not only that, but they also decided to re-release a new version of SQL2000.
Perfect Computing, Inc believes that Workgroup Edition is a great entry-level database for smaller departments or for businesses that have outgrown MSDE or Small Business Server. However, if you are looking for business intelligence capabilities, you will want to evaluate SQL Server Standard Edition because it provides the complete SQL Server set of components including our award-winning Analysis Services, Reporting Services, and data-mining technologies.
IMCEDA SQL LightSpeed Backup
When you're dealing with large databases, backup and restore times can
become a big problem. Perfect Computing, Inc. recommends the use of
SQL LightSpeed.
Typical backup scenarios will see 70-80% compression (on the fly) of database
backups. Not only will an administrator see disk space savings, but the database
backup times will decrease as well. We've seen backup times decrease by HOURS on
larger databases. For larger production systems, this can mean being able to do
index rebuilds or having to skip them.
A lot of industries are currently being hit with all the new HIPAA
regulations as well. SQL LightSpeed allows the (on the fly) encryption of
your backup sets. This limits the ability of someone being able to use
your backup sets.
Download a copy of SQL LightSpeed today and take it for a test
drive.
MSDE Tools
It seems like everyone is developing with MSDE as a backend these days.
However, everyone always seems to have the same question--how do I administer the MSDE database?
There are many free tools on the market today. Perfect Computing has several recommendations on our website.
Search All Columns For String
Every now and then, someone asks "how do I search every column in a SQL Server table"? Although it's a slow operation, it can be done.
SQL Server SET Based Loop
Many people believe it's not possible to loop through a SQL Server "set" of records without using a cursor. Although it's not always faster, it is possible to loop through SQL Server using SET based operations.
SQL Server Mail
Ever configure SQL Mail? Did you have a good experience? Did you throw the server out the window?
Many people find it very hard to configure SQL Mail and to actually get it working properly. The best links on the subject can be found at Microsoft's site. The definitive configuration guide can be found http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
With SQLMail, there are a couple of MAIN points to remember.
- A VALID MAPI profile must be setup on the SQL Server
machine.
- The MAPI profile should be setup while logged on with the SQLAgent
account.
- SQLMail can NOT send HTML mail.
If you need to send HTML formatted email, you might consider other
alternatives.
href="http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B312839#3">CDOSYS
or SMTP email might be better
alternatives.
SQL Server Logshipping
I find the Microsoft document on configuring logshipping interesting (http://support.microsoft.com/default.
aspx?scid=kb;en-us;314515).
This document lists the Enterprise Edition of SQL Server as a
requirement. Most SQL Server experts will tell you that Enterprise edition
is NOT required for logshipping. I will agree that logshipping is easier
to configure if you have Enterprise edition, but it's still possible to
configure with any other edition. My favorite link on manually configuring
logshipping would have to be here.
SQL 2005 (Yukon)
Are you ready for SQL Server 2005 (formerly Yukon)? Check out the
Microsoft site (http://www.microsoft.com/sql/2005/default.asp)
for important information on new features and comparisons with old
features.
|
|
|
