With the introduction of SQL Server 2005, Microsoft now allows you to write Data Definition Language (DDL) triggers to perform actions when events occur on your server. In this article, Greg Larsen discusses (examples included) some of the things that DDL triggers can be use for.
2007-07-04
2,503 reads
Proper disk configuration can result in a lifetime of high performance for SQL Server databases. Go beyond storage capacity requirements and consider drive performance.
2007-07-04
3,635 reads
Congratulations to two new members of the SQLServerCentral.com 3000 club: Jeff Moden and Noeld.
2007-07-03
1,444 reads
At the core of an enterprise BI/DW program is the data that is being made available to the business users who are looking to make better decisions using this information. Properly managing this information is the most critical activity of the enterprise BI team.
2007-07-03
2,188 reads
The interest in dynamic data warehousing (DDW) is growing significantly. A sure sign that the virtual brand has reached take-off speed is claims by bloggers that they did not get enough credit for coining the concept, viral brand or idea. For example, Dan Linstedt recently went on what he described as a "rant" about "dynamic data warehousing."
2007-07-03
2,137 reads
Check out our Top 10 tips on Analysis Services 2005 that will help you navigate through the features and functionality of this priceless Business Intelligence tool.
2007-07-02
4,883 reads
After introducing us to a comprehensive encryption toolkit in part I, Michael Coles delves into Regular Expressions and the functions included in the toolkit for use on SQL Server 2000.
2007-06-29 (first published: 2006-04-20)
21,343 reads
Get a free copy of Two Minute SQL Server Stumpers, Vol. 1 from End to End Training.
2007-06-29
2,515 reads
In this article, we will examine some rarely explored areas that concern foreign keys; in particular, we will look at disabled and un-trusted foreign keys.
2007-06-29
3,287 reads
All of us would like to code faster and with fewer mistakes. While a third party tool usualy won't help with the latter, there are a few to help you increase the speed at which you build readable code. New author Tom Fisher brings us a short tutorial on using a couple of Red Gate's tools.
2007-06-28
11,077 reads
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Comments posted to this topic are about the item Reserved Words I