|
by: Dave |
last post by:
Hey all,
Recently we had a small re-org which combined DBA teams,
specifically Oracle and SqlServer. Just wondering if anyone has
documentation/presentations, etc that show's how to admin a SQLServer
environment from an Oracle DBA perspective?
I guess, something that map's each DB's concepts to each other. As
an Oracle DBA how to troubleshoot/support the environment, etc....
|
by: Bart Torbert |
last post by:
Hello,
I am starting to examine using SQLServer instead of Oracle. I went
through the SQLServer import utility to copy tables from Oracle into
SQLServer. I then checked the size of the database.
I then started to specify indices for the tables. I did not see the
database file size grow all that much. I kept on using the shrink
command to make sure that wasted space was removed. I even made sure
that minimal free space was allowed.
|
by: Peter Morris |
last post by:
What's the deal with SQLServer 2005 Beta?
I've just got a magazine with a free cover disk with VB 2005 beta,
and also includes SQLServer 2005. I've installed it, but I can't get it
to do anything. It seems to have installed ok, there are the data files
for allthe usual system and example databases in place, and Task
Manager shows that SQLServer is definitely running. However the
only tool that came with it is called 'Computer...
|
by: Devonish |
last post by:
I am planning to convert an existing Access database which has a back
end
(data tables and relationships only) on a server and a copy of the front
end
(form, queries, reports) on each of about a dozen workstations.
I intend to convert the back end to SqlServer and wish to use the
upsizing
wizard. I am acquiring SSW Upsizing Pro! 2000 which seems to be
recommended in other discussions.
|
by: Roy Gourgi |
last post by:
Hi,
I need to store and retrieve information from a database. It looks as though
there is a lot more support for SQLServer than there is for Access, correct
me if I am wrong.
What do I have to do to get SQLServer and which version should I be using.
Or is SQLServer already part of the VS.Net? Are there any good examples that
you know of.
|
|
by: Bill nguyen |
last post by:
Is there a way to access 2 databases simultaneously using a single
connection string?
I'm working on a VB.NET application and using 2 different connection strings
to access each database..
server: SQLSERVER
databases:
gasstations
customers
|
by: Josema |
last post by:
Is there any difference between:
executing 2 queries in the same sqlserver database at the same time
or
Executing 2 queries in 2 different databases at the same time
The same conditions for the 2 databases (same query, tables, indexes).
The concrete question is: is there any performance advantages in spliting
one database into 2.
--
|
by: =?Utf-8?B?SmVmZnJleQ==?= |
last post by:
I have some old ASP programs w/ SQLserver 2000 databases. Now I am
developing ASP.NET projects using VB 2005 and SQLserver 2005. What are the
best procedures to develop and test the ASP.NET programs?
My main concerns are:
1. What do I need to test? VB 2005/ASP.NET with 2000 data? Migration of
2000 data to SQLserver 2005? VB 2005/ASP.NET with 2005 data?
2. How to minimize the transition time? What is the critical change for
the...
|
by: Steve |
last post by:
Hi;
My company just installed MS SQLServer 2005 ( see below the dotted
line ).
When a user logs into management studio all of the databases on the
server are displayed in the right hand column.
What can we do to have only the databases the user has rights to,
display?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|