-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Barbarian

After working in the mortgage industry for 7 years, I transitioned into Business Intelligence and began learning SQL and .NET. My goal is to integrate my business knowledge into my development to intelligently analyze and find solutions to problems. Blogging offers me an option to share what I've learned as well as receive feedback on better practices and solutions.

Archives: January 2016

Easy way to test log shipping or availability groups setup

Have been working through the fantastic training resources from Brent Ozar’s Everything Bundle and on the recommended resources they mention after all the training on log shipping and availability groups that you can use a lab environment from TechNet to actually get going on familiarizing yourself with the technology more. Read more

2 comments, 423 reads

Posted in SQL Barbarian on 29 January 2016

Easy way to test log shipping or availability groups setup

Have been working through the fantastic training resources from Brent Ozar’s Everything Bundle and on the recommended resources they mention after all the training on log shipping and availability groups that you can use a lab environment from TechNet to actually get going on familiarizing yourself with the technology more. Read more

0 comments, 231 reads

Posted in SQL Barbarian on 29 January 2016

Transaction Logging & Recovery (part 3)

Transaction Logging & Recovery (part 3)

… Continuation of some notes regarding the excellent content by Paul Randal in *Pluralsight: SQL Server: Logging, Recovery, and the Transaction Log. Please consider supporting his excellent material by using Pluralsight and subscribing to his blog. He’s contributed a vast amount… Read more

0 comments, 605 reads

Posted in SQL Barbarian on 20 January 2016

Transaction Logging & Recovery (part 3)

… Continuation of some notes regarding the excellent content by Paul Randal in *Pluralsight: SQL Server: Logging, Recovery, and the Transaction Log. Please consider supporting his excellent material by using Pluralsight and subscribing to his blog. He’s contributed a vast amount to the SQL server community through… Read more

0 comments, 178 reads

Posted in SQL Barbarian on 20 January 2016

Verifying Instant File Initialization

Verifying Instant File Initialization

Ran into a few issues verifying instant file initialization. I was trying to ensure that file initialization was enabled, but found out that running the xp_cmd to execute ‘whoami /priv’ could be inaccurate when I’m not running it from the account that has the privileges. This… Read more

0 comments, 129 reads

Posted in SQL Barbarian on 13 January 2016

Verifying Instant File Initialization

Ran into a few issues verifying instant file initialization. I was trying to ensure that file initialization was enabled, but found out that running the xp_cmd to execute ‘whoami /priv’ could be inaccurate when I’m not running it from the account that has the privileges. This means that if my… Read more

0 comments, 173 reads

Posted in SQL Barbarian on 13 January 2016

Transaction Logging & Recovery (part 2)

Transaction Logging & Recovery (part 2)

… Continuation of some notes regarding the excellent content by Paul Randal in Pluralsight: SQL Server: Logging, Recovery, and the Transaction Log. Please consider supporting his excellent material by using Pluralsight and subscribing to his blog. He’s contributed a vast amount to… Read more

0 comments, 233 reads

Posted in SQL Barbarian on 8 January 2016

Transaction Logging & Recovery (part 2)

... Continuation of some notes regarding the excellent content by Paul Randal in Pluralsight: SQL Server: Logging, Recovery, and the Transaction Log. Please consider supporting his excellent material by using Pluralsight and subscribing to his blog. He’s contributed a vast amount to the SQL server community through SQLSkills Read more

0 comments, 138 reads

Posted in SQL Barbarian on 8 January 2016

Transaction Logging & Recovery (101)

Logging & Recovery Notes from SQL Server Logging, Recovery, and the Transaction Log (pluralsight) Paul Randal

Going to share some key points I’ve found helpful from taking the course by Paul Randal at pluralsight. I’ve found his knowledge and in detail presentation extremely helpful, and a great way to expand… Read more

0 comments, 233 reads

Posted in SQL Barbarian on 5 January 2016

Transaction Logging & Recovery (101)

Logging & Recovery Notes from SQL Server Logging, Recovery, and the Transaction Log (pluralsight) Paul Randal

Going to share some key points I’ve found helpful from taking the course by Paul Randal at pluralsight. I’ve found his knowledge and in detail presentation extremely helpful, and a great way to expand… Read more

0 comments, 153 reads

Posted in SQL Barbarian on 5 January 2016