Desktop Edition Sql server 2000 MSDE Install upgrade
for sql server 2000 (I know its old) desktop edition does not includes any GUI. so installation of desktop edition...
2012-02-21
2,438 reads
Blog Posts
Find Dependencies
Here's a script from my toolbox I use to find dependencies between SQL objects. The where clause has a number...
2012-02-21
1,041 reads
First Impressions
I was chatting with a friend recently who had been in turn chatting with a colleague about first impressions. The...
2012-02-21
968 reads
How to Upgrade SQL Server 2000 Instance to SQL Server 2005
Introduction
The purpose of this tutorial is to lay out the general guidelines for planning a SQL Server 2005 upgrade. As...
2012-02-21
1,938 reads
I see no SQL Server 2008 Counters in Perfmon?
This problem is a real pain and I’m yet to determine why this issue occurs because my understanding is SQL...
2012-02-21
4,618 reads
PASS Virtual Chapter: SSIS Enhanced Threading Framework
I'll be giving a presentation tomorrow, Tuesday 2/21/2012 at 12PM EST on my Enhanced Threading Framework design. Here is the...
2012-02-21
412 reads
Please vote for my SQLRally session
I’m hoping to do a presentation at SQLRally in Dallas on May 10-11, but I need your help!
There is a...
2012-02-21
725 reads
Shameless Plug: Vote For My Sessions!
Have you voted yet for my sessions your favorite sessions for SQL Rally? If not, this is a friendly reminder...
2012-02-21
620 reads
Show Us Your Coolest SSRS Reports
I’ll show you mine if you show me yours. Over the past nine years or so, I have showcased many...
2012-02-21
915 reads
SSIS Script Component Source -- Proc/Select Stmt
I've been asked on several occassions to provide an example of the custom sources I use in my "SSIS Tips&Tricks"...
2012-02-21
1,343 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers