Finding Top Offenders with Extended Events
This week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing...
2018-03-06
285 reads
This week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing...
2018-03-06
285 reads
This week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing workloads and doing analysis on them. T-SQL or other...
2018-03-06
2 reads
T-SQL Tuesday #96: Folks Who Have Made A Difference
Today’s blog post is about T-SQL Tuesday. If you haven’t seen T-SQL...
2017-11-14
956 reads
Today’s blog post is about T-SQL Tuesday. If you haven’t seen T-SQL Tuesday before its a great monthly call for all SQL Server bloggers to write about one topic...
2017-11-14
4 reads
In some DBA circles, backups are just as popular as politicians! However, recoverability is the most important task for database...
2017-11-10 (first published: 2017-10-31)
2,587 reads
In some DBA circles, backups are just as popular as politicians! However, recoverability is the most important task for database administrators. While SQL Server 2017 added so many great...
2017-10-31
51 reads
Speaking on Migrating to Azure SQL Database at Ignite 2017
This week I will have two talks on migrating existing database...
2017-09-25
364 reads
This week I will have two talks on migrating existing database to Azure SQL Databases at Microsoft Ignite. If you are there and curious about migrating your existing databases...
2017-09-25
2 reads
These days I do a lot of testing with SQL Server. When I am testing new features or helping clients...
2017-03-10
647 reads
These days I do a lot of testing with SQL Server. When I am testing new features or helping clients implement SQL Server High Availability solutions I want to...
2017-03-10
31 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