I am Speaking at 2013 PASS Member Summit!
Speaking at PASS Summit 2013
Every single year I look forward to the PASS Member Summit. In a nutshell it is...
2013-05-30
1,271 reads
Speaking at PASS Summit 2013
Every single year I look forward to the PASS Member Summit. In a nutshell it is...
2013-05-30
1,271 reads
It’s time for T-SQL Tuesday the forty-second, Wendy Pastrick asked that we talk
T-SQL Tuesday!
about our experiences with change in our work lives. I’d...
2013-05-14
567 reads
Typically, I am a big advocate of performance monitor but one place I commonly see performance monitor being misused is with benchmarking...
2013-03-06 (first published: 2013-02-25)
4,318 reads
The following is a recording of my Performance Tuning for Pirates session recorded by UserGroup.TV at SQL Saturday 125 in...
2013-01-14
930 reads
[UPDATE] Video recording from PASS Virtual Performance Chapter’s Winter 2012 Performance Palooza can be found here.
I am a huge fan...
2012-12-05
867 reads
The following is my highlights and thoughts about the day two keynote at the SQL PASS Member Summit.
Douglas McDowell started...
2012-11-08
685 reads
The following are five recommendations I would like to share with anyone attending the #sqlpass member summit. I hope you...
2012-11-07
693 reads
I love the SQL Community because it usually is a great environment to connect, share and learn. With that said,...
2012-10-30
1,614 reads
First SQL Saturday in Pittsburgh
It was an honor to speak at the first SQL Saturday in Pittsburgh. The company I
We...
2012-10-12
622 reads
Tonight, October 8th at 6:30pm I am virtually speaking at the OKC SQL Server User Group. I had a blast...
2012-10-08
537 reads
By Kevin3NF
Parts 1, 2 and 3 got you to the (SQL) engine room. Now we...
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...
Immediate need for a hands-on SQL Server DBA. This is a greenfield opportunity to...
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