2014-12-04 (first published: 2014-11-17)
1,419 reads
Scripts
2014-12-02 (first published: 2014-11-12)
2,282 reads
Create Table At Runtime
With the help of this script we can generate Create Table Script At Run Time.
2014-11-27 (first published: 2014-11-06)
1,166 reads
Function for Proper Case - Most easiest way
This function is used to manage the alphabet case, which means the first letter of all the words will be in caps.
2014-11-26 (first published: 2014-11-03)
1,273 reads
Identify Missing Sequence/Identity Numbers
This script is used to identify the missing sequence numbers or identity numbers.
2014-11-20 (first published: 2014-10-29)
1,109 reads
2014-11-19 (first published: 2014-10-29)
1,130 reads
Upload Backup Files to Amazon S3
This script will upload the latest backup files to an AWS S3 bucket
2014-11-14 (first published: 2014-09-14)
1,738 reads
Report on existing user connections
List user connections and possibly any linked server connections older than 1 hour
2014-11-13 (first published: 2014-10-22)
1,690 reads
2014-11-11 (first published: 2014-07-25)
2,609 reads
2014-11-10 (first published: 2014-10-01)
1,344 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