With the release of SQL Server 2005 Express Edition and the SQL Server Management Studio Express, Microsoft has entered the small, free database market with a splash trumping even their own Microsoft SQL Desktop Edition. Although it is free, it is still important for you to install this application correctly, Scott Lowe shows you how.
As a DBA, stress is probably a given in your career, but are you aware of the effects on others. Andy Warren takes a look at the effects of stress, how you can identify them and a few ways to cope.
True business value lies in using the data model as an entry point for a program of data management that treasures data as the most valuable corporate asset.
What does a SQL Server developer care about the Enterprise Library? SQL Server guru David Poole is starting to work with .NET and brings us his perspective on what this library is and how it benefits those who develop against SQL Server.
So you've created a SQL Server package and now you're ready to integrate it into your Visual Basic application? In this series, Brian Knight will show you how to use the DTS object model to execute a DTS package from Visual Basic.
This article explains how to transform a nebulous application requirement like "take a flat file that was produced by an upstream mainframe application and produce an XML document for a downstream application," into a flexible working solution.
Do you know how to setup a read-only table in SQL Server. Steve Jones takes a look at a few methods to achieving this and examines the pros and cons of choosing different methods.
Support information consumers with easier navigation and more focused analysis choices. In this article, BI Architect Bill Pearson leads hands-on exposure to Perspectives, another new Analysis Services 2005 feature.
Before you start learning how to cluster, this video will show you the basics on how clustering in Windows 2003 and SQL Server 2005 works. Brian shows the basic architecture on clustering as well as the checklist that you would want to follow before starting to cluster.
What type of things do you need to look at when setting up a data warehouse? Hardware is a big one as well as the settings for the server, which may be substantially different than transactional systems most DBAs work with. Warehousing expert Vincent Rainardi brings us the next installment in his data warehousing series with some advice on what you should be looking for.
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers