Have You See The Latest *2* SQL Server Shows? From SSWUG.ORG, these are currently available: – SelectViews – the weekly show about the database world – SQLonCall – Tips, tricks, lessons learned in the field, from www.sqloncall.com Featured Article(s) Granting Privileges Quickly on SQL Server (For the Oracle or SQL Server DBA) Oracle DBA’s moving to SQL Server find it […]
Other News
Explaining How DB2 Will Get Data for a Given SQL Statement
(Troy Coleman) When developers are writing SQL statements to retrieve data they aren’t always thinking about how DB2 is going about accessing that data. The SQL query is written then executed to verify the correct data is being returned. Unless some kind of change control or standards are put in pla
LAST_INSERT_ID(expr) – The lesser known usage
(Ronald) I am of the attitude, the day you stop learning something is the day you die. I’m not prepared to induce MySQL into both sides of that equation, however some days it never ceases to amaze me what little thing I didn’t know about MySQL.
Implement ASP.NET AJAX with the UpdatePanel control
(Tony Patton) The ASP.NET 2.0 AJAX Extensions 1.0 add-on brings AJAX development to ASP.NET developers using existing ASP.NET style coding. This article is a continuation of my look at how to use the ASP.NET AJAX controls with more advanced scenarios. I begin with using multiple UpdatePanel controls
How to display the contents of a column of ANYDATA data type in SQL
(Frank Zhou) The following two SQL patterns can be used to display the contents of a column of ANYDATA data type in a single SQL statement.
An Introduction to .NET for Beginners
(Tim Patrick) Welcome to .NET! I might as well have said, “Welcome to the Solar System,” because like the solar system, .NET is huge. And it’s complex. And it’s filled with black holes and other things that don’t always make sense. Yet it (.NET, not the universe) turns out to be a fantastic system i
Error message when you run a distributed query against a loopback linked server in SQL Server 2005: ‘Transaction context in use by another session’
When you run a distributed query against a loopback linked server in Microsoft SQL Server 2005, you receive various error messages. Usually, you receive one of the following error messages: Error message 1 Msg 3910, Level 16, State 2, Line 1 Transaction context in use by another session. Err
Authenticating Users with ASP.NET AJAX
(Dan Wahlin) ASP.NET 2.0 provides built-in membership management capabilities that allow applications to log users into and out of a Web site with minimal coding. Simply run the aspnet_regsql.exe tool to add Microsoft’s membership database into your chosen database server (otherwise, a SQL Server 20
Introducing IBM Lotus Expeditor V6.1.1
(Keith Carter) This article provides an overview of IBM Lotus Expeditor and its components and features. Learn how you can use it to develop managed client applications that run on desktops, laptops, tablets, and handheld devices.
Preparing for MySQL 5.x Certification
(Mark Schoonover) You’ve decided to obtain MySQL certification and that’s great! Now it’s a matter of how to go about it? You can go the traditional routes and take a class, or you can prepare on your own. I did the latter, and 2 exams later during MySQL Conference 2007, I passed the Certified MySQL