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
405 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
513 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,148 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
548 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
474 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,402 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,372 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,710 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
637 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,296 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers