-->
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: 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, 5,077 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, 627 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,789 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, 212 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, 536 reads

Posted in SQL Barbarian on 1 June 2015