SSC Editorial: Access Disdain
Contrary to the title (by design), Access Disdain is about not automatically hating Access (or it’s users). Clearly Access has...
2014-07-17
626 reads
How to Check SQL Server Installation Date Time ?
You need to run the following query and it will give you the date of your SQL Server Installation. SELECT @@SERVERNAME SERVERNAME, CREATE_DATE ‘INSTALALTIONDATE’ FROM SYS.SERVER_PRINCIPALS WHERE SID =...
2014-07-17
24 reads
Get SQL Server Info - Quick Tip & Script
There
are a number of ways to collect basic information about SQL Server, its
version, edition and other top-level properties. What is...
2014-07-22 (first published: 2014-07-17)
11,343 reads
Modeling the Agile Data Warehouse with Data Vault – Review
A few months ago I followed an introductory course about the data vault modeling technique for data warehouses at a...
2014-07-17
1,756 reads
How to Check SQL Server Installation Date Time ?
You need to run the following query and it will give you the date of your SQL Server Installation.
SELECT @@SERVERNAME...
2014-07-17
1,888 reads
Goodbye Microsoft, Hello New Adventure
About two months ago, after two and a half years, I left Microsoft.
Microsoft is an amazing place to work for. It’s...
2014-07-17
480 reads
5 Tips for Finding SQL Server System Data
Regardless of the type of development (application or reporting) that you are performing on SQL Server. There are 5 items...
2014-07-23 (first published: 2014-07-17)
9,751 reads
Goodbye Microsoft, Hello New Adventure
About two months ago, after 2.5 years, I left Microsoft.
Microsoft is an amazing place to work for. It’s conformable, balanced,...
2014-07-17
562 reads
T-SQL Window Functions – Part 4: Analytic Functions
This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links...
2014-07-24 (first published: 2014-07-17)
11,163 reads
Remembering Reed Jacobson
I just received some bad news and found out that a friend passed away today. Reed Jacobson was one of...
2014-07-16
508 reads
Blogs
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers