External Article

Azure Diagnostics for Virtual Machines

Hosting a scalable application in Azure seems ideal, but what happens when things go wrong? Azure Cloud Services provide extensive diagnostics, and this feature has now been extended to Azure web sites and Azure Virtual Machines. You need to set up diagnostics on the VM, but once this is done, all your logs, traces and performance counters can be collected from many VMs in one place for easy management.

External Article

Free PDF Booklet: 119 SQL Code Smells

Once you've done a number of SQL code-reviews, you'll be able to identify signs in the code that indicate all might not be well. These 'code smells' are coding styles that, while not bugs, suggest design problems with the code. In this PDF, Phil Factor's put together 119 of those code smells so you can see what to avoid and why.

Technical Article

SQL Saturday #333 - St. Louis, MO

SQL Saturday is coming to the St. Louis University Campus on Oct 11, 2014. SQL Saturday offers a full day of free SQL Server training and networking, some of the speakers at this event include Kathi Kellenberger, Stuart Ainsworth, and Abhishek Srivastava. If you're thinking of attending this event, please register while space is available.

Blogs

QUOTENAME Basics: #SQLNewBlogger

By

Recently I ran across some code that used a lot of QUOTENAME() calls. A...

When growing companies outgrow Excel

By

There are some telltale signs that your growing business has outgrown Excel for your...

T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?

By

Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...

Read the latest Blogs

Forums

Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments

By Massimo Preitano

Comments posted to this topic are about the item Stairway to Reliable Database Deployment...

QUOTENAME Quote Parameters

By Steve Jones - SSC Editor

Comments posted to this topic are about the item QUOTENAME Quote Parameters

Limit the Blast Radius

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Limit the Blast Radius

Visit the forum

Question of the Day

QUOTENAME Quote Parameters

When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?

See possible answers