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 ...

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 ...

Here is a script that creates a stored procedure called "sp_help_revlogin". After you create the stored procedure (paste into query analyzer), just execute the sp from the query analyzer. The output ...

SEATTLE — In the aftermath of the Slammer worm that wreaked havoc with many SQL Server users early this year, Microsoft Corp. is trying to make its database software more secure. But there’s still ...

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 ...

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 ...

John Breeden II is an award-winning reviewer with more than 20 years of experience covering technology. Follow him on Twitter @TheLabGuys. Most educational ­environments rely heavily on databases, ...

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 ...

Earlier this month, Microsoft released version 18.5 of the SQL Server Management Studio. The general release of SQL Server 2019 last year brought some interesting improvements for the database ...

One of the critical decisions facing companies embarking on big data projects is which database to use, and often that decision swings between SQL and NoSQL. SQL has the impressive track record, the ...