Avoid Transact-SQL's Column Alias Limitations
A column alias seems like a great tool for referencing complex expressions, but SQL Server doesn't work that way. Learn a simple workaround.
2009-03-18
3,116 reads
Articles
Handling Service Broker Errors
The previous installment of the 'SQL Server 2005 Express Edition' series discussed using transactions to protect the integrity and consistency of Service Broker-based communication. Depending on the type of issue encountered by our code, the outcome might be different from expected. This article demonstrates a more robust approach to error handling and applies it to our target.
2009-03-18
1,351 reads
How to create indexes on computed columns in SQL Server
There are certain requirements for creating indexes on computed columns and this tip shows you want needs to be done.
2009-03-18
3,781 reads
Secure Programming
Writing secure programs is hard. Steve Jones has a few comments on what some of the issues are with training developers.
2009-03-18
477 reads
Secure Programming
Writing secure programs is hard. Steve Jones has a few comments on what some of the issues are with training developers.
2009-03-18
776 reads
Secure Programming
Writing secure programs is hard. Steve Jones has a few comments on what some of the issues are with training developers.
2009-03-18
503 reads
SSIS Custom Error Handling
This article from Zach Mattson shows how you can set up custom error handling in your SSIS packages. Learn how to direct those error rows to another component for separate processing.
2009-03-17
11,732 reads
Using Intersect - SQL School Video
This SQL School video will introduce you to the INTERSECT command in T-SQL. MVP Andy Warren explains how this command allows you to find matching rows in a join and a UNION.
2009-03-17
4,856 reads
Adding a UI to the Standalone SQL Agent
In a recent blog post, SQL Server expert Denny Cherry discusses adding a user interface to his Standalone SQL Agent, a replacement for the SQL Server Agent service.
2009-03-17
1,896 reads
Analyzing SQL Server Permissions
This article shows the steps to analyze SQL Server logins and permissions to ensure that there are no logins and users that exist who are have unnecessary access
2009-03-17
3,464 reads
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Local Agents
Comments posted to this topic are about the item Local Agents
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers