Who builds SQL Server? It's an interesting collection of individuals and we're looking to bring you some profiles of them all. This time Steve Jones interviews Thierry D'Hers, leader of the BI group.
2005-08-11
8,151 reads
Shawn Wildermuth is the “go-to guy” for information on ADO.NET. He is the author of Pragmatic ADO.NET: Data Access for the Internet World and numerous articles, is a Microsoft MVP, and works as an independent consultant in Atlanta.
Shawn’s web site, The ADO Guy, is a good resource for developers looking for answers to questions about ADO and ADO.NET. The site also lists interesting blogs, books and sites that are among Shawn’s favorites.
2005-08-11
1,821 reads
With a month left before the 2005 PASS Summit, there is yet another great reason to attend this SQL Server conference in 2005. Read about it and be sure that you register today with our source code "SSC".
2005-08-10
2,804 reads
After a fantastic reception to his SQL Server 2000 cryptography toolkit, Michael Coles brings us a basic look at cryptography so you can understand what you are getting into if you implement it.
2005-08-10
14,139 reads
In any well run development environment, you will have a separate SQL Server for developers to work on, completely different from your production server. However there are a few tricks that Jason Hall brings us that you might want to implement to ensure a smooth running environment.
2005-08-09
7,566 reads
This article looks at how partial classes can be used to implement business logic into datasets so that they are more business aware and intelligent.
The dataset is an integral part of Microsoft’s new data access model ADO.NET. It introduces a simple offline method for retrieving and updating data. Before using the dataset, you should have an understanding of the Microsoft .NET platform and a basic understanding of the dataset model.
2005-08-05
3,652 reads
Why should a SQL Server DBA want to keep their job? It seems obvious, but Steve Jones continues with his series on employee retention by taking a look at it from the employee side.
2005-08-04
10,504 reads
Michael Rys is one of two program managers responsible for the XML features in SQL Server. He also represents Microsoft on the W3C XQuery Working Group, and on the ANSI working group for SQL. I asked him what is distinctive about the XML support in SQL Server 2005, as opposed to that found in rival database management systems. As Rys acknowledges, "all the three major vendors, Oracle, IBM and Microsoft, are moving towards second or third generation suppor
2005-08-04
1,979 reads
One of the features of SQL Server 2000 is the Soundex feature that allows phonetic matching. Michael Coles brings us a new toolkit that solves some of the issues that occur with soundex as well as an explanation why this occurs.
2005-08-03
14,536 reads
Microsoft introduces new operators PIVOT and UNPIVOT in SQL Server 2005. Traditionally we create queries using the CASE statement and aggregate function in order to produce cross-tab reports. This article illustrates the usage of the new operators, PIVOT and UNPIVOT.
2005-08-03
3,652 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers