A Microsoft SQL Server community of 1,903,049 DBAs, developers and SQL Server users

A walkthrough of a conversion of a SQL Trace setup to an Extended Event session.  Read more...

In-Memory OLTP (project “Hekaton”) is a new database engine component, fully integrated into SQL Server. It is optimized for OLTP workloads accessing memory resident data. In-Memory OLTP allows OLTP workloads to achieve significant improvements in performance, and reduction in processing time. Tables can be declared as ‘memory optimized’ to enable In-Memory OLTP’s capabilities. Memory-optimized tables are fully transactional and can be accessed using Transact-SQL. Transact-SQL stored procedures can be compiled to machine code for further performance improvements on memory-optimized tables. The engine is designed for high concurrency and blocking is minimal.  Read more...

Louis Davidson explores the hidden treasures within SQL Prompt right-click context menu when working in the SSMS grid format results pane.  Read more...

Read more...

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...

Faced with the new challenges of data protection – and increased levels of oversight – many of us working with SQL Server have come to the same conclusion. Quite simply, the column names and free text descriptions available to us to describe the data in our care (or data-containing artefacts like columns, tables and databases) are no longer sufficient.  Read more...

How to detect DB corruption ASAP...  Read more...

Redgate are reducing risk with Smart Recommendations in SQL Census  Read more...

Every DBA needs to appropriately manage database growth. No DBA wants an application to fail because the database is out of space. A database can run out of space a number of different ways. One of those ways is to set the MAXSIZE of a database. When the database grows to the MAXSIZE the database will not grow anymore and if someone tries to add more rows they will get an error saying the database is full.  Read more...

Will there be a fair balance between the coming generations of technology and the human workforce? Here is a list of industries that may not think yes.   Read more...

I had an issue where an instance of SQL Server was only showing the XTP (In Memory) performance counters. None...  Read more...

I love continuing my education in SQL Server.  Recently I was fortunate enough to take Brent Ozar’s 3-day live online...  Read more...