Free and Cool - MP3
Two big events this week captured Steve Jones' attention. A little MySQL and Apple commentary to break up the week.
Free and Cool - WMV
Two big events this week captured Steve Jones' attention. A little MySQL and Apple commentary to break up the week.
SQL Server 2005 Express Edition - Part 14 - Replication Support
SQL Server 2005 Express Edition's small footprint and free-of-charge use has some negative implications, imposing restrictions on functionality available in the Standard or Enterprise editions. This is especially conspicuous in the case of replication, which we will explore starting with this installment.
SQL Server clustered index design for performance
Find why SQL Server clustered index design should be narrow and static and how clustered indexes affect many-to-many tables to improve database performance.
Adding Custom Code To Reporting Services
Reporting Services has been greatly enhanced in SQL Server 2005 and become an integral tool in many SQL Server installations. Longtime autor Raj Vasant brings us an example of how you can enhance your reports with custom coded DLLs called from within the reporting engine.
Clearing the Bar
How do you decide who gets hired? Do you get the best candidate? Steve Jones says that most of us don't necessarily hire the best person that applies for a variety of reasons.
Tracking Illicit Users
Longtime SQL Server guru David Poole brings us a look at one of the thorny problems a DBA faces: tracking down illicit users.
Application Locks (or Mutexes) in SQL Server 2005
Application locks aren't a well known area of locking in SQL Server, but they can be very useful for special scenarios. They work in an analogous way to the lock() construct in .Net and are basicaly user defined mutexes in SQL Server.
Billee-yons and Billee-yons of Gigabytes - iPod
The amount of data in the world grows every day and there's no end in sight. How big a problem is storage management? Steve Jones shares a few thoughts on how you might manage your storage.
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
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...
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