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.
2006-07-31
16,259 reads
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.
2006-07-31
2,785 reads
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.
2006-07-28 (first published: 2002-12-03)
42,234 reads
In this video series, Wes Dumey shows you some of the core basics of data warehousing. Free registration required.
2006-07-28
2,329 reads
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.
2006-07-28
1,321 reads
Not many people enjoy using Globally Unique Identifiers (GUIDs), partly because they are cumbersome to type and work with for humans. However they fill a need and can provide some interesting benefits. SQL Server expert Andy Warren takes us through what a GUID is and how you can use it easily in your code.
2006-07-27
16,348 reads
Every DBA needs to know how to do their work under pressure, while facing crisis after crisis. Our most important contribution is to keep the database running. It's an on-call function; you never know what might happen
2006-07-27
3,942 reads
So, you’ve just installed SQL Server 2005 but don’t know how to configure it. This video will instruct you how to use the SQL Server 2005 Surface Area Configuration tool to turn on SQL Server features like CLR integration and how to enable ports. Free registration required.
2006-07-27
2,298 reads
Are you frustrated by the limitations of the MMC console when managing dozens or hundreds or servers? The way Enterprise Manager is fitted into the framework can be a problem for DBAs with lots of servers. Jereme Guenther brings us a technique for his own console that solves some of the limitations of MMC.
2006-07-26
11,119 reads
Many of you were thrilled to see intellisense available for SQL Server editors, but there has been a bit of confusion about this product. An open letter from the CEO of Red-Gate Software clears things up.
2006-07-26
6,777 reads
By Steve Jones
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...
Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...
By Steve Jones
I hosted this month, late as it turns out, but we still had a...
Comments posted to this topic are about the item Create an HTML Report on...
We have an issue where SSIS packages are failing with a status of "ended...
Hi everyone! I'm new to SQL and am trying to query a view (dbo.)...
What does a slipstream installation mean?
See possible answers