SQL Saturday 50 (#sqlsat50) – A Tale
This past weekend I went to SQL Saturday 50 – this is a day long SQL training event that is put...
2010-09-21
829 reads
SSAS - Defining Attribute Relationships in 2005 and 2008
Attribute relationships inside of Analysis Services are a critical piece to the design of your dimensions.The benefits of creating attribute...
2010-09-20
1,601 reads
What Do You Think Just Happened To This Database Server?
This is a screenshot of Task Manager for a database instance that is part of a synchronous database mirroring partnership...
2010-09-20
1,194 reads
Most SQL Server DBAs Still Don’t Know About Instant File Initialization
In my most recent poll, I asked DBAs if they have turned on instant file initialization on their SQL Servers....
2010-09-20
908 reads
Breaking Into SQL Showbiz
You can tell by my face, I'm an expert
Matthew Velic (blog, Twitter) just asked this question on Twitter:
And really that’s...
2010-09-20
711 reads
PASS Update #43
Last Friday saw the end of the 2010 PASS election and it was very nice to find out I had...
2010-09-20
633 reads
Share Your Experiences at #SQLSAT58
Ever thought about sharing your experiences with SQL Server to more than just your immediate peers and colleagues? Up here...
2010-09-20
640 reads
Aliases in SQL Server 2008
Recently I set up replication and as the target server was not on our domain I initially used an IP...
2010-09-20
992 reads
SQL Saturday 46 (#sqlsat46) Recap
I was privileged to be able to attend and present at SQL Saturday 46 in Raleigh, NC, this last weekend....
2010-09-20
835 reads
Kimball University: Microsoft Data Warehouse in Depth
Several years ago, late 2006, I decided to focus my career on Data Warehousing and Business Intelligence (DW/BI). I was...
2010-09-20
1,174 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