Four key considerations to keep in mind when you need a database designed for analytical queries of vast quantities of time series data. SQL often struggles when it comes to managing massive amounts ...

I have worked with SQL Server for many years now, back to Sybase SQL Server days and there has always been confusion over Logins and Users. Even though they typically use the same name they are ...

Users and developers access SQL Server for completely different reasons. So, be sure you set up access as defined by who they are and why they need access. For many database administrators, managing ...

Attendees at ComNet weigh in on who’s to blame for the recent SQL Slammer outbreak: Microsoft for poor security or the infected users for not applying patches that have been out for 6 months? “I wish ...

Microsoft is offering users on Windows Server 2008 and 2008 R2 and SQL Server 2008 and 2008 R2 a way to keep getting security updates for free after the official support period ends. Read also: Here's ...

Kevin Kline is president of the Professional Association for SQL Server (PASS), an independent group for users of Microsoft Corp.’s flagship data¿base. PASS is holding its annual conference in Seattle ...

We have a SQL Server database setup here that users access as part of a class. The professor is requesting that the users be able to create and drop tables in their own "workspace" while they're in ...

Organizations can use SQL Server to reduce downtime, manage and secure databases, and discover patterns in mission-critical information to improve business intelligence. To rebuild a corrupted master ...

While data warehouses and cloud-native architectures have grown rapidly, business users are still finding it difficult to reach enterprise data. Even as dashboards and query tools become easier to use ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...