The Exceptional DBA’s Code of Conduct
This is a reprint of chapter 11 of my book, How to Become an Exceptional DBA, 2nd Edition, which is...
2009-12-21
733 reads
This is a reprint of chapter 11 of my book, How to Become an Exceptional DBA, 2nd Edition, which is...
2009-12-21
733 reads
"You can have everything in life that you want if you will just help enough other people get what they...
2009-12-08
741 reads
Starting Wednesday, December 9, 2009, I am on vacation until Monday, January 4th, 2010. Instead of traveling somewhere else for...
2009-12-08
403 reads
In case you haven’t discovered this for yourself, SQL Server Profiler is one of the most powerful tools that come...
2009-12-07
1,406 reads
Devenius Software is offering a free tool to help you manage SQL Server encryption keys. Its called the SQL Encryption...
2009-12-05
552 reads
2010 is beginning to look like a great year for SQLSaturday events this year. Already, there are nine planned, and...
2009-12-05
417 reads
While I have been working for Red Gate Software for nearly three years, it was only until this year that...
2009-12-05
760 reads
I have been involved in the SQL Server community since 2000, and during the past nine years I have seen...
2009-11-30
1,461 reads
A guest editorial from Brad McGehee today examines the way in which DBAs interact with the community. Do you take from the community, learning from others? Or do you give back more? Both are a part of many DBAs' careers. Brad talks about the importance of giving back when you can.
2009-11-30
79 reads
Ola Hallengren has recently updated his popular free SQL Server database maintenance scripts to support the newest point release of...
2009-11-26
1,440 reads
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Hub Via Wa:628217555651 Alamat Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel.,...
Hub Via Wa:628217555651 Alamat Jl. Ciledug No.162, Kota Kulon, Kec. Garut Kota, Kabupaten Garut,...
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers