There are quite a few changes in SQL Server 2005 and many of those relate to security. Did you know the sa account can be disabled by default? Longtime author Raj Vasant brings a basic look at connecting and authenticating in SQL Server 2005.
2006-11-14
4,138 reads
Relational tables often describe more than one type of real world entity. In this tip, Bob Watkins covers some things to think about when designing such tables.
2006-11-13
3,890 reads
We've put together some great new sale items for that SQL person on your Christmas list. Even if that person is you!
2006-11-10
3,248 reads
Service Pack 2 for SQL Server 2005 has been released as a CTP. Steve Jones installed it and has a few thoughts on this pre-release product.
2006-11-10
3,603 reads
SQL Server has extensions to allow one to call COM based objects from within the server using T-SQL. While this is an interesting feature, it's may not be the best way to structure your applications due to performance reasons. New author Zach Nichter of ScalabilityExperts.com brings us an analysis of different ways of writing out to a file from within SQL Server. Read on to see the most efficient method of generating files on your server.
2006-11-10 (first published: 2005-02-07)
43,884 reads
The same ANSI Standard SQL query can run against identical data on SQL Server and Oracle and return different results. So just because your application issues ANSI standard SQL, don't assume it's portable.
2006-11-09
2,041 reads
This video sample shows how the clustering algorithm can be used to automatically validate data.
2006-11-08
2,184 reads
In this presentation, you'll see how you can use Excel 2007 to view data and create quick reports against data in Analysis Services. Then, you'll see how to conditionally format the data and apply rules to the data.
2006-11-08
2,621 reads
SQL Server 2005 replication agents are configured optimally out of the box, but occasionally you might need to alter the default behavior by tweaking the agent's parameters. SQL Server 2005 exposes some parameters through graphical interface that were available only from command line or through agent job steps in previous releases. Baya Pavliashvili encourages you to learn the new options available with each replication agent and how to fine-tune these options for your applications.
2006-11-07
2,281 reads
Working with a new piece of technology can be intimidating. Not having the technology installed correctly can only lead to more difficultly. This guide outlines steps to properly install SQL Server 2005 Reporting Services and the current service pack to get you going in the right direction.
2006-11-06
3,793 reads
By Steve Jones
Train employees well enough that they could get another job but treat them well...
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
Comments posted to this topic are about the item Create an HTML Report on...
Hi when i think of server hops , i think of how kerberos assists...
Comments posted to this topic are about the item Can/Can't Do/Don't
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers