Events

SQLServerCentral Editorial

Why Tech Events Matter for Data Pros (and why I’m grateful)

  • Editorial

I just got back from the Redgate Summit events in New York City, where I had the chance to present, swap stories, and nerd out with a lot of brilliant data folks. I came home energized… and then promptly slept for 14 hours on Thursday. That’s the best kind of exhaustion in my book.  The […]

5 (1)

You rated this post out of 5. Change rating

2025-08-23

47 reads

SQLServerCentral Editorial

What Sport Would You Play?

  • Editorial

We’re halfway through the Olympics, with all the usual drama – highs, lows, special interest stories - and even a surprise hero in Yusuf Dikec at the 10-meter air pistol (the memes have been strong with this one). As I was talking with my children this week, one of them asked, “So dad, what sport […]

You rated this post out of 5. Change rating

2024-08-04 (first published: )

48 reads

External Article

Meet Redgate at PASS Virtual Summit

  • Article

Redgate are Gold sponsors of PASS Virtual Summit, which this year is available to all online. It's time to accelerate your data career by joining Redgate's Advocates who will be presenting a variety of sessions, as well as demo solutions throughout the week of 11 - 13 November. See what's happening and register today.

2020-11-09 (first published: )

Technical Article

SQL in the City Summits – UK, US & Down Under

  • DatabaseWeekly

Redgate are inviting senior data professionals to attend one of the upcoming SQL in the City Summit events taking place in April, May and June. If you’re interested in learning how your business can benefit from implementing Compliant Database DevOps this event is for you. Find out who’s presenting and register for a Summit near you today.

You rated this post out of 5. Change rating

2019-04-05

Technical Article

5th annual “Seattle Freecon”

  • Article

On Monday, November 5th, 2018, the 5th annual “Seattle Freecon” (a FreeCon in Seattle for those that might not be attending a pre-con before the PASS Summit) will be held. Put on by Jason Brimhall and Wayne Sheffield, there’s a set of 6 sessions you can attend for free that day. That’s right, absolutely FREE.

You rated this post out of 5. Change rating

2018-11-02 (first published: )

3,203 reads

SQLServerCentral Article

Registration Now Open for SQL Cruise Alaska in August 2017

  • Article

It’s been a while since SQL Cruise has been in Alaska, but come August 12 2017 we are returning in a big way for our 13th event since our founding in 2010, bringing one of the most sought-after minds in Microsoft SQL Server for a week of instruction, conversation, and insight: Bob Ward. The SQL […]

5 (2)

You rated this post out of 5. Change rating

2017-05-19

383 reads

Blogs

From Firefighting to Future‑Building: SQL Server 2025 and the New DataOps Mindset

By

There are moments in technology when the ground shifts beneath our feet. Moments when...

Why Developers Shouldn’t Have sysadmin access in SQL Server

By

 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

ecstatic shock – n. a surge of energy upon catching a glimpse from someone...

Read the latest Blogs

Forums

sp_prepare and sp_execute vs sp_executesql

By rajemessage 14195

I have noticed sp_executesql also makes a single plan for a stmt with parameter...

Who am I?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Who am I?

Find Invalid Objects in SQL Server

By Nisarg Upadhyay

Comments posted to this topic are about the item Find Invalid Objects in SQL...

Visit the forum

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