Support The Boss
Providing support for your manager or boss in getting his or her job is a good thing. Steve Jones comments on what benefits you might get and why this could enhance your career.
2009-10-05
646 reads
Articles
Using Transfer Error Messages and Transfer Master Stored Procedures Tasks in SSIS
DBA's can use the Transfer Error Messages and Transfer Master Stored Procedures tasks to transfer error messages and stored procedures between difference SQL Server instances.
2009-10-05
2,328 reads
Migrating SQL Server Databases - The DBA's Checklist (Part 3)
The final part of the series will examine full text catalogs and indexing, database collation, service broker considerations, encryption and high availability.
2009-10-02
3,303 reads
Off-Hours Work: A Guide For Managers
If you work in software development or IT long enough eventually you're going to find yourself in a situation where...
2009-10-02
2,012 reads
SQL Server 2008 Failover Clustering
This white paper complements the existing documentation on planning, implementation, and administration of a SQL Server 2008 failover cluster, which can be found in Microsoft SQL Server 2008 Books Online. There are links to relevant existing content throughout the paper, which is intended primarily for a technical audience. This white paper covers failover cluster architecture and concepts for Windows Server (2003 and 2008) and SQL Server 2008; installation of a SQL Server 2008 failover cluster; upgrades and updates to SQL Server 2008 failover clustering; and maintenance and administration of SQL Server 2008.
2009-10-02
3,698 reads
Effective Dating Series Part I - The Problem
What are the benefits of Effective Dating and what problems does it solve?
2009-10-01
10,189 reads
Explore XML Data Type in SQL Server
SQL Server 2005 and 2008 provide native XML data type and provides extensive support for XML data processing. The easy conversion from XML to a relational table provides a way for set-based updates based on user input.
2009-10-01
3,838 reads
Generating SQL Scripts using Windows PowerShell
In a previous tip on SQL Script Generation Programmatically with SMO, you've seen how you can use SMO to generate SQL scripts programmatically. In this tip I will cover how to generate scripts using Windows PowerShell.
2009-10-01
3,940 reads
The old INNER JOIN syntax vs. the new INNER JOIN syntax
I was in a presentation last week where the presenter was talking about the ANSI/ISO SQL standards. For the most part the...
2009-10-01
7,587 reads
TSQL Challenge #14
A new challenge is up. See if you are up for the task of identifying the longest sequence of characters in a string before Oct 12
2009-10-01
3,616 reads
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers