SelectViews Show The Weekly SQL Server show about all sorts of different things from how-to to commentary has been updated. This weeks show: Replication Troubleshooting, Managing SQL Server as a Part-Time DBA, Web 2.0 Book(s) Reviewed, Noise and News in the DB world. Also, the 60-Second SQL Server Tip of the Day, Upcoming Events and Information About the Virtual Conference. […]
Other News
Connecting to a MySQL Server remotely
(Dax Solomon Umaming) I’ve been working on a PHP code that uses MySQL DBs, and I’ve been doing it manually from Quanta and PHPMyAdmin. And everyone knows that coding in a browser is a very bad habit. I sure wish I have an IDE with MySQL Admin integrated in it. But before I go searching for that part
XQuery: The Search Language For A Multi-Platform Future
(Jim Pretin) The advent of wireless internet access has made web design a very complicated matter. Previously, all web browsers were created equal. HTML was the only language used to create web sites, and it was only possible to go online with a desktop PC.
Use IBM Rational Data Architect to take control of your DB2 database
(Anson Kokkat) Rational Data Architect (RDA) extends your data modeling capability and reaches far beyond typical database design. Use RDA to build strong logical or physical data models and realize your design into real world working database structures. View changes before they are made using RDA’
Five common Ajax security challenges and how to address them
(Brian Eastwood) Ajax is not an application vulnerability per se. However, the programming model does make existing vulnerabilities more porous, and JavaScript-powered client-server interactions does enlarge the attack surface. (R)
Viper 2 : Automatic Storage Tablespace Listings
(Philip Nelson) I suppose a lot of you are already diving into the Viper 2 Open Beta.
Building Interactive User Interfaces with Microsoft ASP.NET AJAX: Using the UpdatePanel
(Scott Mitchell) In AJAX Basics and Getting Started with Microsoft’s ASP.NET AJAX Framework we looked at the basics of the ASP.NET AJAX framework. We discussed how to download and install the framework and the basics of the UpdatePanel. The UpdatePanel makes creating interactive user interfaces as e
Using the SqlDataReader Class
(Michael Youssef) If you read any of my previous ADO.NET articles you will find that I used the SqlDataReader class in many of the examples. Today we will talk more about the SqlDataReader class and use its methods and properties. Some of you may wonder how the SqlDataReader class gets access to the
Hashing in Oracle
(Steve Callan) The internal workings of the Oracle RDBMS are a marvel to behold. Think about all of the things you do know with respect to what it takes to issue a select statement, perform an update, or create a table. Latches, locks, serialization, caching, pinning, flushing, checkpointing, sortin
4-Tier Architecture in ASP.NET with C#
(SheoNarayan) Almost all of us must have heard about 3-Tier architecture but what is this 4-Tier architecture? What are the benefits and how it is different from other architectures?