This is the first article in a series on writing stored procedures using the Common Language Runtime (CLR). This article focuses on basic C# syntax and using Visual Studio to build a stored procedure. It's targeted at DBA's and anyone else who primarily writes in Transact-SQL and hasn't had much exposure to .NET yet.
TechEd is a great show and while the PASS summit is the best one for DBAs, this one is great for most of the other Microsoft technologies. Read about Day 3 from Steve Jones.
The SQL Server 2000 Query Optimizer is one of the more complicated things that a SQL Server DBA deals with. For most of us, we just let it work and do not give it a second thought. But when a crisis occurred, Andy and Steve had to dive in to learn a few more things about it.
Day 2 from TechEd, this time from Brian Knight's perspective as the SQLServerCentral.com crew enjoys a week of learning and sun at the 2005 conference.
We would like to offer a free copy of the May 2004 SQL Server Standard magazine to everyone who can take a couple minutes to update some demographics for us.
They have been very hard at work trying to get SQL Server 2005 ready for release, but many of them have been given a week's break after IDW15 to come down to TechEd. They've created an interesting diary that you can view.
Occasionally, SQL Server database administrators are requested to provide a list of development SQL Servers, production SQL Servers and so on. Many articles, such as "Monitor Disk Space on Multiple SQL Servers" and "Inventorying hardware and OS information on all SQL Servers" require a list of servers in a text file.
It's not a SQL Server event, but SQL Server is a large part of it. TechEd is a huge conference and one of the premier events put on by Microsoft each year. Read about the first day with Andy, Brian, and Steve.
When a SQL Server object is created, its properties are called metadata. The metadata is stored in special System Tables. For example, in SQL 2000, when a new column was created, the column name and data type could be found in an internal System Table called syscolumns. All SQL objects produce metadata. Every time SQL 2000 Enterprise Manager or SQL 2005 SQL Server Management Studio is browsed, the information displayed about database, tables, and all objects, comes from this metadata.
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Hi all Can I get some perspective from the community please on performing in-place...
Comments posted to this topic are about the item How Long is a Long...
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers