When life intrudes
I have MVP Raymond Lewallen in my list of blogs to follow. I read with great sadness the following blog...
2006-04-26
1,455 reads
Blog Posts
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...
2006-04-25
1,584 reads
Turn the Problem Around
A few weeks ago we had a failure on the web site. Actually a hard failure, a BSOD, which I...
2006-04-25
1,377 reads
2006-04-19
1,490 reads
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...
2006-04-06
3,780 reads
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...
2006-04-05
2,124 reads
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...
2006-04-04
1,432 reads
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...
2006-04-03
1,504 reads
12-inch grass stem?
Those of us in technology are very, very used to automated systems,
batch jobs, etc., all which run without human interaction...
2006-03-29
1,348 reads
Internet Explorer Vulnerability
If you're using Internet Explorer, be advised Microsoft has released a
security advisory for Internet Explorer. This would allow an attacker
to...
2006-03-28
1,546 reads
Blogs
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Forums
how to calculate an average only if a minimum number of records exist?
Hi I am working on a rolling average calculation that is not working quite...
Subscribing to a Great New Year
Comments posted to this topic are about the item Subscribing to a Great New...
dont want pkg to abort if someone is in excel source document
Hi, is there a way when using excel as a flat file source in...
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers