The Database Weekly Update for June 16, 2008
Steve Jones looks back at the news of the past, including a look at RC0, the latest release of SQL Server 2008.
The Database Weekly Update for June 16, 2008
Steve Jones looks back at the news of the past, including a look at RC0, the latest release of SQL Server 2008.
The Database Weekly Update for June 16, 2008
Steve Jones looks back at the news of the past, including a look at RC0, the latest release of SQL Server 2008.
Eliminating Cursors
T-SQL does some things wonderfully, but cursors are the bane of the language, often causing performance issues. Changing your queries around to remove cursors can be tricky and new author Kamran Ali brings us one technique he has used to dramatically improve performance.
Include Column Headers From SSMS
Save time when copying data from SSMS to Excel by configuring the options to Include Column Headers.
Compound Assignment Operators in SQL Server 2008
MAK illustrates the use of Compound Assignment Operator that is introduced in SQL Server 2008.
Introduction to the Unified Dimensional Model (UDM)
This paper provides an introduction to the Unified Dimensional Model (UDM), including the basic end-user model, and a brief overview of the architecture and security models.
What do you do with a new SQL Server?
This article highlights some basic steps to take when you have a new install of SQL Server or take over support of existing databases.
Close these Loopholes - Reproduce Database Errors
This is the final part of Alex's ground-breaking series on unit-testing Transact-SQL code. Here, he shows how you can test the way that your application handles database-related errors such as constraint-violations or deadlocks. With a properly-constructed test-harness you can ensure that the end-user need never see the apparent gobbledegook of database system error messages, and that they are properly and robustly handled by the application.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Riau Bisnis Center TLP/WA 08216977749
Jl. Riau No.36, Tampan, Kec. Payung Sekaki, Kota Pekanbaru, Riau 28292
BCA KCP Harapan Raya TLP/WA 08216977749
Jl. Imam Munandar No.312 C-D, Tengkerang Labuai, Kec. Bukit Raya, Kota Pekanbaru, Riau 28288
BCA KCU PEKANBARU TLP/WA 08216977749
Jl. Jend. Sudirman No.448, Tanah Datar, Kec. Pekanbaru Kota, Kota Pekanbaru, Riau 28115
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers