Sign in
|
Join
|
Help
Home
Blogs
WordPress Blogs
Media
All Tags
»
sql server
»
enterprise
(
RSS
)
MVP WordPress Blogs
Loading...
Tags
.NET
Advisories / Bulletins
ASP.NET
C#
Community
ConfigMgr 2007
Digital Media
Events
Exchange
General
General Security News
Media Center
Microsoft
News
Rants
Security
Sharepoint
SPPS03_Tips
SQL Server
System Center
Tools
VB
Vista
Windows 7
Windows Server
Browse Blog Posts by Tags
Showing related tags and posts for the
Blogs
application. See
all tags in the site
127.0.0.1
2008
3gb
accleration
applications
auto
awe
azure
best practice
best practices
biztalk
catalog
client
code-plex
community
concurrent
conference
connections
consolidation
data center
database
dmo
edition
e-learning
encryption
error log
event
events
fulltext
insert
instances
itpro
kba
linked
live migration
management
management studio
manager
map
market
memory
microsoft
monitoring
office
oracle
pae
parallelism
pass
performance
planning
prize
restore
scalability
script
security
server
sharepoint
smo
sp1
sql express
ssms
standard
statistics
stored procedure
study
support
toolkit
tools
tpc
transaction
tsql
usergroup
users
virtualization
webcast
whatsnew
windows
x64
xp
Microsoft Assessment and Planning Toolkit 6.5 Now Available for Download
Microsoft Assessment and Planning (MAP) toolkit helps the migration of your IT environment, in specific I use this product whenever a database and instance upgrade projct is planned. The MAP 6.5 adds the cloud migration planning too, that confirms journey...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Thu, Dec 8 2011
Filed under:
Filed under:
sql server
,
best practices
,
enterprise
,
planning
,
toolkit
,
map
,
azure
,
accleration
SQL Server virtualization - Hyper-V and Live Migration, interesting concept for server consolidation
Virtualization is a hot topic to discuss and essentail to consider when you are referring to server consolidation to save physical sprawl & costs. The consolidation project will typically start to achieve the mile-stones such as reducing the operations...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Wed, Mar 16 2011
Filed under:
Filed under:
sql server
,
performance
,
memory
,
best practices
,
enterprise
,
consolidation
,
virtualization
,
scalability
,
data center
,
live migration
Restoring Full-text Catalog in SQL Server 2005 removes SQLServer2005MSFTEUser ACL
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Standard Edition & Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New Restoring...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, Sep 21 2010
Filed under:
Filed under:
sql server
,
restore
,
users
,
kba
,
enterprise
,
fulltext
,
catalog
SQL Server Edition - which is the best one to choose for your database needs?
When I look at the question, I feel that no direct answer to it! The reason being SQL Server has outgrown into an important enterprise RDBMS product from a simple desktop based database application, but still maintains the ease of installation and use...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Sun, May 17 2009
Filed under:
Filed under:
sql server
,
performance
,
standard
,
best practices
,
edition
,
enterprise
,
statistics
,
monitoring
,
e-learning
Events and Webcasts about Sharepoint Technologies
The following information consists abouts events & webcasts pertaining to Sharepoint technologies: Events/Webcasts SharePoint Technologies SharePoint Summit 2009 Free of charge Date: 7 May 2009, 09:30 Location: Middlesex Event Category: Onsite Event...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Wed, May 6 2009
Filed under:
Filed under:
sql server
,
webcast
,
server
,
event
,
sharepoint
,
enterprise
,
office
SQL Server Heroes Unite Contest!
PASS community connector email that I would like to share! Prove that you've got what it takes! Build the next generation of community applications on SQL Server 2008 in CodePlex: websites, enterprise suites, samples, gadget, tools, guidance, etc...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Thu, Aug 7 2008
Filed under:
Filed under:
sql server
,
pass
,
community
,
enterprise
,
applications
,
prize
,
code-plex
TechNet Webcast: SQL Server 2008 Performance and Scalability Technologies (Level 300)
Event: SQL Server 2008 Performance and Scalability Technologies Level: 300 SQL Server 2008 supports very large databases, enterprise-scale reporting systems, and data warehouses. It provides growing database systems with tools and features to optimize...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Sun, Aug 3 2008
Filed under:
Filed under:
sql server
,
performance
,
webcast
,
enterprise
,
support
,
events
,
scalability
SQL Server 2008 - What's new for IT Pro community [UK Usergroup conference]
In continuaton to UK User Group conference (2 day) in Microsoft Campus, Thames Valley Park Reading here is my presentation to download that was delivered on 09th April 2008. Appreciate your feedback....( read more ) Read More...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Wed, Apr 9 2008
Filed under:
Filed under:
sql server
,
community
,
2008
,
enterprise
,
best practice
,
whatsnew
,
conference
,
usergroup
,
itpro
Snap-in failed to initialize, Name Microsoft SQL Enterprise Manager: CLSID : {00100100-1816-11D0-8EF5-00AA0062C58F}
Few times I get such error Snap-in failed with a long CLSID string mentioned in the subject above. On this client machine previously I have SQL Server 2000 tools and recently installed 2005 version too, instantly error: Snap-in failed to initialize Name...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, Jan 8 2008
Filed under:
Filed under:
sql server
,
tools
,
enterprise
,
sql express
,
error log
,
management studio
You may receive an error message when a SQL Server 2005 client requests encryption and connects to 127.0.0.1 on a Windows XP-based computer
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, Nov 20 2007
Filed under:
Filed under:
sql server
,
kba
,
enterprise
,
encryption
,
client
,
x64
,
xp
,
127.0.0.1
FIX: Error message when you run a stored procedure that starts a transaction that contains a Transact-SQL statement in SQL Server 2005: "New request is not allowed to start because it should come with valid transaction descriptor"
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Thu, Aug 23 2007
Filed under:
Filed under:
sql server
,
kba
,
transaction
,
enterprise
,
x64
,
stored procedure
,
tsql
The auto update statistics option, the auto create statistics option, and the Parallelism setting are turned off in the SQL Server 2000 or SQL Server 2005 database instance that hosts the BizTalk Server 2004 or BizTalk Server 2006 BizTalkMsgBoxDB database
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Thu, Aug 23 2007
Filed under:
Filed under:
sql server
,
database
,
kba
,
enterprise
,
x64
,
statistics
,
parallelism
,
biztalk
,
auto
More than 3GB memory is not used even though boot.ini has these switches on /3GB /PAE /AWE.
Yet another AWE memory settings blog post here that I'm posting for the issues we have had recently. Before going into details review about 3GBPAE blurb here and also refer to this KBA274750 to enable more than 2GB memory within your SQL Server Enterprise...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Thu, Aug 23 2007
Filed under:
Filed under:
sql server
,
performance
,
memory
,
security
,
windows
,
edition
,
enterprise
,
instances
,
awe
,
pae
,
3gb
Can't find linked server in management studio?
In SQL Server 2000 when you create a linked server then you can see that on Enterprise Manager under Security --> Linked Server. One of the Developer asked me how we can find same in SQL Server 2005 Management studio, here it is: You will find under...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Thu, Jun 28 2007
Filed under:
Filed under:
sql server
,
management
,
security
,
server
,
ssms
,
enterprise
,
sql express
,
oracle
,
linked
KBA: A list of the bugs that have been fixed in SQL Server 2005 Service Pack 1
Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Reporting Services & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications A list of the bugs that have been fixed in SQL...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Wed, Jun 27 2007
Filed under:
Filed under:
sql server
,
kba
,
standard
,
enterprise
,
x64
,
sp1
FIX: You may receive error 1203 when you run an INSERT statement against a table that has an identity column in SQL Server 2005
Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications FIX: You may receive error 1203 when you run...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Wed, Jun 27 2007
Filed under:
Filed under:
sql server
,
kba
,
standard
,
edition
,
enterprise
,
x64
,
insert
Recently modified Knowledge Base Articles for SQL Server Enterprise Edition (32 & 64 bit)
Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released http://support.microsoft.com/kb/937137/en-US FIX: Error messages when you run...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Thu, Jun 21 2007
Filed under:
Filed under:
sql server
,
kba
,
standard
,
enterprise
,
x64
Performance and Scalability: SQL Server 2005 Enterprise Edition Benchmarks
SQL Server 2005 achieved the #1 price/performance result for 3TB TPC-H non-clustered benchmark. This is a record breaking TPC-H three terabyte benchmark for a database running on Microsoft Windows and an HP Integrity rx8640 Server. The recent TPC-H benchmark...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Wed, Jun 20 2007
Filed under:
Filed under:
sql server
,
performance
,
microsoft
,
enterprise
,
tpc
,
market
,
study
Best way to generate DDL and data insert scripts
There is no easy or best way, but few options are available such as DMO or SMO or even using Enterprise Manager for SQL 2000 or SS Management Studio for SQL 2005. Look for DBPublish wizard tool in this case that will help quite a bit and a lso you can...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Mon, Jun 11 2007
Filed under:
Filed under:
sql server
,
ssms
,
enterprise
,
smo
,
script
,
manager
,
dmo
FIX: You may receive error messages when you try to log in to an instance of SQL Server 2005 and SQL Server handles many concurrent connections
Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition FIX: You may receive error messages when you try to log in to an instance of SQL Server 2005 and SQL Server handles many concurrent connections http://support.microsoft.com/kb...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Mon, Jun 4 2007
Filed under:
Filed under:
sql server
,
kba
,
enterprise
,
concurrent
,
connections
Page 1 of 1 (20 items)