SQL Server Infernals – Circle 3: Shaky Typers
Choosing the right data type for your columns is first of all a design decision that has tremendous impact on...
2015-07-10 (first published: 2015-07-02)
2,230 reads
Twitter - finally!!
Finally I join Twitter myself, so if you are interested to find me through Twitter, its here.
2015-07-02
328 reads
FOR JSON Clause With PATH Mode In SQL Server 2016
In previous blog we learnt about changing query format using JSON clause with AUTO mode option. In this blog we...
2015-07-02
392 reads
Power BI Hands-On Workshop at PASS Global Summit
Please join me at the PASS Global Summit in Seattle for a half-day, 3-hour hands-on Power BI mini workshop. Bring...
2015-07-02
262 reads
Power BI Hands-On Workshop at PASS Global Summit
Please join me at the PASS Global Summit in Seattle for a half-day, 3-hour hands-on Power BI mini workshop. Bring...
2015-07-02
2,065 reads
Database Drops in SQL 2012
In the previous article on this topic (which can be read here), I discussed the problem of having a database get dropped and the need to find out who dropped...
2015-07-01
29 reads
Database Drops in SQL 2012
In the previous article on this topic (which can be read here), I discussed the problem of having a database get...
2015-07-06 (first published: 2015-07-01)
2,078 reads
Microsoft SQL Server MVP
Today I received an email notifying me that I have been awarded the Microsoft “MVP” award for my second year....
2015-07-01
1,239 reads
How to Grant limited permissions to create views in another schema?
How to Grant limited permissions to create views in another schema?
In SQL Server 2005 and 2008R2 you can grant permissions...
2015-07-08 (first published: 2015-07-01)
3,267 reads
Reporting Services Subscriptions in “Pending” Status
Ran into this issue today. A subscription that had been working failed. Looking at it in the RS portal it...
2015-07-01
9,787 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