Article Featured on SQLServerCentral
My article, ANSI Padding, Trailing Whitespace, and Variable Length Character Columns, is featured in today’s SQLServerCentral newsletter. Check it out!...
2010-07-16
362 reads
Blog Posts
Book Review: Rework
I recently read Rework by Jason Fried of 37 Signals ($13 @ Amazon) and it talks about a lot of philosophy...
2010-07-16
542 reads
How Can I Quickly Script Out Replication?
This script takes a distribution server name and an output directory as parameters then works through all publications on each of the servers that connects to the distribution server,...
2010-07-16
10 reads
How Can I Quickly Script Out Replication?
I recently finished taking down a bunch of servers that I was using to scale out my environment by forcing...
2010-07-16
518 reads
How Can I Quickly Script Out Replication?
This script takes a distribution server name and an output directory as parameters then works through all publications on each of the servers that connects to the distribution server,...
2010-07-16
53 reads
Reminder – Final Day for Speaker Abstracts for SQLSaturday #49!
You can still submit abstracts through midnight tonight for SQLSaturday #49 in Orlando on October 16, 2010. Great time of...
2010-07-16
882 reads
SQL University: Introduction to Indexes
For some crazy reason (probably everyone is on vacation), Jorge Segarra (blog|twitter) who runs SQL University has asked me to...
2010-07-16
551 reads
Steve Jones to Run for PASS Board
I couldn’t hide the lead. Steve Jones (blog|twitter) has announced he’s running for the PASS board. I’m excited. I’m almost as...
2010-07-16
948 reads
SubQuery Performance
Why would you do this?
select distinct(hostname),
(select count(*) as criticalCnt
from @temp where severity_guid='0168A833-1732-411E-8205-C2F6CD91737D'
and hostname=t.hostname
group by hostname),
(select count(*) as criticalCnt...
2010-07-16
1,923 reads
The week that was: Friday 15th July 2010
This is just a short post for a Friday, I have no technical content ready to publish today but lots...
2010-07-16
646 reads
Blogs
TRY_PARSE Limitations: #SQLNewBlogger
By Steve Jones
I got a notification from a question I’d posted at SQL Server Central: Getting...
SQL Server sa Account Security: Rename, Disable & Best Practices
By SQLPals
SQL Server sa Account Security: Rename, Disable & Best Practices In...
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
Forums
Kontak BCA KCU SEMARANG Telp:(08218154392)
Alamat Kontak WA CS 08218154392 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang,...
Alamat Kantor BCA KCU Green Garden Tlp:08217555651
Hub Via Wa:628217555651 Alamat: Blok A.7 No, Komplek, Jl. Perumahan Green Garden 31-35, RT.1/RW.3,...
Alamat Kantor BCA KCU Sunter Telp:08217555651
Hub Via Wa:628217555651 Alamat: Jl. Danau Sunter Utara Jalan Kavling No.3 Blok A, RT.2/RW.18,...
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers