Tag Archives: T-SQL

Finally, Create or Alter

There are lots of reasons to upgrade to SQL Server 2016, but this is the one for me. We finally get a CREATE OR ALTER statement in T-SQL. This not only makes lots of code easier to write, it means … Continue reading

Posted in Editorial | Tagged , | 2 Comments

#SQLNewBlogger – T-SQL ESCAPE for Wildcards

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran into a really interesting issue recently. I was working with a table and wanted to determine if … Continue reading

Posted in Blog | Tagged , , | 1 Comment

The GUI Helps Build SQL Prompt Snippets

SQL Prompt is an amazing tool for writing T-SQL. It helps you to concentrate on your code, without having to go off and examine Books Online or other documentation, or even worry about formatting. One of the keys to making … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Using TRY..CATCH in SQL Prompt

I learned something new recently about SQL Prompt. I was working on documenting and experimenting with snippets and found a quicker way to write code. One of the things I think is great is to use the TRY..CATCH structure. I … Continue reading

Posted in Blog | Tagged , , , | 1 Comment

Creating a Logon Trigger–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Suppose you want to audit logins for your SQL Server instance. There are multiple ways to do this, but … Continue reading

Posted in Blog | Tagged , , , | 2 Comments

The Snippet Manager in SQL Prompt

I love SQL Prompt, since it makes T-SQL coding quicker and easier. One of the handiest things is the Snippet Manager. I’ll show you how this works. When I type something, like “cl”, I get a list of things, as … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Finding the Attribute

I was playing with some Extended Events recently. If you haven’t tried, I’d encourage you to do so. However, working with XML is not my favorite. I know I can get the GUI in SSMS 16.x to show me events, … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Avoiding Stored Procedures

This editorial was originally published on Aug 13, 2012. It is bein re-published as Steve is on vacation. I ran across this piece from a developer on why he avoids stored procedures and thought it made some good arguments. The … Continue reading

Posted in Editorial | Tagged , | 2 Comments

Output into a Table–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I often see people struggling to use triggers for auditing, or having issues with building them to handle multi … Continue reading

Posted in Blog | Tagged , ,

Rounding Challenges–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Rounding is an interesting activity, and one that I think people sometimes don’t pay enough attention to. Recently I … Continue reading

Posted in Blog | Tagged , , | 4 Comments