Multiple CTEs
Multiple CTEs
It’s somewhat obscure in BOL and I wasn’t able to find any examples but it turns out you can...
2012-10-11 (first published: 2012-10-09)
4,588 reads
Part II - Louis Davidson (Dr SQL)–Designing for Common Problems in SQL Server…continued
The PASS Data Architecture Virtual Chapter will host part II of Designing for Common Problems in SQL Server by Dr....
2012-10-09
599 reads
Comments on the SQL in the City Tour
There’s still anevent in Seattle in a few weeks. As I’ve been traveling around the country, literally around through New...
2012-10-09
1,366 reads
T-SQL Tuesday #35 – Soylent Green
This month’s host is Nick Haslam (b | t) and he bases his question on the movie Soylent Green, which I...
2012-10-09
970 reads
Retrieving Driver Information
Recently, I had a need to take a look at all of the drivers for a specific set hardware on...
2012-10-09
446 reads
Interview with a #SQLPASS Candidate – @NTSSUG’s Sri Sridharan!
Last week, Sri Sridharan (Twitter, blog) and I sat down on the Internet to talk about his run for the...
2012-10-09
708 reads
MDS Error: “Cannot insert the value NULL into column ‘Code’”
In Microsoft Data Services (MDS), when running a stored procedure to process a staging table (stg.udp_name_Leaf), I received this error:
“Cannot...
2012-10-09
1,257 reads
My PASS Board Vote
I’m not a politically minded person and this is not the type of post I would normally write. However, I’m...
2012-10-09
772 reads
SQLSaturday #171 Pittsburgh recap
This past weekend I made the drive from Cleveland to Pittsburgh to attend SQLSaturday #171. They picked the perfect time...
2012-10-09
575 reads
Reminder to Register for the Monday Night Networking Party
We just crossed the 100 mark for registrants for our Monday Night Networking Party and still room for more. If...
2012-10-12 (first published: 2012-10-09)
1,818 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