T-SQL Tuesday #096: Inspiration Abounds
Who Inspires You?
Today is a bit of a divergence from the usual geekery that may abound on my blog. As...
2017-11-15
427 reads
SQL RNNR
T-SQL Tuesday #096: Inspiration Abounds
For me, this is about much more than just a story or two about people that have impacted me in my career choices. This topic is also about much...
2017-11-15
SQL Server Haunt 2017
Halloween is a great time of year. It is unfortunate that it is just one day of the year. That...
2017-11-01
447 reads
SQL Server Haunt 2017
The undead of Halloween are now upon us. Among the hordes of data zombies roaming the streets in lab-coats and fishnet stockings, few of us are still scrambling to...
2017-11-01
What’s that SSIS Password
A recurring theme over the past several weeks (there are always recurring themes it seems) has been an issue that...
2017-10-30
1,353 reads
What’s that SSIS Password
From time to time it is necessary to find a way into an SSIS package that is password protected. This article will help you find your way in to...
2017-10-30
37 reads
Drop That Schema
An often under utilized or maybe even mis-utilized feature of SQL Server is a database object schema. In the event of...
2017-11-09 (first published: 2017-10-27)
2,234 reads
Drop That Schema
An often under utilized or maybe even mis-utilized feature of SQL Server is a database object schema. In the event of the latter, there is an occasional requirement for change.
Related...
2017-10-27
5 reads
Seattle SQL Pro Workshop 2017 Schedule
Seattle SQL Pro Workshop 2017
You may be aware of an event that some friends and I are putting together during...
2017-10-26
393 reads
Seattle SQL Pro Workshop 2017 Schedule
Free workshop on SQL Server leading up to Summit 2017 that will provide attendees an alternate means to increase affordable learning opportunities during the week.
Related Posts:
Seattle SQL Pro Workshop...
2017-10-26
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