Upcoming speaking engagements
Ayyyy, matey being that today is the International Speak Like a Pirate Day I thought it was appropriate to post some future...
2012-09-19
364 reads
Ayyyy, matey being that today is the International Speak Like a Pirate Day I thought it was appropriate to post some future...
2012-09-19
364 reads
Today I am excited to join in with my #sqlfamily and participate in this months #tsql2day throw down. This month Erin...
2012-07-18
444 reads
I currently have a presentation named Performance Tuning for Pirates. This presentation goes over using several free tools to help...
2012-07-12
1,354 reads
If you work with SQL Server and live in the Harrisburg area I have some great news for you. The...
2012-07-09
655 reads
This week I have two presentations on my schedule. I get to give my Performance Tuning for Pirates presentation twice...
2012-06-28
1,385 reads
Recently, I caught my during a kickoff with a new client saying, “Hello I am John, and I love SQL....
2012-05-10
493 reads
I have a confession to make. I like to meet people who also work with SQL Server. There are so...
2012-04-17
678 reads
By gbargsley
Whether you’re a seasoned DBA or just exploring database tools, DBeaver offers a powerful,...
DBAs should never run SSMS under their everyday Windows account If you open SSMS under...
The honeymoon is over, and macOS 26 Tahoe broke the Rosetta 2 emulation layer...
Import-Module ImportExcel # Path to your .sql file $sqlFile = "C:\Data\MyQueries.sql" $excelPath = "C:\Data\SqlExtract_$(Get-Date...
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
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) ENDSee possible answers