Annoyances
Working with others can be a challenge. This Friday's poll asks for those little annoyances in the workplace and how to deal with them.
2009-03-26
304 reads
Articles
Annoyances
Working with others can be a challenge. This Friday's poll asks for those little annoyances in the workplace and how to deal with them.
2009-03-26
814 reads
I've been slowly looking at and experimenting with LinkedIn to see if it has value and if so, how to unlock it in a way that works for me. I mentioned it during my series on networking and since I've evolved a strategy that I think is interesting...
2009-03-26
2,334 reads
How to Get the Scripts for SQL Server Objects
Using VB Script allows one to script out all the Sql Server objects in independent file.
2009-03-25
10,023 reads
Gail Shaw: Geek of the Week
Gail Shaw, the fabled 'gilamonster', earned her MVP and the gratitude of a host of SQL Server professionals seeking technical help with her expert forum posts on SQLServerCentral. She brings great enthusiasm to everything she does, and has a huge influence on the communities she joins.
2009-03-25
2,216 reads
SQL Server Disasters
I joined in late to a conference call this morning from Quest where a number of their experts were talking about various disaster stories that they'd experienced over the years. It's great to hear real DBAs talking about the problems and challenges...
2009-03-25
4,163 reads
The Need for Tape
Are tape systems obsolete? A recent incident has Steve Jones thinking perhaps not.
2009-03-25
931 reads
The Need for Tape
Are tape systems obsolete? A recent incident has Steve Jones thinking perhaps not.
2009-03-25
745 reads
The Need for Tape
Are tape systems obsolete? A recent incident has Steve Jones thinking perhaps not.
2009-03-25
689 reads
Deploying Scripts with SQLCMD
Deploying changes to your SQL Servers can be a challenge. Longtime SQL Server expert David Poole brings us a new article looking at a solution using SQLCMD.
2009-03-24
14,583 reads
Blogs
Why Developers Shouldn’t Have sysadmin access in SQL Server
Why Developers Shouldn’t Have sysadmin access in SQL Server 7 reasons—and exactly what to do instead It...
A New Word: Ecstatic Shock
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
Forums
The Foundation of a Successful Doctoral Journey
Writing a PhD proposal is one of the most crucial steps in academic research....
sp_prepare and sp_execute vs sp_executesql
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
Question of the Day
Who am I?
If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below?
create procedure AddNewCustomer
@customername varchar(200)
AS
BEGIN
DECLARE @added VARCHAR(100)
SELECT @added = xxx
IF @customername IS NOT NULL
INSERT dbo.Customer
(
CustomerName,
AddedBy
)
VALUES
(@customername, @added)
END See possible answers