Do you want intellisense for Query Analyzer? Many people would love this amazing enhancement that has long been available for Visual Studio users. It is now available as an add-in from PromptSQL and Brian Kelley reviews this amazing product.
2006-01-18
10,248 reads
As we all know, SQL Server 2005 has new features when compared to SQL Server 2000. One of the features that we are going to discuss in this article is the Row_Number() function. SQL Server Database administrators and developers have been longing for this function for a long time--now the wait is over.
2006-01-18
4,705 reads
In this series of articles, you will learn the basics of installing Microsoft Operations Manager 2005 as well as how to use MOM to monitor SQL Server. This article takes advantage of virtualization. We will use VMware Workstation 5 to create the lab to introduce you to the basics of installing MOM to monitor SQL Server.
2006-01-17
3,401 reads
It's not recommended, but sometimes writing scripts against the system tables and getting information is a great way to work with SQL Server. Alex Grinberg brings us a look at some of the things you can get from system tables along with some sample scripts.
2006-01-16
14,555 reads
A question came up on an internal alias about how can one download a file over HTTP. Here's a script that does that, should be trivial to wrap it inside a task if you forsee doing this over and over again.
2006-01-13
2,470 reads
This shows you how to use the Script Transform to make intelligent decisions about your data and clean it appropriately.
2006-01-13
1,104 reads
In this review, Brian reviews one of his favorite tools in his DBA toolkit. He shows you some of the new features in this event management system and how it can shave hours off your day each day.
2006-01-12
6,687 reads
Continuing the coverage of debugging features in SQL Server 2005 Integration Services Data Flow, which we started in the previous installment of this series, we will now focus on the Script Component.
2006-01-12
1,301 reads
SQL Server 2005 has deprecated osql and isql as command line tools and replaced them with SQLCMD. Haidong Ji brings us an introduction to this new tool and a few tricks to make you more productive when using it.
2006-01-11
18,520 reads
sqlSentry, a leading developer of management solutions for Microsoft SQL Server, today announced that it has released the 64-bit version of its industry-leading scheduling and notification management system for SQL Server 2005, supporting both x64 and Itanium-based systems.
2006-01-11
2,716 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...
Telp/Wa 62 8218200233 Gama Tower Lt. Dasar Unit B, Jl. H. R. Rasuna Said...
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...
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