Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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.

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, 104 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, 10 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, 149 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, 175 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, 2,666 reads

Posted in SQL Barbarian on 5 August 2015

Database Stuck in Single-User Mode Due to Botched Restore

Working in a development environment, I botched up a restore. After this restore attempt to overwrite my database with the previous version, I had it stuck in single-user mode.

SSMS provided me with helpful messages such as this:

Changes to the state or options of database 'PoorDb' cannot be made… Read more

0 comments, 1,500 reads

Posted in SQL Barbarian on 28 July 2015

What was I thinking? Deleting myself from localdb?

Was testing a batch file to add a user to a localdb instance. Assumed that my user as admin on the machine wouldn't have an issue inserting myself back.... didn't think that one through too carefully.

Executing any type of SQLCMD against it denied me. SSMS denied me. No SA… Read more

0 comments, 140 reads

Posted in SQL Barbarian on 13 July 2015

What was I thinking? Deleting myself from localdb?

Was testing a batch file to add a user to a localdb instance. Assumed that my user as admin on the machine wouldn’t have an issue inserting myself back…. didn’t think that one through too carefully. Executing any type of SQLCMD against it denied me. SSMS denied me. No SA… Read more

0 comments, 19 reads

Posted in SQL Barbarian on 13 July 2015

Download SSMS 2015 as a standalone download.... finally!

I'm excited to see the future of Sql server management studio with release of SQL Management Studio 2015 Preview. http://bit.ly/1LSu0Ek

Two of the points made on the website look very promising:

New SSMS Installer - SSMS can now be installed with a light weight stand-alone web installer.

SSMS Updates -…

Read more

0 comments, 2,966 reads

Posted in SQL Barbarian on 30 June 2015

Download SSMS 2015 as a standalone download…. finally!

I’m excited to see the future of Sql server management studio with release of SQL Management Studio 2015 Preview. http://bit.ly/1LSu0Ek Two of the points made on the website look very promising: >New SSMS Installer – SSMS can now be installed with a light weight stand-alone web installer. >SSMS Updates –… Read more

0 comments, 29 reads

Posted in SQL Barbarian on 30 June 2015

Some simple examples of querying xml with sql

XML is a beast if you've never tackled it. Here are some simple examples of what I discovered as I experimented and walked through obtaining values out of a XML column.

Read more

0 comments, 2,391 reads

Posted in SQL Barbarian on 24 June 2015

Some simple examples of querying xml with sql

XML is a beast if you’ve never tackled it. Here are some simple examples of what I discovered as I experimented and walked through obtaining values out of a XML column.

Read more

0 comments, 14 reads

Posted in SQL Barbarian on 24 June 2015

Enabling Instant File Initialization

Found a couple good walkthroughs on enabling instant file initialization. However, I'm becoming more familar with the nuances of various setups and found it confusing in trying to map the correct user/group to enable this option.

In my case, I had the SQL Service running under NT SERVICE/MSSSQLSERVER and as… Read more

0 comments, 160 reads

Posted in SQL Barbarian on 1 June 2015

Enabling Instant File Initialization

Found a couple good walkthroughs on enabling instant file initialization. However, I’m becoming more familar with the nuances of various setups and found it confusing in trying to map the correct user/group to enable this option. In my case, I had the SQL Service running under NT SERVICE/MSSSQLSERVER and as… Read more

0 comments, 20 reads

Posted in SQL Barbarian on 22 May 2015

Upgrade from SQL 2014 Evaluation to Developer Edition

Couldn't find documentation showing that upgrade from SQL 2014 evaluation version was possible to developer edition. I just successfully converted an evaluation version to developer edition.

  1. Obtain the key for the developer edition (in my case I had to download the .ISO from MSDN downloads, and go through the installation…

Read more

0 comments, 197 reads

Posted in SQL Barbarian on 4 May 2015

Upgrade from SQL 2014 Evaluation to Developer Edition

Couldn’t find documentation showing that upgrade from SQL 2014 evaluation version was possible to developer edition. I just successfully converted an evaluation version to developer edition. 1. Obtain the key for the developer edition (in my case I had to download the .ISO from MSDN downloads, and go through the… Read more

0 comments, 38 reads

Posted in SQL Barbarian on 4 May 2015

Utilizing the power of table parameters to reduce IO, improve performance, decrease pollution, and achieve world peace...

I was dealing with a challenging dynamic sql procedure that allowed a .NET app to pass in a list of columns and a view name, and it would generate a select statement from this view. Due to requirements at the time, I needed the flexibility of the "MAIN" proc which… Read more

0 comments, 563 reads

Posted in SQL Barbarian on 30 April 2015

Utilizing the power of table parameters to reduce IO, improve performance, decrease pollution, and achieve world peace…

I was dealing with a challenging dynamic sql procedure that allowed a .NET app to pass in a list of columns and a view name, and it would generate a select statement from this view. Due to requirements at the time, I needed the flexibility of the “MAIN” proc which… Read more

0 comments, 23 reads

Posted in SQL Barbarian on 30 April 2015

Restoring a database that doesn't exist

When restoring a database that doesn't exist, say for instance when a client sends a database to you, you can't use the option to restore database, because there is no database matching to restore. To get around this you need to use the Restore Files and Filegroups option and then… Read more

0 comments, 166 reads

Posted in SQL Barbarian on 28 April 2015

Restoring a database that doesn’t exist

When restoring a database that doesn’t exist, say for instance when a client sends a database to you, you can’t use the option to restore database, because there is no database matching to restore. To get around this you need to use the Restore Files and Filegroups option and then… Read more

0 comments, 15 reads

Posted in SQL Barbarian on 28 April 2015

Older posts