Turning off a server causes a flood of memories
I just shut down a SQL Server that has been in production since 2003. Next week I'll let the server...
2008-02-17
403 reads
Kathi Kellenberger
- Interests: Walking, running, grandchildren!
Speaking updates
If you are anywhere near St. Louis next Wednesday night, I will be speaking at the St. Louis Visual Basic...
2008-02-16
512 reads
A Review of PDF-eXPLODE
Reporting is a huge part of any DBA's job with constant changes and new requests for data that non-technical people can use. And more
and more often the format of choice is PDF, which ensures the end result looks the same on many different platforms. Kathi Kellenberger takes a look at a product that can allow end-users to generate PDFs from a database and easily send them to other people.
2008-02-07 (first published: 2007-02-15)
8,133 reads
Finding missing rows
One way to find the rows from one table that don't match another table is to use a sub-query. Here is...
2008-01-22
542 reads
End to End T-SQL!
After a couple of months of discussion, End to End Training has scheduled me to teach a two day beginning...
2008-01-03
473 reads
Finding Primes
While it's not likely that many of you need to find prime numbers using T-SQL, it is an interesting programming exercise. SQL Server guru Kathi Kellenburger brings us one solution after taking a break over the holidays and reading some popular fiction.
2008-01-01 (first published: 2007-01-29)
7,399 reads
70-431
I finally sat for 70-431 on Thursday. I know, I am at least a year behind everyone else. There is...
2007-12-22
1,370 reads
Confused?
I recently wrote an article on owners vs schemas for SQLTeam thinking that I had this all figured out. So...
2007-11-20
1,705 reads
bcp Utility
There was a time that I avoided bcp utility like the plague. A few years ago, we needed to set...
2007-11-09
636 reads
Clustered Indexes
I work almost exclusively with third party applications. I don't get to do a lot of tuning except for reports...
2007-09-30
1,294 reads
Blogs
Building AgentDBA’s Slack Escalation
By Arun Sirpal
Until now, a CRITICAL finding did the right internal routing, but the last mile...
Changing the Owner Removes Permissions: #SQLNewBlogger
By Steve Jones
This is actually inspired by an article SQL Server Central, which taught me something...
T-SQL Tuesday #200 - I Bet It's Bad if I See...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
ALAMAT BCA KCU INDRAPURA Telp:08218154393
WA:08218154393 Jl. Indrapura No.35, Kemayoran, Kec. Krembangan, Surabaya, Jawa Timur 60176
ALAMAT KONTAK BCA KCU TEGAL Telp:08218154393
WA:08218154393 Jl. A. R. Hakim No.2, Mangkukusuman, Kec. Tegal Tim., Kota Tegal, Jawa Tengah...
Developer edition cannot connect from other computers
I installed a new SQL server 2025 Enterprise developer edition for our development environment....
Question of the Day
Moving the Error Log
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers