1. Not using SSIS (and writing awful, single threaded non-tsql/non-SSIS code)

2. Not using SSSB (and writing awful polling jobs)

3. Not using SSRS (and destroying SQL servers instances because there's no...

Best instructions I've ever found (via Google) of setting up SSSB between two servers (or instances).

But ... The instructions terminate too early which leaves things in a SSSB Anti-Pattern called...

Another technique to try ...

On tables where you have columns that you'd otherwise build a FTS index, instead create a trigger that populates a single table where you string together...

Certificates are one way. But in a connected world Claims Based Identity/Authourisation makes much more sense as it pushes the management of who can do what into the "source" domain...

Thanks to gs-627439 and Raj Gujar ... After following all the MS supplied instructions the one that was missing was the ALTER DATABASE one. Makes sense I guess given where...

I have seen the "spoiled athlete" problem as well, and deep down I feel that it is due to the rate at which the demand tends to burn down the...

As the demand for IT services has gone up, many people have gotten inflated salaries and the ego to go with them.

This isn't any different from when I started...

Great arcticle, Solomon!

I used to do this with humongus mainframe databases for banks back in the 90s. And yes, you really can implement the change in seconds if you're well...

Anyone using the "free" version of SharePoint 2010?

SharePoint Foundation 2010 comes free with a Windows Server license and has some very funky features that used to be part of...

rob.lobbe-964963 (3/24/2011)

---

Also you're using SQL2008+. read up on "Filtered Indexes"

Create a filtered index on your main table that contains your PK, and filters on your delete criteria. This index will...

Great article Nakul.

Agree with all the comments about using smallish batch sizes to keep row level locks from escalating! Also, if the delete(s) involve hash matching, keeping to a...

Sorry guys. Left out the OPTION (RECOMPILE) in my haste. Added it in. Actually, in many situations you actually find through your performance testing with multiple parameter combinations (which of...

Hi punithmsc,

If you're on SQL2005 or above there's a SSRS SDK sample to do what you describe by extending rendering to include printing. You then use SSRS subscriptions to scheduled...

In a business context (i.e. getting the job done quickly, good quality and maintainable!)

VB.Net = simple, so productive

C# = techie, so less productive.

The difference comes down to the 80/20 rule;...

Hi Steve,

As an ex-DBA/Senior Developer and now a Enterpise Architect, I really encourage everyone to take the tour around SP/MOSS 2007 with all the Service Packs applied.

Don't expect the...