Technology Toolbox: SQL Server 2000, ADO, ADO.NET D evelopers love database programming tips, tricks, and workarounds especially those that slash development time or boost application performance.

For those legacy SQL Server 2008/R2 applications that remain critical, some form of high availability or disaster recovery protection will be required to preserve business continuity. It is ...

Technology Toolbox: SQL Server 2000, ADO, ADO.NET D evelopers love database programming tips, tricks, and workarounds especially those that slash development time or boost application performance.

SQL Server Drill Down SQL Server Drill Down explores all aspects of Microsoft SQL Server and related applications, with a particular emphasis on issues of interest to SQL Server data professionals.

SQL Server 2012/2014 delivers compelling new capabilities that make an upgrade worthwhile. However, along the upgrade path, companies have also discovered key obstacles to achieving the new ...

Technology Toolbox: SQL Server 2000, ADO, ADO.NET D evelopers love database programming tips, tricks, and workarounds especially those that slash development time or boost application performance.

Microsoft this month pushed out 133 patches for a broad swatch of software and apps and plugged a zero-day flaw in SQL Server.

SQL Server 2022 has more Intelligent Query Processing features to speed up existing workloads and database applications with what Khan calls “minimal implementation effort.” ...

SQL Server client applications communicate with instances of SQL Server through Net-Libraries. Client Net-Libraries and Server Net-Libraries communicate over the network by exchanging network packets.

10) Examine Your Apps With SQL Server Profiler Allocate a few hours at the end of the development cycle to run a trace in SQL Server Profiler and capture your application's workload. This lets you ...

10) Examine Your Apps With SQL Server Profiler Allocate a few hours at the end of the development cycle to run a trace in SQL Server Profiler and capture your application's workload. This lets you ...