|
|
| SQL Server Tips |
RSS Feed URL : http://www.perfect-computing.com/Sql_server_news.xml
Category : SQL & databases
Total Views : 26 |
| 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.
|
|
|
|
|
Latest Fox News Feed |
Aid Efforts Stymied by China, Myanmar Tragedies
Two catastrophes have struck this month — the cyclone in Myanmar and the earthquake in China. As the death tolls in these two countries mount, so does the need for aid. But Myanmar has been reluctant to let relief workers into the country, and China says it will accept foreign aid on its own timetable. But how do people give if they want to help the victims?
Search for Victims Turns Up a Quake Survivor
Four days after a powerful earthquake struck China's Sichuan province, survivors are still being located, freed from rubble by rescue teams. Days after the quake, a search party found and rescued a survivor in a devastated village in Sichuan. But getting the man out of a collapsed factory was no simple matter.
Families Search for Living in Dujiangyan
About 20 miles from the epicenter of the earthquake, Dujiangyan, China, has gone from a booming metropolis of more than a half-million to a teeming tent city. Residents are still looking for family members — or trying to let them know they are alive.
A Rapper Out of Sudan's Civil War
Emmanuel Jal was a child soldier in Sudan's brutal civil war. Now he is a rapper with a new album out called Warchild. Music journalist Christian Bordal has a review and profile of the artist.
Capt. Rawlings' Tips on Serving in Iraq
The 26-year-old Princeton alum has been stop-lossed in Sadr City. Over the next few months, he'll be answering listeners' questions about his experience. In his first batch of answers, he discusses how he fills his spare time, why his soldiers sometimes make fun of him and what he'd tell a kid who's considering a future in the military.
Palestinian-American Reflects on Israel
Palestinian American Nina Cullers and her family lost their home and way of life when Israel became an independent nation in 1948. As Israel marks its 60th anniversary, Cullers reflects on how that event affected her life as a Palestinian.
|
|
Popular Fox News Searches |
|
news feed WWF news latest for news feed news feed wwf nesws news web marketing madical news health news fox news News and Opportunities news sabah times digital camera news news right now fox news WWF NEWS Developer News medical news feed Search result for Related feed to KEPUTUSAN PERMOHONAN SMK TEKNIK Free And Clear Real Estate Articles By JOHN BECK related feed to permohonan borang kemasukan teknik vokasional Tips for Opening a Online Forex Trading Account |
|
