The strength and holy grail of relational databases lies in the very name: relations. Microsoft has put a good deal of intelligence and cunning into query optimizations, caching, indexing and execution plans to make the process of finding related records even smoother and faster. This small article, however, will try to shatter the very sacred notion of relational databases.
Microsoft has released a patch to fix two buffer overflow vulnerabilities in SQL Server 2000. No UserID or password is required by the attacker to exploit these issues. The problem is exacerbated by the fact the attack goes over UDP.
The purpose of this article is to give you a working knowledge of how to view and understand query execution plans for SQL Server. This is part 1 in a series of articles that will walk you through understanding execution plans to help you improve your queries.
SQLClean is a SQL Tool that automatically creates a dependancy analysis of your SQL Server Database including tables, views, triggers, defaults, procedures etc. SQLClean will also analyze a client application for depenandies on SQL Objects allowing you to detect and eliminate unused SQL objects that are unreferenced by either the client app. or database itself.
From News.com, this series contains a bunch of interviews and surveys of a number of CTOs from large US corporations. Worth a read to see what the heavy spenders think.
Microsoft has release a cumulative security update for SQL Server with SP2. Read , download and update your SQL Server!
This article contains descriptions of 65 documented and undocumented trace flags currently available in SQL Server 7.0 and 2000.
Oops, a developer just forgot a WHERE clause when he ran his delete statement. Lumigent Log Explorer 3.0 can peer into the transaction log and find the culprit and roll it back. Read the review here of Lumigent's latest version.
An extremely useful tool to reverse engineer a database is Visio 2000. It also has the ability to generate a database. This generation takes place after Visio has been used to draw the tables and relationships. This process can be a huge time saver. If a database needs to be tweaked and reworked it can be done in Visio and then regenerated. This article is intended to provide a nice introduction to using Visio 2000 to generate a database.
Programmers can most commonly relate to interface-based programming in their programming language. This is harder to accomplish in SQL Server though. In this article by Chris Cubley, he shows you how to build interfaced-based SQL.
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item This Week's AI Trust Problem...
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers