Speaking at the 2014 PASS Summit
Finally the email we’d all been waiting for arrived yesterday, the results of session selection for the 2014 PASS Summit....
2014-06-25
736 reads
Dealing with a long string
Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the...
2014-06-25
2,628 reads
Wanted: Senior DBA or Dev-DBA (And So Darn Hard to Find!)
I mentor, teach, and consult about SQL Server. It’s an incredible tool –it is an extremely flexible, adaptable, and complex data environment. SQL Server is capable of bringing tremendous...
2014-06-25
11 reads
Wanted: Senior DBA or Dev-DBA (And So Darn Hard to Find!)
I mentor, teach, and consult about SQL Server. It’s an incredible tool –it is an extremely flexible, adaptable, and complex data environment. SQL Server is capable of bringing tremendous...
2014-06-25
9 reads
Wanted: Senior DBA or Dev-DBA (And So Darn Hard to Find!)
I mentor, teach, and consult about SQL Server. It’s an incredible tool –it is an extremely flexible, adaptable, and complex...
2014-06-25
469 reads
SQL Server – Script to Identify and Update Database Auto-Growth Setting
An auto-growth event is the process by which the SQL Server engine expands the size of a database file when...
2014-06-25
1,104 reads
Finding Checked Out Files in TFS
There may be an easier way, but this was a quick way to find ALL the checked out files in...
2014-06-24
1,462 reads
Space Used by Database Files
Retrieve data about size and space used for all the files in the current database with this script.
Some tips on...
2014-06-24
776 reads
No Files For You
No Files For You is another Question Of The Day. I ended up making this one just a little more...
2014-06-24
480 reads
PASS DBA VC Session 25th June
It’s always an honour to be able to speak at an event, but events can be expensive to attend and...
2014-06-24
690 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
BCA KCU WISMA MILLENIA Telp:0821-8200-233
Telp/WA 62 821-8200-233 Jalan Letjen M.T. Haryono No.Kav. 16 11, RT.11/RW.5, Tebet Bar., Kec....
Alamat Kantor BCA KCP Blok M Telp:0821-8200-174
Telp/WA 62 821-8200-174 Jl. Melawai Raya No.3, RT.3/RW.1, Melawai, Kec. Kby. Baru, Kota Jakarta...
BCA KCU KUNINGAN Telp:0821-8200-203
Telp/WA 62 821-8200-203 Menara Karya, Jl. H. R. Rasuna Said Ground floor, RT.1/RW.2, Kuningan,...
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