Microsoft SQL Server MVP Denny Cherry breaks down multiple ways on how to troubleshoot a type -2 blocking session ID error. When we look at sessions being blocked in ...

Using session is fragile, it's non-scalable both on the client (meaning the user can no longer use multiple tabs to parallelize processes) and on the server (for obvious reasons), and it fools you ...

Learn how to pause and resume a SQL Server database mirroring session using SQL Server Management Studio or Transact-SQL (T-SQL). At any time, you can suspend a database mirroring session, which might ...

Learn about how the OLE DB Driver for SQL Server interprets OLE DB session properties, including a provider-specific property set. DBPROP_SESS_AUTOCOMMITISOLEVELS The OLE DB Driver for SQL Server ...

At a rather muted Microsoft TechEd in Los Angeles in May, the crowds were diminished and the educational content was slimmed down. In the past, SQL Server sessions were so abundant that you'd have ...

Data developers are still learning about all the new goodies that arrived with SQL Server 2022, which is chock full of new features and enhancements such as ledger for blockchain security. Microsoft ...