Looking Back: 2016 was Awesome!
With 2017 starting this week I would like to take a moment and reflect on 2016. I have to admit...
2017-01-05
428 reads
With 2017 starting this week I would like to take a moment and reflect on 2016. I have to admit...
2017-01-05
428 reads
With 2017 starting this week I would like to take a moment and reflect on 2016. I have to admit that 2016 was a great year for many different...
2017-01-05
5 reads
Three reasons why I am attending PASS Member Summit in 2016
Over the past few weeks, I saw on social media...
2016-10-26
468 reads
A few months ago, I posted a question over on ask.sqlservercentral.com. In a nutshell, it was how do you measure...
2016-09-06 (first published: 2016-08-24)
2,518 reads
Today, I want to focus on how we can monitor wait statistics in an Azure SQL Database. In the past,...
2016-08-30
1,015 reads
Unfortunately, with Azure SQL Database you are not able to take an existing SQL Server Backup and restore it on...
2016-08-01 (first published: 2016-07-26)
2,253 reads
There are a lot of new features in SQL Server 2016. Availability Groups by itself got a lot of new...
2016-07-12 (first published: 2016-06-29)
3,096 reads
My First Microsoft SQL Server MVP Award
Today, I have achieved an SQL Someday moment. I am excited to share some exciting...
2016-07-01
580 reads
I love Azure and I love PowerShell. They are a perfect marriage. It’s amazing how much automation you can do...
2016-06-23
507 reads
The Austin SQL Server User Group will host its third SQL Saturday on Saturday,
SQL Saturday Austin on January 30th, 2016
January...
2016-01-12
468 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