Get Your Own Blog
If you would like to blog on SQLServerCentral.com then send an email to
Contact the author
for this blog
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.
Best Tools for Taking Notes In Development
Developers have a lot to juggle. Do a few of these things sound familiar:
- Juggle current sprint tasks
- Resolve outstanding issues needing immediate attention
- Research/Professional Development
- Long term development objectives that you can only get fragments of time to work on
- Performance testing…
Not quite fineprint, but sure feels like it!
Quotename can be a pretty cool function to simplify your dynamic sql, as it can ease some of the escaping of strings.
However, I normally use it for table/column names, and so hadn’t ran into a “gotcha” of this function until today. Read more
XML handling with aliases
I find it interesting the difference in behavior with querying XML between column assignment, and quoted alias naming.
It’s a generally understood best practice to not use the deprecated syntax of column aliasing using a quoted name. For example:
select Read more
[escapedWithBracketsIsGood] = case when raining then…
Split personality text editing in SSMS with Sublime Text 3
My preview post showed a demonstration of the multi-cursor editing power of Sublime Text 3 when speeding up your coding with SQL server.
There is a pretty straight forward way to setup sublime (or one of your preferred text editors)… Read more
- Yes… multicursor editing is epic
- No… SSMS doesn’t support multi-cursor editing the way it should.
- Yes… you can do some basic editing with multiple lines using alt-shift
- No… it doesn’t come close to what you can do with Sublime.
Cool thing is you can open text in Sublime synced w/SSMS… Read more
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
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
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
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
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…
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
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
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
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
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
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 -…
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
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.
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.
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