Coffee and SQL

Columnstore index is the new type of index introduced in SQL Server 2012. It is a column based non-clustered index...

2013-07-10

826 reads

Unlocking “Lock Pages in Memory” Option

Consider this scenario; Your production database server is new and with super configuration of 32 CPUs, 64G RAM, SAN Storage,...

2013-07-08

345 reads

It’s Sunday night now, weekend is almost over and was it just a few moments ago that it was Friday?...

2013-07-07

326 reads

A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...

Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...

Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...

Environment: SQL Server: 2019 Enterprise (15.0.4430.1) OS: Windows Server 2022 Standard (Build 20348) Virtualization:...

I am trying to create a filter on a SQL Server audit to capture...

I've come across what appears to be a strange deadlock anomaly. As seen in...

From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?