Oracle and SQL Server are both database platforms built on SQL, but there are vast differences between them. Janet Wong brings us a tale of her experiences in moving from Oracle to SQL Server as a developer.
2006-10-19
8,135 reads
Every SQL Server developer has a preferred method of doing things; mine is what I call molecular queries. These are queries assembled from atomic queries; by which, I mean that they address exactly one table. By combing atoms, I can create molecules.
2006-10-19
3,998 reads
Whether you use the forums here or post questions in the venerable Usenet usegroups, there are some basic courtesies you should follow. Sushula Iyer takes a minute to list some things that might help you get your next question answered quickly and completely.
2006-10-18
4,617 reads
The .NET Framework 2.0 and Visual Studio 2005 make it easy to create a basic but extensible database-monitoring solution without a lot of complexity or coding.
2006-10-18
4,043 reads
We've added a few more bundles to our sale, including a new book: The Best of SQLServerCentral.com - vol. 4. If you're not coming to the PASS 2006 Summit, this is your chance to snag this volume for your corporate bookshelf.
2006-10-17
2,121 reads
SQL Server does a great job of handling concurrency & ensuring that users can make changes in multi-user systems without conflict. However there are times a strict calling order is needed.
2006-10-17
20,306 reads
Sanchan Saxena gets to grips with the new index-tuning tools and features in SQL 2005
2006-10-17
3,510 reads
Working with memory in SQL Server and tuning your server for optimum performance gets more complex all the time, especially with the availability of 64-bit platforms. New author Paul Mu brings us a short guide to using the /3GB and PAE switches along with their implications for your server.
2006-10-16
9,033 reads
The training arm of SQLServerCentral.com is spinning off to its own company. This is the place to come for high quality custom training.
2006-10-16
2,334 reads
Are you up to the latest design challenge? A great way to sharpen our analysis and modeling skills is to continuously address real-world scenarios. A modeling scenario with suggested solutions appears each month in this Design Challenge column. The scenario is emailed to more than 1,000 modelers. The responses are then consolidated into this column.
2006-10-16
2,039 reads
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
WhatsApp:08218200205Jl. Raya Prapen No.38, Sidosermo, Kec. Wonocolo, Surabaya, Jawa Timur 60299
Call CSO; (+62 821°3111°179 Jl. Mangga Dua Square lantai LG Blk. A No.144, RT.11/RW.6,...
Jl. A.M Sangaji No.020 A, RT.3/RW.04, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat, Daerah...
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers