SQL Server
How do I run code automatically when SQL Server starts?
The need to run a stored procedure or SQL Agent Job when SQL Server or SQL Agent starts is a common requirement in the world of SQL Server administration. This article gives an overview of the ways to execute SQL stored procedures or SQL Agent jobs on startup. Read more »
Script Table definitions using TSQL
Generating scripts in SQL Server using TSQL has never been easy. This article will show you how you can use TSQL in SQL Server 2005 code to script a table's definition. Read more »
Introduction to Policy-Based Management in SQL Server 2008
New to SQL Server 2008 is Policy-Based Management. This new technology allows for defining polices to ensure your database guidelines are met. This article gives an overview of this new technology. Read more »
Reviewing SQL Server Permissions
This article looks at the importance of database permissions and how you can use internal SQL Server system views to easily which users have access on your system. Read more »
Using Object Dependencies in SQL Server 2008
Tracking object dependencies has always been difficult with SQL Server. SQL Server 2008 makes it easier because it tracks dependencies by the object's name rather than ID. Here's how it works. Read more »
Take advantage of undocumented SQL Server iteration procedures
Here's a look at how you can use two built-in system stored procedures -- sp_msforeachdb and sp_msforeachtable -- to iterate through SQL Server tables and databases. Read more »
Using Grouping Sets in SQL Server 2008
A neat new feature in SQL Server 2008 is the GROUPING SETS clause, which allows you to easily specify combinations of field groupings in your queries to see different levels of aggregated data. This article looks at how you can use the new SQL Server 2008 GROUPING SETS clause to aggregate your data. Read more »
More New SQL Server 2008 Features
Microsoft updates SQL Server on a pretty regular basis. Its newest version, SQL Server 2008, includes some new features not found in older versions. Here's a list of some of them. Read more »
Help! My SQL Server Log File is too big!
Overgrown transactional log files can turn into real problems if they are not handled properly. This article discusses the perils of not handling SQL Server log growth properly, and what can be done to correct the problems. Read more »
Audit data using SQL Server 2005's COLUMNS_UPDATED function
This article looks at how the SQL Server 2005 COLUMNS_UPDATED function works and then discusses how to parse out the field names. Read more »
News and features
- Latest
- Popular
- Features
- Most Discussed
-
This blog post covers some of the technologies available for creating applications for the Semantic Web. Read more »
-
Bridging the gap between programmers and the visionA successful project will have a hard time flying if you don't walk through the game plan before writing a line of code. Read more »
-
Social news start-up Streem shuts downSydney social news start-up Streem will shut down this afternoon, according to a heartfelt notice posted on the site this morning by its founder Elgar Welch. Read more »
-
How to Reset Windows passwords
2008/10/01 14:31:09
-
Five things to consider when choosing a Linux distribution
2008/10/01 15:50:33
-
Cyber-terrorism 'a big threat'
2008/12/01 12:43:32
Most popular tags
What's on?
-
Space pr0n, patent karma and Yang out -- Club Builder
On Club Builder this week: how NASA plans to get the Internet into space, Jerry Yang is out the door at Yahoo and Brendan Eich discusses javascript engine competition.