Meet Thomas Kejser in Aarhus
This is normally not a place where we advertise for events held by our friends, but today I’ll make an...
2012-09-06
768 reads
Blog Posts
Reducing Your Storage Footprint Using SQL Storage Compress
I was asked to speak at SQL in the City in New York and Austin Texas. I have used many...
2012-09-06 (first published: 2012-09-04)
1,909 reads
SQLskills joining Pluralsight is a good news for all
Many can boast that they were trained by Paul and Kimberly Randal at SQLskills. That company is so highly regarded...
2012-09-06
1,086 reads
Stressed? Need training? Take a #SQLCruise!
I can’t tell you how many times I’ve sat in a training room, in the middle of a week long...
2012-09-06
983 reads
The MERGE statement in SQL Server
The SQL MERGE statement was introduced in SQL Server 2008 and allows you to modify data in a target table based...
2012-09-06 (first published: 2012-09-05)
4,803 reads
This is Big Data
I’m sure some people have bigger data, but Facebook has some serious daily growth. The highlight? 500TB a day.
A day.
That’s...
2012-09-06
980 reads
“It’s Alive” - SSIS Design Patterns
I’m happy to announce that the book I’ve been working on for the past two years is complete and has...
2012-09-05
1,000 reads
“It’s Alive” – SSIS Design Patterns
I’m happy to announce that the book I’ve been working on for the past two years is complete and has...
2012-09-05
572 reads
Error: ACCESS DENIED on installation
Error: ACCESS DENIED on installation Generally you would get error on: >> During installation >> when try to start the sql services....
2012-09-05
904 reads
Installing SQLServer for SCCM 2012 – Some points to note on patch levels
The prerequisite SQLServer 2008 R2 patch level for System Center Config Manager 2012(SCCM) is SP1 with Cumulative Update 6 (CU)
For...
2012-09-05
1,696 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