SQL Server 2005 – Unattended installation – Part V
In this section of this series, I am going to demonstrate how to install SQL server 2005 service pack 1, to update the server components using command line options.
2006-08-14
1,548 reads
Additional Articles
Backup Basics Part 3: General Tips for a Backup Strategy
Knowing how to configure backup applications and select backup media is half the battle of designing a successful backup strategy. The other half is choosing how and when to back up the specific pieces of data that are stored on your servers, share points, and workstations. In this final article of his series on backup basics for new technicians and administrators, Ryan Faas offers some suggestions to help you make these important decisions.
2006-08-11
2,967 reads
Monitoring SQL Servers Availability
How many SQL Server instances are you running? Do you ever have customers calling you stating that their application is not working, then when you research the problem you find that the instance that supports their application is unavailable? Have you ever had someone mistakenly shutdown the SQL Agent service and forget to restart it, causing a number of scheduled jobs to not be run? One of the tasks of a DBA is to monitor the availability of all SQL Server instances and services.
2006-08-10
3,195 reads
Tuning .NET - Part One
As server-side .NET development becomes more prevalent, Application Performance Management tools are becoming available to fine-tune .NET applications. And, as in the past, it seems that the ability to build new and more sophisticated applications always stays ahead of the ability to manage them.
2006-08-09
2,130 reads
Using correlated sub-queries in SQL Server
A sub-query is a SQL Server statement embedded inside of another SQL Server statement. The database engine treats a sub-query as a virtual table for the execution of the query. A sub-query can be used as a table in a join statement, as a single value in a select statement, in the where clause of a SQL Server query, in the having clause of a SQL Server query, or incorporated in data manipulation statements.
2006-08-07
4,276 reads
Dumping Microsoft SQL Server: MySQL, PostgreSQL attract big users
So, you're a Microsoft SQL Server administrator flirting with open source, but you're not sure how far you should go on the first migration? Don't worry, there won't be much peer pressure to go "all the way." Look around and you'll find that most businesses making the switch are going only as far as their Web applications.
2006-08-04
3,016 reads
Committing imports in SQL Server a little at a time
A colleague working on an Informix database needed to search TEXT columns using wildcards. While Informix supports wildcards in LIKE and MATCH predicates, this support does not include TEXT columns. The obvious solution—to export the data to SQL Server—does support such searches.
2006-08-03
2,271 reads
Introduction to Data Warehousing Part 2 - DW Tables
In Part 2 of this series, Wes Dumey talks about some of the key tables in a data warehousing scenario. He covers fact tables, dimensions and some of the other tables you'll see in a data warehouse. Free registration required.
2006-08-02
2,444 reads
Introduction to Data Warehousing Part 1
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
Introduction to Data Warehousing
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
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers