You Broke My Tail Light
That’s the first thing I heard when I answered the phone recently. I was working on an change I needed...
2014-03-13
740 reads
Webinar Today at 3pm
I’m taking on a new topic today. Titled “ How to capture who did what in your SQL Server databases”, it’s...
2014-03-13
392 reads
:CONNECT in SSMS
Those people who are familiar with SQLCMD will recognize this command. It is used to connect to an instance from...
2014-03-13
1,454 reads
Upcoming Webinar – Creating Power Map Reporting Solutions
Come join me for this webinar on 4/17/2014 at 11:00 AM EST
Creating Power Map Reporting Solutions
Excel 2013 with Office 365...
2014-03-13
759 reads
Upcoming Webinar – Bringing Power BI Q&A to your Organization
Come join me for this webinar on 4/15/2014 at 11:00 AM EST
Bringing Power BI Q&A to your Organization
Q&A is an...
2014-03-13
761 reads
Whats This Command Bar ?
One of the challenges I faced while creating my TSQL Smells visual studio (SSDT) add in, was trying to find out...
2014-03-13
326 reads
Quick tip: Querying AD with xp_logininfo
We all have blind spots in our knowledge. We don’t know they are there and when we are thinking through...
2014-03-13
742 reads
Tables without Clustered Indexes?
Today, we experienced performance issues with some of the SSRS reports that were deployed as part of the latest application/database...
2014-03-13
3,253 reads
Smart Moves with SQL Server VMs – VM Proximity
Today I am starting a new series of short posts designed to help SQL Server administrators with virtualized SQL Servers...
2014-03-12
779 reads
Setting Up Tabular Models on Windows Azure
In my last post, I discussed how to set up Oracle in Windows Azure. During a customer call, there were...
2014-03-12
2,766 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
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...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
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
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