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.
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Comments posted to this topic are about the item Having a Little Fun at...
Comments posted to this topic are about the item Designing SQL Server Pipelines That...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers