Using Change Data Capture and CLR to Transfer Data to the Cloud
We were three: A DBA, a developer and a tester.
Our mission: To develop an ongoing process that will transfer one...
2013-07-23
1,537 reads
Best SQL Server Podcast and Video Sites (Hangout)
My friend Boris Hristov (Blog | Twitter) continues his Google Hangouts initiative, and this week he invited me to talk about...
2013-07-19
3,214 reads
New Hebrew SQL Server Podcast
Five months ago, I wrote a post about my love for Podcasts.
At some point, I started to think about starting...
2013-07-15
1,082 reads
My Thoughts about SQL Server 2014
SQL Server 2014 is coming. Go ahead and download the public CTP.
I’ve just started getting my hands dirty with the...
2013-06-28 (first published: 2013-06-25)
2,870 reads
This Can Be the Best Thing in SQL Server 2014
New versions have bombastic and catchy features. But a lot of times, the little, hidden features are the ones that...
2013-06-26
1,494 reads
Nested Loops, Parallelism and Confusion
I’m 30 today.
In addition, it’s been 10 years since I started working with SQL Server.
In my twenties, I fell in...
2013-06-11
2,081 reads
Hangouts Session with Boris Hristov
I was invited to take part in a new initiative conceived by Boris Hristov (Blog|Twitter).
Boris wants to start using the...
2013-05-29
1,275 reads
Five Ways to Improve Your Productivity with SSMS
For most DBAs, Management Studio is the primary work tool.
That’s why properly using it can save a-lot of time and...
2013-05-06 (first published: 2013-04-30)
7,717 reads
Cool Tool – SQL Space Map
I came across a cool open source tool called “SQL Space Map“.
The tool, written by Ryan McCauley, presents a visual representation...
2013-04-17
896 reads
Weekly Links – 05/04/2013
I’m starting a new tradition:
Before each weekend, I will post links to the best SQL Server stuff i’ve read, heard...
2013-04-05
1,035 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
Alamat BCA KCP Sudirman Mansion Telp:0821-8200-233
Telp/WA 62 8218200233 Sudirman Mansion, JL Jenderal Sudirman, Kav. 59 No.77 Lt. G No....
Alamat BCA KCP Tebet Barat 2 Telp:0821-8200-203
Telp/WA 62 8218200203 Jl. Tebet Raya No.25 B Blok CI, RT.1/RW.2, Tebet Tim., Kec....
Alamat BCA KCP Setiabudi Atrium Telp:0821-8200-174
Telp/WA 62 8218200174 Setiabudi Atrium, Plaza Setiabudi, Jl. H. R. Rasuna Said No.Kave 62...
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