Power View report migration from SharePoint 2010 to 2013
With the latest changes to the Microsoft Power BI and ability to create Power View reports within an Excel file...
2014-07-31 (first published: 2014-07-24)
8,229 reads
SQL PASS Performance Palooza 2014 Wrap-Up
Today I presented a fun session for the SQL PASSPerformance Virtual Chapter’s “Summer Performance Palooza 2014” entitled “Infrastructure Tuning for...
2014-07-24
504 reads
How To Get The Boss To Pay For Training
How do you get the boss to pay for training? In my experience you have to:
Ask. The boss isn’t sitting...
2014-07-31 (first published: 2014-07-24)
8,392 reads
Quick Tips–SQL Prompt Custom Aliases
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...
2014-07-30 (first published: 2014-07-24)
8,042 reads
My Visit to WPC 2014
Last week I attended WPC. This is an annual event organized by Microsoft for its partners around the world. WPC...
2014-07-24
466 reads
Building the SQLSaturday Orlando Marketing Plan-Part 25
Just the chart today. We’re considerably ahead of previous year registrations for the same number of weeks out. I’m looking...
2014-07-23
479 reads
T-SQL–Converting Seconds to Time
I was working on a small piece of code the other day that was calculating the seconds for an event....
2014-07-23
1,493 reads
SQL Server 2012 with SP2 Slipstream ISO images fixed
Microsoft fixed SQL Server 2012 with SP2 Slipstream ISO images do not install SP2 issue. The new ISOs have been posted on their respective release channels (MSDN…) and are...
2014-07-23
34 reads
Cumulative Update – 11 for SQL Server 2012 Service Pack 1 Is Now Available !
The 11th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 11 contains all the hotfixes...
2014-07-23
15 reads
Challenge Accepted
There seemed to be some question whether my comfort level with my own masculinity would prevent me from wearing these:
Oh...
2014-07-23
706 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