(Marcin Policht) In the most recent articles of our series dedicated to SQL Server 2005 Express Edition, we have been discussing a number of tasks that modify default settings applied during standard installation, resulting in a variety of functional improvements. Throughout this discussion, we have
Other News
Dr. Unknown, or how I learned to stop worrying and love the NULL
(Hugo Kornelis) Two months ago, I posted the first two parts of a series about NULL. After that, I went quiet. Much to do and little time was one excuse. But to be honest, I also lost interest. However, I felt I owe my readers to conclude the series, so I have now forced myself to write and publish
Build code portability between SQL Server environments
(Denny Cherry) SQL Server code portability is, unfortunately, a lost art these days for many programmers and database administrators. Some newer professionals in the field are unaware of the importance of code portability or its importance for maintaining a stable scalable multi-environment infrastr
The Eternal DBA Conflict
New SQLonCall Show Is Live In this week’s show, Chris talks about how to get started on the job as a DBA: Your First Month on the Job – Things to think about, working triage on the job, lessons learned. Find out about how to dig through the noise and figure out where you should start. > Watch the Show […]
SQLonCall: Your First Month on the Job – Things to think about, working triage on the job, lessons learned.
Pro-Center Video Programming for IT Professionals
Moving from SQL Server 2000 to SQL Server 2005 Security
Featured Article(s) SQLCMD — Part I (Vadivel Mohanakrishnan) This is the first of the three part series on SQLCMD of SQL Server 2005. The target audience of these articles are Basic to intermediate level readers. Need to Get Up To Speed on BI? BI is a core requirement for many companies and something that many people are struggling with – […]
Overview of RowSet Objects
(Herong Yang) RowSet is a new concept introduced in the JDBC specification. A RowSet object is designed to represent a container of tabular data from any data source. A RowSet object may obtain data from a database server through a JDBC driver, it may also obtain data from a spreadsheet, a flat file
The Most Important DB2 for z/OS Performance Metric
(Robert Catterall) I don’t mean to imply that effective DB2 performance monitoring and tuning comes down to tracking one number – there are about a dozen or so DB2 monitor fields on which I tend to focus in my work. I do feel that one metric stands alone as being the most useful and most illuminatin
A Step-by-Step Guide To Using MySQL with ASP.NET – Part 4
(Ziran Sun) The first part of this article illustrated how to install and configure the MySQL Database Server, install and use the MySQL Administrator, create a new database, and create and populate a new sample table with some sample data.
T-SQL Tip: Use NOCOUNT = ON
(George P. Alexander Jr.) Most .Net developers spend a lot of time on the database writing Stored Procedures for their applications. At first shot, you think more of functionality over performance. Once you’ve got functionality ready, you probably take a look at getting the maximum performance from