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
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
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
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
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
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,807 reads
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,880 reads
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
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
I received a review copy of Murach's SQL Server 2008 For Developers a couple months back and just finished up looking through it. In general I've always liked the style of the Murach books; short lessons that flow about as logically as you can do it when it often seems like you need to know it all to get anything done!
2009-03-17
1,782 reads
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Comments posted to this topic are about the item Adding new column with DEFAULT...
Comments posted to this topic are about the item Advanced Deployment Scenarios: Stairway to...
Comments posted to this topic are about the item You Need a DBA Pipeline
Which number did the two COUNT(*) return:
DROP TABLE IF EXISTS #tmp CREATE TABLE #tmp (id INT NOT NULL) INSERT INTO #tmp (id) SELECT gs.value FROM GENERATE_SERIES(1, 5) AS gs ALTER TABLE #tmp ADD my_value INT NOT NULL CONSTRAINT df_tmp_my_value DEFAULT 1 SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1 ALTER TABLE #tmp DROP CONSTRAINT df_tmp_my_value ALTER TABLE #tmp ADD CONSTRAINT df_tmp_my_value DEFAULT 2 FOR my_value SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1See possible answers