Adding a VLDB database to an SQL Server Availability Group
Recently, I was tasked with making an 60TB database highly available by adding it to an availability group. The following,...
2015-08-26 (first published: 2015-08-18)
2,074 reads
Recently, I was tasked with making an 60TB database highly available by adding it to an availability group. The following,...
2015-08-26 (first published: 2015-08-18)
2,074 reads
If I had a nickel for every time someone gave me a list of identifiers and asked me to pull...
2015-04-20 (first published: 2015-04-09)
5,791 reads
Recently, Mike Walsh and John Sterrett teamed up with Embarcadero to give a 60 minute presentation focusing on the skills...
2015-02-18
1,839 reads
Recently, I had the pleasure of writing another article that was included the Notes From the Field series that is hosted...
2014-12-17
563 reads
I have some great news to share. One of my bucket list items is to be a published author. I...
2014-10-02
680 reads
Whenever a disaster occurs it will be a stressful scenario regardless of how small or big the disaster is. This gets multiplied...
2014-06-09
752 reads
If you are near Pittsburgh, PA on May 22, 2014 catch the following all-day training session from 8:30 AM to 4:00...
2014-04-23
999 reads
In SQL Server 2012 we got this great new high availability feature called availability groups. With readable secondaries under the...
2014-03-21 (first published: 2014-03-18)
2,930 reads
T-SQL Tuesday is a monthly blog party hosted by a different blogger each month.
T-SQL Tuesday 50 – Automation
This blog party was...
2014-01-14
821 reads
I hope everyone is having a good time gearing up for the holidays. Throwback Thursday is a bi-weekly blog series where...
2013-12-12
686 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