Retrieve data from different data sources such as Analysis Services and SQL Server relational database as one dataset, so that you can create tables, matrices of that data.
2008-09-17
9,997 reads
Microsoft products such as Windows Server Update Services (WSUS) 3.0 and Windows Sharepoint Services (WSS) 3.0 ship with SQL Server 2005 Embedded Edition. Now called the Windows Internal Database, more and more system administrators charged with managing WSUS and WSS are faced with the challenge of managing these databases. Since most of these system administrators are not full-fledged DBAs, how do they manage the Windows Internal Database?
2008-09-17
3,273 reads
Part 1 of this series discusses the prerequisites for SQL Server cluster installation. Subsequent installments will provide step-by-step examples of SQL Server 2008 cluster installation.
2008-09-17
1,778 reads
Coordinating the release of software among all the groups involved can be quite a chore. Steve Jones comments on some of the challenges.
2008-09-17
70 reads
Coordinating the release of software among all the groups involved can be quite a chore. Steve Jones comments on some of the challenges.
2008-09-17
97 reads
Coordinating the release of software among all the groups involved can be quite a chore. Steve Jones comments on some of the challenges.
2008-09-17
61 reads
Integration Services is the ETL platform for SQL Server. In this installment of SQL School, Brian Knight shows how to add a timestamp (current date) to the name of a file.
2008-09-16
4,540 reads
Meaningful change often requires information collection, processing, retrieval and distribution. As database professionals, that's our bag. So what can we do to help things along?
2008-09-16
66 reads
Meaningful change often requires information collection, processing, retrieval and distribution. As database professionals, that's our bag. So what can we do to help things along?
2008-09-16
72 reads
Meaningful change often requires information collection, processing, retrieval and distribution. As database professionals, that's our bag. So what can we do to help things along?
2008-09-16
75 reads
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...
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
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 The Problem Isn't Always Your...
Comments posted to this topic are about the item Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers