Press Release - RedGate Announces SQL Server Compare
RedGate software has announced their newest product, SQL Server Compare, a new tool for comparing and synchronizing SQL Servers. Read the press release!
2002-05-01
2,429 reads
Additional Articles
Choosing an Edition of SQL Server 2000
Whether you are a developer, IT professional, or a database administrator, whether you are just developing and testing or are ready to deploy in production, there is a SQL Server 2000 edition for you and your organization. This paper will inform you about the differences among the various editions of SQL Server 2000, and how you can save time and money by choosing the right one for the job.
2002-04-24
1,375 reads
Tips for Performance Tuning SQL Server Transactional Replication
From this real-world case study, learn how you can boost SQL Server performance and scalability by off-loading reporting from your production SQL Server to a reporting server, using transactional replication.
2002-04-18
1,960 reads
DBA Certification – Is It for You?
"Certification mania" has hit IT, big-time. Many employers look for certification in potential employees and especially in IT contractors. If you're a data administrator or DBA, you have to consider: could DBA certification enhance my career? Would it deepen my knowledge and increase my value to my company?
2002-04-12
1,812 reads
Microsoft XML Core Services 4.0 RTM
The core components to Microsoft XML parser have been updated and released to market. The update contains many bug fixes, new features and enhancements to performance.
2002-04-05
4,122 reads
SQLServerCentral.com Launches April Contest
SQLServerCentral.com launched it April contest on April 1st sponosored by Lockwood Tech and SQL Server Magazine. Win LockWood Tech's Proc-Blaster Enterprise Edition, SQL Server Magazine, or Admin911 all for helping to build the SQL Server community.
2002-04-01
23 reads
AdminLog Added to the Freeware Library
AdminLog, by Lockwood Tech, has been added to the SQLServerCentral.com freeware library. AdminLog is a utility for managing projects, tracking bugs/tasks/assignments, etc.
2002-03-29
24 reads
Interview with Author Fernando Guerrero
Learn how to make the most out of ADO.NET and SQL Server. Find out how the new .NET Data Provider can boost SQL Server performance.
2002-03-29
1,053 reads
Object Scriptr v1.0 Released as Freeware
Object Scriptr v1.0 for SQL Server 7/2000 by Rac4sql has been released as freeware on SQLServerCentral.com. The product quickly generates creation and drop scripts and insert statements.
2002-03-28
44 reads
SQLServerCentral.com Launches New Discount Area
SQLServerCentral.com today launched its new members only product discount area. The section allows members to purchase SQL Server related products at a deep discount.
2002-03-27
23 reads
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers