Do you know about Whatsapp web?
Whatsapp claims that they currently have 500 million users worldwide. That is pretty impressive looking at the good amount of...
2015-07-11
1,483 reads
Script to find complete months between two given dates
Below script will help in finding the complete months within the 2 given dates. In the below script we takes below dates as exampleStartdate =2015-07-05Enddate =2016-01-06
/**********************Script Start**************************/IF (object_id('tempdb..#month') is...
2015-07-10
16 reads
Script to find complete months between two given dates
Below script will help in finding the complete months within the 2 given dates. In the below script we takes...
2015-07-10
829 reads
Script to find the complete weeks within two given dates
Sometimes we need to find out the complete weeks within two given dates. Below script will help in finding the complete weeks within 2 given dates. In this script,...
2015-07-10
21 reads
Script to find the complete weeks within two given dates
Sometimes we need to find out the complete weeks within two given dates. Below script will help in finding the...
2015-07-10
807 reads
Microsoft Azure Data Catalog
Just announced is the Microsoft Azure Data Catalog, which is an enterprise metadata catalog / portal for the self-service discovery of...
2015-07-10
1,029 reads
PASS Summit Precon – The Complete Primer to SQL Server Virtualization
I am very pleased to announce that Argenis Fernandez and I will be presenting a new precon training session at...
2015-07-10
552 reads
011 – Get The Tools! - WaterOx Consulting
Reading Time: 1 minutesJust get the freakin’ tools already! In WOxPod!, episode # 011 –...
The post 011 – Get The Tools! appeared...
2015-07-10
430 reads
Creating Clustered Index on a Table Variable column in MS SQL Server
If you need to create an index in order to improve performance of the queries running against table variable (@temptable)...
2015-07-10
4,560 reads
Automatic database restore
Often times database administrators were asked to restore production database backup to UAT or development environment, sometimes it will needed...
2015-07-10
1,006 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers