Seattle SQL Pro Workshop 2017
Seattle SQL Pro Workshop 2017
October is a great time of year for the SQL Server and Data professional. There are...
2017-10-25 (first published: 2017-10-19)
1,125 reads
SQL RNNR
Seattle SQL Pro Workshop 2017
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-19
Linked Servers and Stats
Linked Servers
A linked server is a fabulous feature in SQL Server to help accomplish various data tasks between local and...
2017-10-17
1,183 reads
Linked Servers and Stats
A linked server is a fabulous feature in SQL Server to help accomplish various data tasks between local and remote servers. There is a time and a place for...
2017-10-17
239 reads
Your Name is Your Brand
This topic is one that has been stewing for a while and finally this week it decided to boil over.
My...
2017-10-13
472 reads
Your Name is Your Brand
Building your brand is not an overnight sensation. It does take a while and possibly a bit of luck here or there along the way. The one thing it...
2017-10-13
Endpoint Owners – Back to Basics
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2017-06-05
1,612 reads
Endpoint Owners – Back to Basics
"What the heck is an endpoint?" Well, that is a good question. An endpoint in the simplest form is a connection or point of entry into SQL server.
Related Posts:
Changing...
2017-06-05
33 reads
SSRS Subscription Schedules – Enhanced
Reporting Services
Over the past couple of articles I have illustrated some of the fun that can be had when dealing...
2017-05-25
1,097 reads
SSRS Subscription Schedules – Enhanced
With the ability to create content delivery schedules, or to subscribe to report content delivery, it becomes very important to also know when the various reports are scheduled to...
2017-05-25
284 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