Storing IPv4 Addresses for Performance
An in-depth analysis on how to store IPv4 addresses to achieve maximum efficiency and performance in both storage and queries
Test Drive
Hiring a new employee can be a hit or miss proposition. We often don't learn much about how someone will work from an interview. Steve Jones talks about an alternative way to hire someone by taking them for a test drive.
The 2009 SQLServerCentral Opening Night Party
SQLServerCentral is hosting an opening night party at the 2009 PASS Summit. Read more about this and learn how to get a ticket.
How to create SQL Server virtual appliances for Hyper-V
Creating a private SQL Server VAP will reduce the time it takes to deploy additional SQL Server machines in your environment.
Replication – Accommodating Application Inserts
Recently I have been involved in lots of projects involving replication. I have done some things to make replication work...
SQL Backup 6: Wind of Change
One could be forgiven for thinking that there's little more you can do with third-party backup software than just ...er... backup databases. Shawn McGehee gives us his personal take on the implications of the improvements that have been made to SQL Backup for version 6.
Test Drive
Hiring a new employee can be a hit or miss proposition. We often don't learn much about how someone will work from an interview. Steve Jones talks about an alternative way to hire someone by taking them for a test drive.
Test Drive
Hiring a new employee can be a hit or miss proposition. We often don't learn much about how someone will work from an interview. Steve Jones talks about an alternative way to hire someone by taking them for a test drive.
Test Drive
Hiring a new employee can be a hit or miss proposition. We often don't learn much about how someone will work from an interview. Steve Jones talks about an alternative way to hire someone by taking them for a test drive.
DBA: Mentor vs. Protector
To mentor or to protect data, what is the role of the DBA? A guest editorial from Matt Simmons.
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