Excel 2013 Power View set up
In this blog post I will share steps I have taken to set up PowerView using Excel 2013. Hopefully tomorrow...
2012-07-19
985 reads
Blog Posts
Notes from the July 2012 MagicPASS Meeting
Quick notes from the MagicPASS meeting:
Kendal Van Dyke still the king when it comes to explaining what’s going on with...
2012-07-19
721 reads
Send me your pictures
If you got some with me at SQL in the City last week I London, or anytime in the last...
2012-07-19
1,064 reads
SQL Audit 102 – Reading audit output
Last time we went over the basics of creating a SQL Audit. Now obviously once you’ve gotten your audit in...
2012-07-19 (first published: 2012-07-16)
3,256 reads
SQL Saturday #150 and TechDay Baton Rouge–BI 1 track
The SQL Saturday/TechDay in Baton Rouge will be the forth annual this year. The Business Intelligence sessions occupy 2 tracks...
2012-07-19
895 reads
Stacia Misner and Kevin Kline Doing All Day Sessions for SQLSaturday #151
If there is anything better than a SQLSaturday it’s a SQLSaturday with a choice of great pre-con speakers. This year...
2012-07-19
704 reads
Using Cell-Level Encryption in SQL Server
Industry guidance such as the Payment Card Industry Data Security Standard (PCI-DSS), Healthcare Insurance Portability and Accountability Act (HIPAA) and...
2012-07-19
15,714 reads
#TSQL2Day – A Day in the Life of A Service DBA
Today I am excited to join in with my #sqlfamily and participate in this months #tsql2day throw down. This month Erin...
2012-07-18
453 reads
Enabling "Open Project Folder" for project types that don't support it
One annoying thing about SSIS (2008) and some of the other project types in Visual Studio is the lack of...
2012-07-18
757 reads
Office 2013 Preview – Enabling PowerPivot in Excel
With the Office 2013 announcements today I was excited to download and get my hands on the tools. Because this is still...
2012-07-18 (first published: 2012-07-17)
3,304 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