Positive Blogging
Blogging is increasingly becoming a part of more and more people's lives. But to what extent should it be part of your corporate image? Steve Jones has a few comments about a very interesting blog he found.
2008-09-03
48 reads
Articles
SQL Server Clustering and Consolidation - Balancing Resources
Just because you have disk space, plenty of memory, and abundant CPU does not mean you can pile databases onto an instance of Microsoft SQL Server; you need to pay attention to load balancing. In the case of a clustered environment I take it one-step-removed: a step I like to call node balancing.
2008-09-03
2,763 reads
Tuning performance via disk arrays and disk
Tuning SQL Server performance means tuning hardware configurations and setup. Learn about configuring disk arrays and SQL disk partitioning alignment.
2008-09-03
4,568 reads
Renaming a Database
Expert trainer and longtime DBA, Andy Warren, tackles the rather simple, but often understood, process of renaming a database. Learn about some of the issues you might encounter when trying to complete this task.
2008-09-02
9,700 reads
Using Profiler - SQL School Video
A basic tutorial that examines how Profiler can be used in SQL Server 2005 to monitor your SQL Server instance. MVP Brian Knight shows how to create a trace and the various options you have for monitoring events.
2008-09-02
5,618 reads
Lost in Space
It seems a tremendous amount of data is lost every year on laptops in airports. Steve Jones talks about some of the issues with physical security and your portable computers.
2008-09-02
63 reads
Lost in Space
It seems a tremendous amount of data is lost every year on laptops in airports. Steve Jones talks about some of the issues with physical security and your portable computers.
2008-09-02
47 reads
Lost in Space
It seems a tremendous amount of data is lost every year on laptops in airports. Steve Jones talks about some of the issues with physical security and your portable computers.
2008-09-02
54 reads
Report Warns Of Data Warehouse 'Bottleneck' In Real-Time Analytics
In a report entitled "Really Urgent Analytics: The Sweet Spot for Real-Time Data Warehousing," Forrester advises intelligence and knowledge management professionals to familiarize themselves with the various approaches for adapting a data warehouse to meet real-time requirements, and, if necessary, consider bypassing the data warehouse altogether.
2008-09-02
2,038 reads
How To Use the Analysis Services Processing Task in SSIS 2005
We are looking to automate the processing of our SQL Server Analysis Services dimensions and cubes. We'd like to add this processing to our existing SQL Server Integration Services (SSIS) packages which periodically update our data warehouse from our OLTP systems. Can you give us the details on how the Analysis Services Processing Task can be used in an SSIS package?
2008-09-01
2,564 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers