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.

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,182 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, 121 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, 8 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,831 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, 8 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,319 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, 6 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, 148 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, 8 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, 176 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, 10 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, 528 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, 9 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, 154 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, 7 reads

Posted in SQL Barbarian on 28 April 2015

SQL Sentry Pro Explorer is worth it...

UPDATE: 2015-04-28 15:49
- I created a few autohotkey scripts and solved the problem of collapsing panes and a few other annoyances. This has improved my experince a little. - Also noted one major improvement that would help with tuning is aggregating the total IO, and stats, rather than only… Read more

0 comments, 241 reads

Posted in SQL Barbarian on 22 April 2015

SQL Sentry Pro Explorer is worth it…

UPDATE: 2015-04-28 15:49 – I created a few autohotkey scripts and solved the problem of collapsing panes and a few other annoyances. This has improved my experince a little. – Also noted one major improvement that would help with tuning is aggregating the total IO, and stats, rather than only… Read more

0 comments, 6 reads

Posted in SQL Barbarian on 22 April 2015

Statistics Parsing

Never really enjoyed reading through the statistics IO results, as it makes it hard to easily guage total impact when you have a long list of tables.

A friend referred me to: http://www.statisticsparser.com/

This site is great! However, I really don't like manually copying and pasting the results each time.… Read more

0 comments, 6,305 reads

Posted in SQL Barbarian on 21 January 2015

Statistics Parsing

Never really enjoyed reading through the statistics IO results, as it makes it hard to easily guage total impact when you have a long list of tables. A friend referred me to: http://www.statisticsparser.com/ This site is great! However, I really don’t like manually copying and pasting the results each time.… Read more

0 comments, 6 reads

Posted in SQL Barbarian on 21 January 2015

Dev Tools: FARR2 Launching groups of files or apps at once

There are probably a common number of apps you pull up when you pull up your system. For example, I pull up my Trello board, outlook, XYplorer, Sublime text 3, Sql server management studio, and ketarin (app updater).

Found that you can easily setup a simply alias and launch a… Read more

0 comments, 321 reads

Posted in SQL Barbarian on 16 January 2015

Older posts