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.
2006-05-16
8,649 reads
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.
2006-05-16
4,339 reads
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.
2006-05-15
5,042 reads
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.
2006-05-15
15,152 reads
In this article, Brian Kelley focuses on learning the various services in SQL Server. He also covers the security needed to make them work.
2006-05-12 (first published: 2002-01-03)
50,844 reads
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.
2006-05-11
13,451 reads
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.
2006-05-10
11,752 reads
Processing text or long strings usually reduces SQL to a prosaic procedural language. Learn a few techniques for facilitating speedy text processing in SQL.
2006-05-10
5,032 reads
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.
2006-05-09
21,665 reads
This article explains the different technologies that are available for scaling out a SQL Server 2005 database application, focusing on the factors that go into deciding which solution(s) to use in your application.
2006-05-09
2,685 reads
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Comments posted to this topic are about the item Unraveling the Mysteries of the...
Comments posted to this topic are about the item QUOTENAME Behavior
Good Morning. I have a T-SQL Script which has been developed to execute a...
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers