SQL Saturday #277 Richmond – Covering new ground
SQL Saturday has been a fantastic experience for me here in the DC area (I blogged about it here) and...
2014-03-04
599 reads
Book: Expert Cube Development with SSAS Multidimensional Models
Those of you who use SQL Server Analysis Services (SSAS) are likely familiar with the “bible” for designing cubes: Expert Cube...
2014-03-04
2,323 reads
SharePoint 2013 – Failed to install the product: D:\global\oserver.msi ErrorCode: 1603(0x643)
I often do my SharePoint setups on virtual machines since I need to build them up and tear them down...
2014-03-04
2,854 reads
How Long is that SQL Command Going to Take?
Have you ever needed to restore a large database while someone is standing over your shoulder asking “How long is...
2014-03-04
3,245 reads
Free SQL Server Training (not a sales pitch)
My company cut the training budget this year, and it’s not that uncommon for that to happen anymore. However, I’m...
2014-03-04
1,088 reads
Mind the Gap
Recently we deployed database mirroring in an environment with an Active Directory. The process is usually quite simple and straight-forward,...
2014-03-04
641 reads
Nontechnical Post – Omaha Film Festival
My wife, Molly, is one of the smartest (non-technical) people I know. Although she has learned a lot about what...
2014-03-03
883 reads
Upcoming Conferences: SQLSaturdays in Denmark and Portugal. – Presenting In-Memory OLTP Deep-Dive for Administrators
(de)
Im März und April finden 2 europäischen SQLSaturdays statt, die Potential zu einem Geheimtipp haben:
Am 29. März in Kopenhagen, Dänemark
...
2014-03-03
828 reads
Powershell in a Month – Day 19 – I/O
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in...
2014-03-03
1,199 reads
SQL Server Quickie #11 – Non Clustered Indexes
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-03-03
435 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