A colleague working on an Informix database needed to search TEXT columns using wildcards. While Informix supports wildcards in LIKE and MATCH predicates, this support does not include TEXT columns. The obvious solution—to export the data to SQL Server—does support such searches.
Auditing is becoming more important all the time for DBAs as regulations and requirements increase. Building auditing into your systems can be done a number of ways, but with SQL Server 2005, you have a new option. New author David Ziffer brings us a generic auditing CLR trigger.
In Part 2 of this series, Wes Dumey talks about some of the key tables in a data warehousing scenario. He covers fact tables, dimensions and some of the other tables you'll see in a data warehouse. Free registration required.
As a DBA you might not need to build connection strings for your servers very often, but developers certainly need to build these all the time and might contact you for help. Author Raj Vasant takes a look at the new capabilities of .NET 2.0, which can really help make this easier.
In this video, you'll see how to use the SQL Server Integration Services Fuzzy Lookup Transform to match data that may've been mistyped. Use this transform to stop data duplication.
Continuing with his fantastic series on data warehousing. Vincent Rainardi brings us the next installment, which takes a look at upgrading the various components of your data warehousing system.
In Part 1 of this extensive series, Wes Dumey starts some of the core concepts of data warehousing. In this video he covers what a data warehouse is, why companies use them and what are some of the key components.
Perl has been a popular language for Unix administrators for years. It is flexible, easy to learn, and capable of doing some very powerful things with relatively few lines of code. In this article by Brian Kelly, he shows you how to connect to SQL Server via Perl.
In this video series, Wes Dumey shows you some of the core basics of data warehousing. Free registration required.
One of the responsibilities of the Microsoft.com operations team is to manage the infrastructure that supports the Windows Update and Microsoft Update services, which have client bases in the hundreds of millions and growing. The Windows Update site provides critical updates, security fixes, software downloads, and device drivers for Windows operating systems. Microsoft Update is the service that brings you all the features and benefits of Windows Update.
Every organization I talk to has the same problem dressed up in different clothes....
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item Using OPENJSON
Comments posted to this topic are about the item Data Modeling with dbt for...
I have some data in a table that looks like this:
BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beerIf I run this, what is returned?
select t1.key
from openjson((select t.* FROM Beer AS t for json path)) t1 See possible answers