Choosing a backup solution can be a trying exercise with all the various add on products these days. New author David Bird gives us some insight into his testing and decisions with a look at Litespeed and Tivoli's Storage Manager.
2006-03-28
8,073 reads
SQL Server 2005 has substantially enhanced its ETL capabilities, but many people will still be working with DTS in SQL Server 2000 for many years. New author James Greaves brings us a technique for working with imports and handling files that might not have any data.
2006-03-27
6,831 reads
With a new version supporting SQL Server 2005, Periscopde for SQL Server is offering a 25% discount for SQLServerCentral.com members. This product helps with performance monitoring.
2006-03-27 (first published: 2005-10-05)
3,870 reads
Healthcare applications come and go, but data live on forever. We’ve seen that since the beginning of the computer industry; when we move from legacy systems into more “modern” architectures, we often leave behind applications, but we almost always take along the data into the future. Even though data are so important, we in health-IT don’t seem to spend the quality time necessary to structure our schemas and databases in such a way as to make it easier to maintain in the future. We often don’t design our data models solidly, and we don’t test them well by putting them through simulations or design them for multiple versions.
2006-03-27
2,502 reads
Are you mad? Not angry, more like crazy when it comes to designing databases in SQL Server? Don Peterson has met a few people he thinks are just that when it comes to building lookup tables. Does it stem from poor understanding of database design? Or do you disagree? Read Don's case against this particular design practice.
2006-03-24 (first published: 2004-09-08)
52,689 reads
Gartner has stated in the past that "configuration management is at the very heart of IT service management." What do you mean by this?
2006-03-24
1,964 reads
There are a few upcoming SQL\SSIS\Developer events coming up in the next week. Andy Warren and Brian Knight will be speaking at Code Camp in Orlando (a free full day event) and Brian will be doing a SSIS event in Philadelphia. For more information, see this blog post.
2006-03-23
1,631 reads
You may be wonderfully up-to-date with an AJAX Web interface or the latest whizbang Windows user interface, but under the covers, you're probably still pumping data in and out of a database, just as we all did a decade or more ago. That makes it all the more surprising that developers are still making the same database mistakes that date back to those good old days of Windows 95 and before.
2006-03-23
6,331 reads
There are many changes in SQL Server with the release of SQL Server 2005, but none more telling than the client tool used to manage your servers. Check out this new e-book for learning about SQL Server 2005 Management Studio form SQLServerCentral.com.
2006-03-22
5,603 reads
It is an interesting question and one I hope every DBA can answer positively. New author Thomas LaRock brings us his method for ensuring that the backups have occurred and the files are still on disk.
2006-03-21
8,058 reads
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
The STIG is detailed, which is a good thing, but I found myself wanting...
Comments posted to this topic are about the item RegEx Functions III
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Comments posted to this topic are about the item Finely Tuned Models
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers