(Denny Cherry) Microsoft included several hundred stored procedures in the various versions of Microsoft SQL Server and it has documented a good percentage of them. But many stored procedures remain undocumented. Some are used within the Enterprise Manager GUI in SQL 2000 and were not intended to be
Other News
SQL Server Maintenance, Oracle Security and More
Watch the Latest SQL Server Show Watch SelectViews here – you could even win $200 just for providing feedback! I’d love to hear what you think of some proposed new sections on the show. Plus, find out about data relevance, moving data from Access to SQL Server in our MiniCast and much, much more. I even have a new somtimes-segment, […]
Asked & Answered
(Robert Catterall) Will tuning buffer pools lead to a reduction in package CPU TIME in the PM Accounting report? I expected to see a reduction in Elapsed time and Suspension time. I expected SRB time to shrink, but I thought the CPU TIME reported for each package would remain more or less the same.
Reporting XML data using Crystal Reports
(Asif Sayed) Reporting on data sources such as: MS Access, SQL Server and Oracle, is common with Crystal Reports (CR). How about XML as data source? Well, sure, you might be wondering how to do that? Is it even possible? Well, with help of this article I’ll show you how to use the XML data source an
Option Strict [On|Off|SortOf]
(Jonathan Aneja) Yesterday I got a question from a developer asking whether or not we could add something called “Option Strict Warn” to the language. This would give a developer a warning when using something like late binding or an implicit conversion, rather than disabling it altogether (through
How to debug InnoDB lock waits
(Xaprb) This article shows you how to use a little-known InnoDB feature to find out what is holding the lock for which an InnoDB transaction is waiting. I then show you how to use an undocumented feature to make this even easier with innotop.
Automate your Database Integrity checks using SMO
(Allen White) Once you’ve implemented a well thought-out backup plan you’ll want to perform regular optimization processes and check the integrity of your databases. These steps will help to keep the performance of your database activity at its peak. The integrity checks use DBCC CHECKDB commands to
DB2 on Mac
(Antonio Cangiano) We now have a working Python driver for DB2 which is currently undergoing internal testing. The driver is similar to the Ruby and PHP ones, which means that you get an advanced and very easy to use API. It also means that if you are confident with the Ruby driver, you will be able
SQL Server Reporting Services 2005 XML extensions
(Alexander Nowak) Microsoft SQL Server Reporting Services (SSRS) has support for a plethora of data sources. Out of the box, its data modules, called data extensions, allow you to build reports from SQL Server and Oracle database, as well as any other database that comes with an OLE DB or ODBC provi
Working with ASP.NET AJAX Timer Control
(Nidal Arabi) This article is the third one in a series of articles about Microsoft AJAX Extensions (previously named ATLAS, I like the old name better). The first one did speak about the UpdatePanel. The second one was about the UpdateProgress control. So keep coming back for more.