SQL Server isn’t used much for web-based applications, simply because the cheapest ISPs use Linux and Apache for their platform. There are ISPs that provide a .NET platform and SQL Server but it is at a cost. SSDS seems to be Microsoft’s latest attempt to break into the market for database-driven websites.
SQL Server 2005 includes a number of new security enhancements to aid the DBA in managing their SQL Server. DDL triggers allow you to trap all kinds of DDL events that occur on your server. S. Srivathsani brings us a look at these new events.
An idea that could save time and resources for backup and recovery in SQL Server.
An idea that could save time and resources for backup and recovery in SQL Server.
In this article, we will explore another variation of this mechanism, called Web Synchronization, with SQL Server 2005 Express Edition instances operating as merge replication subscribers connecting to a publisher via HTTPS protocol.
By gbargsley
One of the first things I review when I inherit a new SQL Server...
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
hi a peer of mine who ive never known to be wrong says a...
Comments posted to this topic are about the item Displaying Money
Comments posted to this topic are about the item The Slow Growing Problems
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers