Don't Upgrade to SQL Server 2005
It's been almost three years since SQL Server 2005 was released and Steve Jones current recommendation is that you don't upgrade right now. Read on to see why he's giving this advice.
SQL Server 2008 Launch Date
Yesterday at it's Worldwide Partner Conference, Microsoft announced the launch date for SQL Server 2008 along with Windows 2008 and Visual Studio 2008.
Notification Services in SQL Server 2005
SQL Server Notification Services is used for developing and deploying applications that generate and send notifications. Notifications are personalized messages sent to a device that subscribes to them.
Using CLR Integration in SQL 05 for Writing Stored Procedures
With SQL 2005 you can harness the power of a higher-level language to not only do more with stored procedures, but also save time by already knowing a popular .NET language.
Real-Time Ambition: Reaching the Potential of Event Processing
Complex event processing (CEP) software delivers on the promise of real-time insight, but is the technology too green for mainstream success? CEP was once available only to big financial institutions and government agencies that could afford custom development projects. That's no longer the case, as off-the-shelf products and implementations have proliferated.
SQL Server 2005 Express Edition - Part 1
Marcin Policht offers an overview of choices offered in the SQL Server 2005 product line, as an introduction to a new series on the Express edition.
Stop SQL Injection Attacks Before They Stop You
This article discusses: How SQL injection attacks work, Testing for vulnerabilities, Validating user input, and more.
Updating AS/400 Linked Server Tables from SQL Server
One of the strongest features of SQL Server is the ability to connect to disparate data sources and perform queries across multiple sources. New author Basu Hullur brings us a technique that he used to update data on the AS/400 in a much quicker way than previously.
Pop Rivett and the Expanding Log
When your database transaction log is out of control, there is only one man who can tame it.
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
BCA KCU BLOK A CIPETE Telp:0821-8200-233
Telp/Wa 62 8218200233 PQHX+93W, Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5, Cipete Sel., Kec....
Alamat Kantor BCA KCP Tebet Telp:0821-8200-203
Telp/Wa 62 8218200203 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N &...
Alamat BCA KCP Tebet Barat Telp:0821-8200-174
Telp/Wa:62 8218200174 Jl. Tebet Barat IX No.40, RT.6/RW.4, Tebet Bar., Kec. Tebet, Kota Jakarta...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers