Microsoft has dabbled in the ETL (extract-transform-load) marketplace for a long time, in fact, almost 2 decades. Way back in the day, SQL Server shipped with a command-line tool known as the Bulk ...

Global software house Microsoft is making big data the focus of SQL Server 2019, set for release later this year. A key part is data virtualisation, eliminating complex ETL processes. Microsoft says ...

In the past, the question of how to perform auditing under SQL Server has had a simple answer: Do it yourself. But now, SQL Server 2000 has eased the burden of auditing by introducing an extensive and ...

The annual PASS Summit, the industry’s largest gathering of SQL Server professionals, hosted more than 4,000 attendees in Seattle recently recently. PASS (www.pass.org) has grown to more than 300 ...

As you will see in this chapter, companies use SQL Server for many types of applications and on most tiers now. Gone are the days when you would second guess yourself choosing to use SQL Server over a ...