Choosing the right data platform is not an easy task. Warner Chaves compares the capabilities of the big three Database as a Service (DBaaS) offerings, Microsoft’s Cosmos DB, Google’s Cloud Spanner, and Amazon’s DynamoDB, to help you make the right choice for your application.
2017-12-27
3,064 reads
The DMV are very effective and important to administer ASDWH. In this article we will show some important DMVs.
2017-12-26
920 reads
Brent demos a single query plan that asks for 2 identical indexes on the same table.
2017-12-26
3,142 reads
Shrink SQL Server databases quickly and with virtually no contention.
2017-12-25 (first published: 2015-08-17)
4,357 reads
Kathi Kellenberger wonders what's keeping your business from upgrading.
2017-12-25
64 reads
Ameena Lalani looks at cascading updates and deletes when using temporal tables in SQL Server.
2017-12-25
3,228 reads
Learn how you can get the userid of someone connected to Reporting Services and use that information to determine if they can view the report.
2017-12-22 (first published: 2010-05-18)
8,284 reads
Tim Radney of SQLskills talks about the various Standard tiers available in Azure SQL Database – what they get you, and how much they cost.
2017-12-22
3,997 reads
SQL Server orphaned users are a common thorny issue in auditing. In this post, Jeffrey Yao provides a few different ways of identifying orphaned users covering various scenarios.
2017-12-21
3,707 reads
As the final entry in this series, Robert Sheldon leads you through a group of forgotten features that have been removed from recent versions of SQL Server. In some cases, the features were widely used and often loved, while others had lost their usefulness over the years or were replaced with something much better. In this article, he remembers Data Transformation Services (DTS), a handful of DBCC commands, a few utilities, Active Directory Helper Service, English Query, Web Assistant, SQL Mail, Native XML Web Services, Notification Services, SQL Distributed Management Objects, Surface Area Configuration Tool, and the Pubs and Northwind databases.
2017-12-20
3,745 reads
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Comments posted to this topic are about the item Local Agents
Comments posted to this topic are about the item Detecting Deadlocks
Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval...
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers