One of the ways that some companies deal with the lack of a DBA is with remote DBA services or perhaps part time consulting. Robert Pearl brings us a short article explaining what these services can do for you.
2008-10-15
1,539 reads
Part two of the interview looks at some design decisions in building a warehouse as well as some of the tools available.
2008-03-27
1,231 reads
An interview with a data warehousing expert Chuck Kelley with some views about the careers in data warehousing.
2008-03-26
1,618 reads
Are you considering upgrading from SQL Server 2000 to SQL Server 2005? Are you using Full-Text Search? One of the top SQL Server consultants in New York walks us through an interesting issue that you might want to consider before migrating your databases.
2008-01-18 (first published: 2007-03-08)
15,094 reads
If you have not had the chance to work with SQL Server 2005, or even if you have, Robert Pearl brings us some important information about what your upgrade or installation of the next version of SQL Server will bring. This is information every administrator needs to know to get prepared.
2008-01-11 (first published: 2005-06-29)
199,300 reads
Service Pack 2 for SQL Server 2005 has had a few issues and one of the big ones is maintenance plans. Longtime DBA and developer Robert Pearl, of Pearl Knowledge Solutions brings us a fix for your maintenance plans.
2007-04-18
10,432 reads
64-bit SQL Server is coming!! Are you ready for this new technology? Chances are most of you are like us in that you've never had a 64-bit machine around and you likely don't remember the transition from 16-bit to 32-bit. Do you even want to make the transition? Is it worth it? New author Robert Pearl brings us a first look at how the 64-bit version of SQL Server will differ from the 32-bit version.
2006-12-08 (first published: 2004-05-26)
29,385 reads
With the release of SQL Server 2005, the paradigm of working with this database changed. Robert Pearl brings us a book review of the highly acclaimed book from one of the premier SQL Server consulting companies in the US: Scalability Experts.
2006-11-01
4,290 reads
Continuing on an interview with Raj Gill, SQL Server 2005 Roadshow Presenter by Robert Pearl. Get inside the mind of the co-founder of Scalability Experts.
2005-09-15
16,938 reads
An interesting interview with Raj Gill, SQL Server 2005 Roadshow Presenter by Robert Pearl. Get inside the mind of the co-founder of Scalability Experts.
2005-09-01
12,880 reads
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Comments posted to this topic are about the item Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers