Cycling is good for you
It’s been a great day for British cycling with Bradley Wiggins becoming the first Briton to ever win the Tour...
2012-07-22
1,107 reads
Blog Posts
How to use PowerPivot in Excel 2013
In previous lessons we create basic PowerPivot model now it is time to see how it looks in Excel 2013...
2012-07-22
1,271 reads
PASS Data Architecture presents Ami Levin: Where Are My (Primary) Keys?
I saw Ami Levin at the PASS Summit 2011 presenting on Loop Iterators in Execution Plans. It was on my...
2012-07-22
831 reads
PowerPivot create relationships
We continue creating our PowerPivot model using Excel 2013 by adding relationships. We use two methods "manage relationships" dialog box...
2012-07-22
907 reads
PowerPivot import data from SQL Server
In this tutorial we start creating PowerPivot model in Excel 2013 (very similar in 2010) by importing data from our...
2012-07-22
1,146 reads
Redirecting a page on WordPress
WordPress creates a unique link for each of your post. They are broken out with your URL then YYYY / MM...
2012-07-22
635 reads
South Florida IT Pro Camp 2012 Presentation
Presentation and scripts from my Storing PowerShell Output session at South Florida IT Pro Camp 2012.
2012-07-22
1,115 reads
Support from Atlanta MDF
I have recently been notified that my neighboring SQL PASS Chapter Atlanta MDF will be sponsoring SQL Saturday 167 in...
2012-07-22
563 reads
ComputeReach
Man it's tough to get in all that you want to do, isn't it? I've been trying to get my...
2012-07-21
721 reads
New articles posted.
My article Plotting SQL Server Data for Data Visualization is up on MSSQLTips now and discusses using PyQt and Matplotlib...
2012-07-21
824 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