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,500 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,213 reads
An interview with a data warehousing expert Chuck Kelley with some views about the careers in data warehousing.
2008-03-26
1,596 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,026 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,265 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.
2007-09-22 (first published: 2004-05-26)
29,358 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,397 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,265 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,911 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,846 reads
Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest...
By Vinay Thakur
Microsoft announced on November 2024 a preview for SQL Server 2025 another major release...
By Steve Jones
How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse –...
Hello! SQL Clustered resource used to come online during manual or automatic failover in...
Code that can be used in order to create dashboard or SSRS report on...
So, I have an interesting situation that I need a double-check on. One of...
I have this data in a SQL Server 2022 table:
PlayerIDPlayerNamePlayerStatus 1The \%ChampActive 2The ChampActive 3The_ChampionActive 4The__ChampionActive 5The\_ChampActiveHow many rows are returned by this code in SQL Server 2022?
select PlayerName from player where playername like 'The\_C%' escape '\'See possible answers