T-SQL Tuesday: A Day in the Life of a BI Developer
My name is Jennifer and I am a Business Intelligence developer at Trek Bicycles. I’ve been a BI developer for...
2012-07-17
653 reads
Blog Posts
BI Systems Architecture Diagrams
Today I have decided to prepare myself for a meeting with a potential client (tomorrow) and write an article about...
2012-07-16
638 reads
Building Your First Power View Report
This has been reposted from a guest blog post I wrote on the Microsoft Business Intelligence team blog.
Fulfilling User Needs
Developing a...
2012-07-16
1,212 reads
Crystal Reports DataDate in SSRS
Crystal Reports has a special field name “DataDate”. This date shows the last time the data on the report has...
2012-07-16
1,380 reads
Encrypting Connections to SQL Server
I manage databases for financial organisation. These databases have confidential data of our customers such as credit card numbers, security...
2012-07-16
5,680 reads
Finding Your Dream Job - sharing some thoughts of the day...
Everyone at some time or another thinks about finding or landing their dream job. It could be in the form...
2012-07-16
2,080 reads
I’ll Be Presenting at the PASS Summit 2012
I’m a little late posting this, but I had two sessions accepted out of four I submitted. I’ll be doing...
2012-07-16
542 reads
MidnightDBA tutorials and webshow now on iTunes!
We’ve been slacking for way too long, but as of this week our video RSS feed is up to date!...
2012-07-16
700 reads
PASS BI/DW presents Dimensional Modeling 101–by me…
With a little help from the Kimball Group, I have become somewhat knowledgeable with the Data Mart dimension model approach...
2012-07-16
865 reads
Speaker Selection for SQLSaturday Orlando-The Monday List
Nine more speakers we’re pleased to say will be joining us for a fabulous SQLSaturday in Orlando!
Timothy McAliley
Juan Soto
Erika Bakse
Jose...
2012-07-16
664 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