Building HTML Emails With SQL Server and XML
Building HTML Emails With SQL Server and XML
I’ve written a lot of custom reports in my days that output data...
2010-06-15
62,551 reads
Blog Posts
Daily SQL Server 2008 New Features – Day 23
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-15
412 reads
DBA Hell
On the first day of DBA hell, the server gave to me
A database with damaged system tables and no good...
2010-06-15
961 reads
Hawaii is Not Prometric Microsoft Certification Test Friendly
While I was at TechEd last week, I got a 50% off Microsoft Certification test voucher that expires on June...
2010-06-15
1,492 reads
Insert Unknown Row to Dimension Table
When building a warehouse there is a common practice of adding an Unknown row to the Dimension tables. For me,...
2010-06-15
1,408 reads
Networking – A Year Later
I was excited to attend the networking session last year at the PASS Summit. Andy Warren and I had talked...
2010-06-15
658 reads
oPASS Meeting Tonight June 15, 2010 – Featuring Kendal Van Dyke
We’re meeting from 6-8 pm as usual, with Kendal Van Dyke presenting Paging Dr Availability, You’re Wanted In the Recovery...
2010-06-15
304 reads
Report Render Duration
Every once in a while I come across a scenario where I really want to know how long it took...
2010-06-15
554 reads
Sarasota SQL Server Users Group
Tonight I’m presenting for the Sarasota SQL Server Users Group. If you’re interested in attending, you can join in using...
2010-06-15
708 reads
SQL Server XML Schemas
Ever been curious about the schema of , say an SSRS rdl file ? How about the execution plan ?
Not only should...
2010-06-15
491 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