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.
2005-06-10
5,111 reads
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.
2005-06-09
4,045 reads
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.
2005-06-09
7,029 reads
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.
2005-06-08
5,070 reads
2005-06-08
3,605 reads
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.
2005-06-08 (first published: 2005-05-25)
6,335 reads
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.
2005-06-08
3,763 reads
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.
2005-06-08
2,281 reads
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.
2005-06-07
5,399 reads
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.
2005-06-07
3,314 reads
The post The pros and cons of self-service BI: What every industry leader should...
By Steve Jones
As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and...
By John
AI and ChatGPT are all the rage these days. Seems like around every corner...
Web Artistary, a top video animation company in New York, offers a wide range...
I am running SQL Server 20.2. When I copy a query into the query...
Hi, i considered power bi with embedded for this. Not a big fan...
Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)
See possible answers