Include Column Headers From SSMS
Save time when copying data from SSMS to Excel by configuring the options to Include Column Headers.
2008-06-13
3,328 reads
Articles
Compound Assignment Operators in SQL Server 2008
MAK illustrates the use of Compound Assignment Operator that is introduced in SQL Server 2008.
2008-06-13
1,978 reads
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.
2008-06-13
3,567 reads
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.
2008-06-12
7,830 reads
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.
2008-06-12
3,334 reads
Security Overview for Database Administrators
SQL Server 2008 is secure by design, default, and deployment. Microsoft is committed to communicating information about threats, countermeasures, and security enhancements as necessary to keep your data as secure as possible. This paper covers some of the most important security features in SQL Server 2008. It tells you how, as an administrator, you can install SQL Server securely and keep it that way, even as applications and users make use of the data stored within.
2008-06-12
3,272 reads
The Vacation Dilemma
Does vacation cause extra stress at your job before or after you leave? Steve Jones asks a poll question this Friday to see how you feel.
2008-06-12
50 reads
The Vacation Dilemma
Does vacation cause extra stress at your job before or after you leave? Steve Jones asks a poll question this Friday to see how you feel.
2008-06-12
50 reads
The Vacation Dilemma
Does vacation cause extra stress at your job before or after you leave? Steve Jones asks a poll question this Friday to see how you feel.
2008-06-12
48 reads
Audit Database Changes in the Real World
Tjay Belt brings us a story of how auditing was actually implemented and a discussion of why particular decisions were made.
2008-06-11
9,125 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Absolute and Relative References
Comments posted to this topic are about the item Absolute and Relative References
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I