(Jeff McWherter) I have found myself working on projects where reports have been last minute additions that demanded a great deal of time and a certain touch of detail. Many times, reports are cobbled together, with good design and performance falling to the wayside. Reports are the primary represe
Other News
Oracle BI Publisher Date-type
(David Vandecraen) You can only format dates when they are in the canonical date format. This format looks like: YYYY-MM-DD HH24:MI:SS.
Enterprise Data Management: Governing for Data Security
(Deb Jenson) Not so long ago, the always-on phenomenon of Internet computing pushed performance and availability to the top of IT departments’ lists. Today, one concern tops even those: data governance. The basic organizational need to keep unauthorized eyes away from sensitive data (corporate secre
DST checking with Windows Powershell
(Yan Pan) As a DBA working at a global financial services company, I face a tough task each year – making sure that SQL Server hosts around the globe change time correctly whenever there is a Daylight Saving Time (DST) event in the US or EU (luckily AS does not observe DST for now). Incorrect time o
Reporting MySQL Internals with Information Schema plug-ins
(Roland Bouman) Last week, I described how to use the MySQL plug-in API to write a minimal ‘Hello world!’ information schema plug-in. The main purpose of that plug-in is to illustrate the bare essentials of the MySQL information schema plug-in interface.
Five Different Ways To Return Data From One Table Which Doesn’t Exists In another Table
(Denis Gobo) There are at least 5 ways to return data from one table which is not in another table. Two of these are SQL Server 2005 and greater only. This is a post mostly for beginners but hopefully everyone will get something out of it.
Index Compression Part II (Down Is The New Up)
(Richard Foote) Compression can be very beneficial when the compressed columns of an index have many repeated values within a leaf block as these repeated values are only stored once and referred to by relatively small pointers within the index row entries themselves.
Five sqlcmd features to automate SQL Server database tasks
(Roman Rehak) Sqlcmd is one of the command line utilities included with SQL Server 2005. It was designed for executing SQL scripts and replaces the osql utility that came with previous versions of SQL Server. In addition to executing SQL code, it also executes so-called “sqlcmd extensions.” These ex
Tempdb Configuration Best Practices in SQL Server
In SQL Server 2005, TempDB has taken on some additional responsibilities. As such, some of the best practice have changed and so has the necessity to follow these best practices on a more wide scale basis. In many cases TempDB has been left to default configurations in many of our SQL Server 2000
Lots of SQL Server Webcasts Coming Very Soon!
Latest SQL Server Show, SelectViews, Posted Today’s show is a sample session from the virtual conference – TSQL101 – this session is an intro primer into using TSQL. Find out about the basics, see a sample session from the conference and, while you’re at it, pencil in that third week in June… > Watch Here Also Available [Watch] SQLonCall – […]