This article discusses the XML support built into SQL Server 2005. It shows how this support integrates with the client side programming support in the .NET Framework V2.0 and in native code such as OLEDB and SQLXML.
2004-11-03
1,352 reads
Theyre back and expanded, the 2004 Readers Choice awards. Take a minute and vote now for the products and vendors you have enjoyed working with.
2004-11-02
3,316 reads
SQL Server shows lots of information in Enterprise Manager, but getting a report for someone or manipulating this data is hard from the GUI. Using T-SQL, it's easier, but sometimes not obvious how to get the data. Author Santveer Singh brings us a way to get at some of that information, the users and their database roles.
2004-11-02
23,817 reads
With the release of Microsoft SQL Server 2005 Beta 2, the world of database development is changing. As a database developer, you now have the option to appropriately locate your code in relation to its functionality, to access data in native formats such as XML, and to build complex systems that are driven by the power of the database server. Database development is becoming more integrated than ever before, and all of the tools that you need are available right at your fingertips.
2004-11-02
3,856 reads
Are you tired of struggling with T-SQL to encapsulate the logic your applications need to get data into and out of SQL Server? Now you can bypass SQL altogether, and write logic that runs directly within SQL Server in your favorite .NET language.
2004-11-01
4,360 reads
Last week we discussed character datatypes and their performance effects on your database. This week,we will dive into numeric datatypes. We will discuss how SQL Server numeric datatypes are stored and the pros and cons of each.
2004-10-29 (first published: 2001-05-17)
13,921 reads
Manuals for all SQL Server 2005 hands-on labs are now available for download. See the Hands-On Labs Manuals section of this page for links
2004-10-29
3,935 reads
Blocks in SQL Server can cause untold amounts of pain and headache, mostly because they are so transient and often when you go to look for them, they have been released on whatever object you are researching. Author Eli Leiba has writeen a short piece on how you can automate the search for blocking locks and help you as a DBA be proactive in identifying them.
2004-10-28
12,419 reads
Get introduced to SQL Server Express, learn how to install and configure it in a secure manner, plus get information on the basics of SQL Server security.
2004-10-28
1,125 reads
Working with date and time data in SQL Server can be a bit cumersome using just T-SQL. With the separate datatypes being pulled from SQL Server 2005 for the time being, however, it is something that a DBA needs to get used to. Robert Marda brings us an instructional look at the different datetime data types and some things you should be aware of when developing with them.
2004-10-27
16,803 reads
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
I am excited to host T-SQL Tuesday for the first time. I want to...
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Comments posted to this topic are about the item Measuring Productivity
Comments posted to this topic are about the item Importing Excel files into SQL...
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers