Data Transformation Services morphed a bit in SQL Server 2000 but nothing compared to what SQL Server Integration Services is today. When I found out Professional SQL Server 2005 Integration Services was coming out, I decided to put it on my list of books to have.
Analysis Services 2005 seems like it receives much less notice than most of the other features in the latest version of SQL Server. However it is becoming more widely used in more and more companies. One of the features that can prove useful is the logging of queries. New author Yaniv Mor brings us a look at how this has changed in 2005.
If you're performing a penetration test or higher-level security audit of your SQL Server systems, there's one test you must not miss. It seems obvious, but many people overlook it: SQL Server password testing. Given the inherent weaknesses compared with more secure Windows authentication, you should especially test for password flaws if you're using SQL Server authentication in mixed mode. Password testing will help you determine how easily others can break into your database and help you ensure SQL Server users are being responsible with their accounts.
One of the hard parts of being a consultant, either full time or after hours for extra money, is finding a job. SQLServerCentral.com has a new partner that can help you solve this problem, find a job, and maybe a new career.
Working with outer joins can be tricky since the syntax doesn't always appear to make sense. Grant Fritchey brings us a great example of how this confusion can cause issues if you use the old style syntax.
In this article, Brian Kelley focuses on learning the various services in SQL Server. He also covers the security needed to make them work.
Continuing with his series on SQL Server 2005 from the developer's perspective, M. ChoirulAmri examines the ROW_NUMBER function and gives a few examples of how you can use this in your application.
Reporting Services is an add-on to SQL Server 2000, but most users would probably see it as a critical service that allows them access to their data. New authors Zach Mattson and Tom Lodermeier explain how to install Reporting Services on a cluster in an economical way.
Processing text or long strings usually reduces SQL to a prosaic procedural language. Learn a few techniques for facilitating speedy text processing in SQL.
Computed columns in SQL Server 2000 allow you to have a calculated value available easily in a query. However by using a function instead of a simple formula you can build some very interesting solutions. New author Tim Chapman brings us a look at this technique.
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
By Steve Jones
ioia – n.the wish that you could see statistics overlaid on every person you...
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
First off, my apologies for what could potentially be a bad title! I am...
I've inherited a couple of rather large databases from my ex-colleague when I join...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers