Presentation Styles
I had a chance to watch a few different styles this week at TechEd, and I think it helped that...
2010-06-11
627 reads
Blog Posts
Presenting Data and Information
I got this flyer in the mail recently.
It was for a seminar by Edward Tufte, and it caught my eye...
2010-06-11
369 reads
The Football World Cup
This day only comes around once in every four years, we've all been waiting for it for months. It's been...
2010-06-11
592 reads
We’re Well into Q2
I saw a post from Seth Phelabaum on SQLServerCentral reviewing his goals as of Q2. About 20 days premature, but...
2010-06-11
305 reads
2010 Goals – Q2 Review
Another quarter gone, and unfortunately I’m still looking about the same on goal progress. Still looking good on Blog posts...
2010-06-10
1,015 reads
Daily SQL Server 2008 New Feature – Day 20
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-10
396 reads
I’m a Pain
Or maybe I’m misreading that I’m supposed to be helping to alleviate pain. Either way, next Thursday, June 17, I’ll be...
2010-06-10
550 reads
Interesting Case of SSIS Failures
Interesting Case of SSIS Failures
We had an interesting case of SSIS failures recently where the cause ended up being improved...
2010-06-10
1,053 reads
Killer I/O
Here’s a big statement
WHEN WRITING DATABASE QUERIES, 95% OF THE TIME THE BOTTLENECK IS IN THE I/O, not the CPU,...
2010-06-10
964 reads
My Anonymity is Fading
I’ve done a good amount to raise my profile over the years. Not with that intention, but as I’ve tried...
2010-06-10
401 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
sp_prepare and sp_execute vs sp_executesql
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
Find Invalid Objects in SQL Server
Comments posted to this topic are about the item Find Invalid Objects in SQL...
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