Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 

Get Your Own Blog

If you would like to blog on SQLServerCentral.com then send an email to webmaster@sqlservercentral.com.

All Blogs

Feeds

Archives

Archives: April 2006

Checking SQL Server Versions

This question comes up enough on the forums and with SP1 for SQL Server 2005 released, I'll cover it again. You can get the version by unning SELECT @@VERSION on your SQL Server. The query will return something similar to:

Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
    Apr…

Read more

0 comments, 425 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 30 April 2006

Sharing Internet Connections?

This study out of the University of Illinois at Urbana-Champaign sounds great:

Software Allows Neighbors To Improve Internet Access At No Extra Cost

The way they are accomplishing higher throughput makes sense: use multiple paths. However, I'm not so sold on how secure this will necessarily be. The software has…

Read more

0 comments, 424 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 30 April 2006

More on xp_logininfo

In this post, I talked about using xp_logininfo in order to get the permission paths for a particular Windows account. If you've never used xp_logininfo, it can be a valuable tool when you're trying to figure all the ways a particular user account maps into SQL Server. After all,…

Read more

0 comments, 1,147 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 29 April 2006

Fix for SSIS SP1 "service failed to start" issue

I was catching up on my blog reading and found the following post from Jamie Thomson:

SSIS: Another SP1 problem

The post contains an explanation for the "The SQL Server Integration Services service failed to start due to the following error: The service did not respond to the start…

Read more

0 comments, 430 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 28 April 2006

Issues with SQL Server 2005 SP1

There have been reports of some issues with SQL Server 2005 SP1, especially with SQL Server Integration Services not starting as expected. If you're considering installing SP1, you'll probably want to verify the bug reports don't affect you:

Read more

0 comments, 475 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 27 April 2006

When life intrudes

I have MVP Raymond Lewallen in my list of blogs to follow. I read with great sadness the following blog post:

We lost a great would-be developer of the Lewallen family.


There is a link to the story of this little man's fight at the above link. Donation information is…

Read more

0 comments, 416 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 26 April 2006

Issues tracking members of the sysadmin fixed server role

I received an email from another DBA asking how to track a user who is probably mapping into SQL Server via BUILTIN\Administrators. The BUILTIN\Administrators group has maintained the default server role membership, meaning it's a member of the sysadmin fixed server role. How then do you show what user in…

Read more

0 comments, 422 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 25 April 2006

Turn the Problem Around

A few weeks ago we had a failure on the web site. Actually a hard failure, a BSOD, which I haven't seen in years. Of course I didn't know it was a BSOD. We were having issues on the web site so I rebooted the server on a Friday afternoon…

Read more

0 comments, 387 reads

Posted in The Voice of the DBA on 25 April 2006

SP1

Supposedly coming out today.

We'll see as the few announcements I saw were without links posted. Read more

0 comments, 422 reads

Posted in The Voice of the DBA on 19 April 2006

Determining if it's a SQL login, Windows Login, or Windows group

A recent question on the forums asked how to determine if a database user was a Windows user or group and what login did it correspond to? By matching up the SID on the database user and sql server login tables, you can find this information out. First, let's look…

Read more

1 comments, 436 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 6 April 2006

Kerberos Delegation with SQL Server Reporting Services and SQL Server

I've been dealing with Kerberos delegation setup with respect to Microsoft's CRM 3.0 product and while the process isn't difficult, if you miss one step, things don't work. That can be extremely frustrating, but there are some tools and web pages which help with configuration and troubleshooting. First the web…

Read more

0 comments, 536 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 5 April 2006

Is it The SQL Server?

In writing for a tech book one of the things that happens is a copy editor looks over your work and comments on the spelling mistakes, miswordings, grammatical errors and all the other "English" stuff you hated in high school. But it's good because many of us write more casually…

Read more

0 comments, 391 reads

Posted in The Voice of the DBA on 4 April 2006

March/April 2006 Edition of SQL Server Standard Available

The March/April 2006 edition of SQL Server Standard magazine is now available. This issue focuses on Transact-SQL for SQL Server 2005. Though I normally focus on the security side of things, I was able to get an article in on Common Table Expressions and Recursion. I used an example…

Read more

0 comments, 403 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 3 April 2006

 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.