Collation: Expression
I had a recent run in with collation problems and it got me started reading. As I read I started...
2014-04-02 (first published: 2014-03-26)
1,743 reads
Getting an INDEX SEEK to Speed up LIKE “%string%” Searches
In today’s blog I will attempt to challenge the popularly held notion that LIKE “%string%” wildcard searches must be slow...
2014-03-26
20,700 reads
Conditional Coloured Bar Charts in Excel with Upper and Lower Targets
I was just trying to gauge my BI knowledge level the other day and decided to chart it for visibility....
2014-03-26
577 reads
5 Top Features Your Company Can Use in SQL Server 2014 Standard Edition
In a few days SQL Server 2014 will be made available, we’re not all lucky enough to be running Enterprise...
2014-03-26
1,159 reads
Pluralsight = Essential Training
Update: 11th Sep 2016 - See comment that pricing tiers have been adjusted since this blog post
I've been aware of Pluralsight...
2014-03-25
1,355 reads
5 Tools Every DBA Should Know About
After monitoring enterprise SQL Server instances for over 10 years now, there are 5 tools that are used every day...
2014-04-03 (first published: 2014-03-25)
7,358 reads
Encryption in Las Vegas – SQL Saturday #295
I enjoy Las Vegas, usually trying to see a show of some sort when I’m there. I’ll have the chance...
2014-03-28 (first published: 2014-03-25)
1,543 reads
Book: Reporting with Microsoft SQL Server 2012
I am happy to say I have published my first book! It is called Reporting with Microsoft SQL Server 2012...
2014-04-04 (first published: 2014-03-25)
3,869 reads
Save Money On Your Training Server
You can spend less money. Some of us are lucky. We work for very large corporations who can easily set...
2014-03-31 (first published: 2014-03-25)
2,201 reads
What is Microsoft Management Reporter for Dynamics AX?
It is a collaborative and interactive reporting solution from Microsoft for finance data. View more here: Management Reporter 2012 Overview...
2014-03-25
771 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