Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes.
2007-09-22 (first published: 2003-06-05)
30,115 reads
One of the strongest features of SQL Server is the ability to connect to disparate data sources and perform queries across multiple sources. New author Basu Hullur brings us a technique that he used to update data on the AS/400 in a much quicker way than previously.
2007-09-22 (first published: 2006-04-05)
44,221 reads
One day, you may need to change those service credentials under which your SQL Server services normally run. If you have a number of servers, then you'll really want to read about Rodney's solution.
2007-09-21
2,360 reads
This article presents a strategy for testing ETL applications that perform data movement and populate data warehouses. It is useful information for the testing community as well as designers and managers charged with planning a data warehousing implementation.
2007-09-21
2,460 reads
SQL Server 2005 Integration Services changed the ETL paradigm for SQL Server developers and DBAs. SSIS expert Jamie Thomson has been working with this platform for a few years and brings us some real world knowledge based on a large project he completed in 2006. (Reprinted from the SQL Server Standard).
2007-09-20
7,667 reads
Developing an effective solution requires quality within and across all components of the BI architecture.
2007-09-20
2,840 reads
In the simplest terms, a NULL value represents an unknown value. It's unknown in the sense that the value is: missing from the system, may not be applicable in the current situation, or might be added later. NULL values are different than any other value and are sometimes hard to compare and handle.
2007-09-20
3,550 reads
The Cincinnati SQL Server Users group is getting going again with a meeting on Tuesday, September 25th. If you are in the area, check out the details.
2007-09-20
2,473 reads
This installment of the XML Workshop by Jacob Sebastian continues looking at XML Schemas in SQL Server 2005. Here we learn how the format and range of values can be checked using an XML schema.
2007-09-19
4,988 reads
SQL Server 2005 allows DBAs to set configurations for SSIS packages outside the package to facilitate a smooth transition between different environments.
2007-09-19
3,321 reads
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...
We need to replace our Windows server running SQL 2017. Any reason not to...
Comments posted to this topic are about the item Using OPENJSON
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