Lost in Translation – Deprecated System Tables – sysindexes
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-01 (first published: 2012-10-29)
3,310 reads
Monitor Blocking with Extented Events in SQL 2012
1. Set the "blocked process threshold (s)"
sp_configure 'show advanced options', 1 ;
GO
RECONFIGURE ;
GO
sp_configure 'blocked process threshold', 10 ;
GO
RECONFIGURE ;
GO
here we...
2012-10-29
2,643 reads
Last Weeks Top 10 “Reading” Links #4
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out...
2012-10-29
655 reads
Geographic Failover/Redundancy (and DR)
Today we await the arrival of a 100 year storm that threatens to surge New York harbor and the Long...
2012-10-29
1,107 reads
Amazon Kindle Fire Released
Amazon has released the latest version of it Kindle – the Kindle Fire HD.
It seems amazon are moving away from a...
2012-10-29
633 reads
Countdown to PASS Summit 2012 – 9 to Go – My First Summit
We are less than ten days to the start of PASS Summit 2012. I thought it would be fun to...
2012-10-28
590 reads
Is PowerPivot the Next Access?
I’m impressed with the current generation of semantic modeling technology from Microsoft. I’ve had the opportunity to use both PowerPivot...
2012-10-31 (first published: 2012-10-28)
4,380 reads
Advanced TSQL training
Over the past few years, Ive had it on my to do list to write and deliver and full-scale SQLServer...
2012-10-28
1,038 reads
Microsoft Surface
I’m going to do with this what I should have done with the Piece Of Fruit (POF), blog about the...
2012-10-31 (first published: 2012-10-28)
3,272 reads
2012-10-26
1,290 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers