SQL Server on Linux (Ubuntu)–Updating from Early CTP
I’ve been testing the SQL Server on Linux for a long time. After the recent Microsoft Data Amp event, I...
2017-04-19
865 reads
Blog Posts
SQL Server: Functions vs. Stored Procedures to return result sets
A while back, I was building the database schema for a web application which had some reporting functionality and among...
2017-04-19
12,665 reads
SQL Server: Functions vs. Stored Procedures to return result sets
A while back, I was building the database schema for a web application which had some reporting functionality and among other things, I had do implement logic in the...
2017-04-19
37 reads
SQLShack Arcticle and Upcoming PASS Events
The latest article on SQLShack continues on the path of Data Warehouse development with SQL Server Analysis Services. The first...
2017-04-19
505 reads
T-SQL Tuesday #89 – The times they are a-changing
This month’s T-SQL Tuesday is hosted by yours truly! The topic this month: how do you keep up with the...
2017-04-19 (first published: 2017-04-11)
1,755 reads
Upcoming SQLSaturdays in Alberta, Canada
Taking a short break from the Database Fundamentals series of the last few weeks, I’d like to mention some upcoming...
2017-04-19
117 reads
VirtualBox SQL FCI - Given Network Name Is Unusable
The other day I needed to test some HADR requirements on my local machine so using VirtualBox, I created a...
2017-04-19
2,816 reads
VirtualBox SQL FCI – Given Network Name Is Unusable
The other day I needed to test some HADR requirements on my local machine so using VirtualBox, I created a 2 server Windows 2012 R2 failover cluster with shared...
2017-04-19
40 reads
Blob Auditing for Azure SQL Database
In February 2017, Microsoft announced the general availability of Blob Auditing for Azure SQL Database. While auditing features were available...
2017-04-18
650 reads
Blogging at SQLPerformance.com
I am honored to be a Guest Blogger at SQLPerformance.com. As a member of the SentryOne Product Advisory Council (PAC)...
2017-04-18
374 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