Monitoring group of Linked Sql Servers from a Sql Server
The main purpose of article is to understand how to monitor group of Linked Sql Servers from a Sql Server.
2009-07-08
2,443 reads
Articles
Querying the Procedural Cache on Canada Day (July 1st)
The goal of this post is to understand the procedure cache and execution plans to ensure we use fewer resources and that queries run better. Better means higher throughput, more concurrency and fewer resources – as described by MVP Joe Webb during SQLTeach in Vancouver just last month.
2009-07-08
1,134 reads
Instead of Trigger, Part 1 - SQL School Video
If you have never used an instead of trigger, it's a great mechanism for evading table triggers in certain situations. MVP Andy Warren brings you part one of this SQL School video.
2009-07-07
7,521 reads
10+ tips for working smarter with SQL
The sharper your SQL skills become, the more robust and error-free your solutions will be. Here are a dozen practical tips to get you started
2009-07-07
7,621 reads
Limit Groups by Number Using Transact-SQL or MS Access
You can easily limit or group a recordset, but doing both to the same recordset takes a bit of hand coding. Find out how both SQL Server and MS Access can handle the task.
2009-07-07
2,354 reads
SSIS - Creating a Deployment Manifest
Using a Deployment Manifest in SSIS allows you to deploy a set of packages to a target location using a wizard for installing your packages. The benefit to using it is the nice user interface that a wizard provides. The disadvantage of using it is it’s lack of flexibility. When using the Deployment Manifest keep in mind...
2009-07-07
1,458 reads
SQL Server Memory Configuration, Determining MemToLeave Settings
Tweaking SQL Server memory settings to provide support for managed code.
2009-07-06
12,346 reads
Different ways to execute an SSIS package
In SQL Server 2005 and higher versions there are different ways in which one can execute an SSIS package. Let us go through each option one by one.
2009-07-06
4,591 reads
How to Identify Important Characteristics for a DBA Job Candidate
In the last year or so, there have been a lot of articles, blog entries,and forum posts on the kinds of technical questions hiring managers can ask a prospective DBA candidate in order to determine their technical proficiency. While technical skills are...
2009-07-06
2,966 reads
Resources for Upgrading to SQL Server 2008
Use these resources as aids in upgrading to SQL Server 2008. These references are from the downloadable white paper:
2009-07-06
2,842 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Happy Holidays, Let's Do Nerdy Stuff
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers