-->
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: August 2015

Brentozar’s Training: Chocolate & Cowboy Hats Included

It was entertaining to listen to a technical wizard fighting the obsession with waiting to eat chocolate with 3k viewers watching. Kendra wore about 4-5 cowboy hats in an effort to help those of us who wear many hats feel welcome…. Now that’s the kinda of training I enjoy! No… Read more

0 comments, 209 reads

Posted in SQL Barbarian on 27 August 2015

Brentozar's Training: Chocolate & Cowboy Hats Included

It was entertaining to listen to a technical wizard fighting the obsession with waiting to eat chocolate with 3k viewers watching. Kendra wore about 4-5 cowboy hats in an effort to help those of us who wear many hats feel welcome…. Now that’s the kinda of training I enjoy! No… Read more

0 comments, 99 reads

Posted in SQL Barbarian on 27 August 2015

Monitoring SQL Server on a budget

Monitoring SQL Server on a budget

Cheap ain’t easy

There’s a lot of tools out there, and very few that are polished, have a good UI, and some reasonable functionality to help monitoring, that don’t cost an arm and a leg. One such tool I’ve recently begun to appreciate is… Read more

0 comments, 225 reads

Posted in SQL Barbarian on 18 August 2015

Monitoring SQL Server on a budget

Monitoring SQL Server on a budget

Cheap ain’t easy

There’s a lot of tools out there, and very few that are polished, have a good UI, and some reasonable functionality to help monitoring, that don’t cost an arm and a leg. One such tool I’ve recently begun to appreciate is… Read more

0 comments, 172 reads

Posted in SQL Barbarian on 18 August 2015

Stranger Danger… The need for trust with constraints

I ran into an issue with errors with an database upgrade running into a violation of a foreign key constraint. Don’t know how it happened. Figured that while I’m at it, I’d go ahead and evaluate every single check constraint in the database to see if I could identify any… Read more

0 comments, 323 reads

Posted in SQL Barbarian on 13 August 2015

Red Gate SQL Source Control v4 offers schema locks

Red Gate Documentation Update

Looks like the rapid release channel now has a great feature for locking database objects that you are working on. Having worked in a shared environment before, this could have been a major help. It’s like the poor man’s version of checking an object out in… Read more

0 comments, 184 reads

Posted in SQL Barbarian on 12 August 2015

Using Qure Profiler To Benchmark Tuning Progress

the problem of monster views

I’ve been working with tuning an application that performs a lot of Entity framework calls, as well as stored procedure activity. The stored procedures could be processing a large amount of data, or a small amount, depending on the configuration of the client. The major…

Read more

0 comments, 841 reads

Posted in SQL Barbarian on 10 August 2015

SET NOEXEC is my new friend

Have never really played around with the option: SET NOEXEC ON

Turns out this can be a helpful way to validate larger batch scripts before actually making changes, to ensure compilation happens. If you choose, you can verify syntax by “parsing” in SSMS. However, this doesn’t compile. Compilation checks more… Read more

0 comments, 986 reads

Posted in SQL Barbarian on 7 August 2015

Running very large scripts is not a strong area for SSMS

out of memory, argggh!

Am I the only one that has experienced the various out of memory issues with SSMS? Not according to google!

lovingly crafted in the forges of.. well … dbforge

I’ve a huge fan of Devarts products. I’ve done a review in the past on their SQL… Read more

4 comments, 3,254 reads

Posted in SQL Barbarian on 5 August 2015