Future of Database Mirroring
One of the beloved feature of SQL server standard edition for HA is database mirroring, since you only have 2-node...
2015-03-12
477 reads
One of the beloved feature of SQL server standard edition for HA is database mirroring, since you only have 2-node...
2015-03-12
477 reads
Most companies required to keep their database backup offsite (on tape) for many years due to audit requirement. This normally...
2015-03-12
962 reads
2015 should be a very busy year for most DBAs, due to the end of support of SQL server 2005...
2015-02-06
313 reads
I have been following a few blogs for a number of years now, and one of the most enjoying blog...
2015-02-02
281 reads
We all know that with the latest Windows 2012 R2 and SQL 2014, even with the standard edition, it can...
2014-11-14
403 reads
Every DBA in their career should have done DR drill at some point, in fact it should be done in...
2014-09-18
2,381 reads
You might already read lots of post about SQL server 2012 is license per core rather then per socket and...
2014-04-07
512 reads
Many of us are planning to move to SQL Server 2012 in the coming year, and one of the feature...
2014-04-01
323 reads
Every now and then we all need to perform backup or restore, for large databases when we need to perform...
2013-10-09
610 reads
Everyone knows that installing SQL server requires .Net frameworks 3.5, and it normally install by default, when you run the...
2013-03-12
586 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...
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