Normally, I try to provide useful information in this newsletter for people who work with SQL Server. However, in the New Year's Issue, I indulge myself by making predictions for the coming …
Four Indexing Myths
When I examine a SQL Server environment, I very often find that the indexing seems to have been designed under false assumptions about how indexes actually work. There is a lot of misinformation …
Common Language Runtime from a DBA point of view
When Common Language Runtime (CLR) was introduced in SQL Server 2005 it was enthusiastically received by developers. CLR gave them a powerful new way to write database code using the same modern, …
Continue Reading about Common Language Runtime from a DBA point of view →
A Look at SQL Injection
SQL Injection is a set of methods that hackers use to inject malicious SQL code snippets into your application code. Quite often the malicious code is injected into data entry forms on your web pages …
Audit SQL Server with the Default Trace
In this article we will describe the auditing potential of SQL Server's default trace, how the trace is implemented and what it contains. Then we will show you how to directly access data from the …
Continue Reading about Audit SQL Server with the Default Trace →
Beware of the Wizards (and their slightly defective magic)
Wizards are mythical creatures. In the case of the SQL Server wizards, the myth is that a SQL Server database can be designed and administered by someone with very little knowledge or …
Continue Reading about Beware of the Wizards (and their slightly defective magic) →