SSIS-DTS Package Search 2.0.18 released
SSIS-DTS Package Search 2.0.18 has been released. This is a bug fix release that addresses a problem with the search...
2010-06-08
813 reads
Blog Posts
TechEd 2010 – BI Keynote – Part 1
The second day’s keynote is by Ted Kummert and focuses on BI.
This keynote is in one of the smaller...
2010-06-08
554 reads
TechEd 2010 – BI Keynote Part 2
In the customer demo, a few reports that were built with PowerPivot and Report Builder 3.0, which are helpful to...
2010-06-08
558 reads
TechEd 2010 – Interview With Herain Oberoi
Herain Oberoi is a Group Product Manager for SQL Server and spent 30 minutes with me talking about StreamInsight and...
2010-06-08
548 reads
TechEd 2010 – Monday Afternoon/Evening
After the keynote went back to the press room to write up notes (which I posted already), check email, eat...
2010-06-08
485 reads
TechEd 2010 – Tuesday Morning
Leisurely morning, leaving for the convention center about 8 am. Bus service has been great, they have a staff person...
2010-06-08
472 reads
The BI Conference at TechEd
It’s a bad idea. Co-locating the BI conference at TechEd has created a lot of confusion and annoyance. If people...
2010-06-08
534 reads
The Parallel Data Warehouse Edition of SQL Server 2008 R2 – TechEd 2010
It’s the million dollar question. Literally.
I stopped by the SQL Server area at TechEd in the expo to talk to...
2010-06-08
1,178 reads
T-SQL Tuesday # 07: Walkthrough for Sysprep in SQL Server 2008 R2
T-SQL Tuesday # 07: Walkthrough for Sysprep in SQL Server 2008 R2
This blog entry is participating in T-SQL Tuesday #007, hosted...
2010-06-08
4,911 reads
T-SQL Tuesday #007 - Policy Based Management
It's that time of the month again, time for the next round of T-SQL Tuesday posts. This month is being...
2010-06-08
978 reads
Blogs
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...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
Forums
Find Invalid Objects in SQL Server
Comments posted to this topic are about the item Find Invalid Objects in SQL...
Lessons from the Postmark-MCP Backdoor
Comments posted to this topic are about the item Lessons from the Postmark-MCP Backdoor
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