It's easy to create a database nowadays with point-'n-click, but if you've left your database's autogrowth settings at their default, you may hit problems in the future. Why? What to do about it? Read on!
Is is time to consider sharing your database server with other applications? Steve Jones thinks with today's powerful servers and changes to licensing, this might make sense.
Often databases are used with web-based interfaces and recording the IP address of the end user can assist with debugging, marketing, bandwidth planning and collation selection to name a few. In a scenario where each page access is logged, is there an optimal way to store IP addresses?
We’d like your thoughts on what new features should go into our backup tools. Let us know by completing this short survey.
A good security scheme will contain many layers. Today Steve Jones talks about one of those: good habits.
Why should any SQLserver administrator, DBA, or Developer be interested in Powershell? Johan Bijens presents a few reasons today.
What do SQL joins and the "teach a man to fish" Chinese proverb have in common? SQL joins, like regular expressions, are one of those commonplace programming tasks in which true success is entirely dependent upon your ability to conceptualize the outcome. Fail to do so and you'll likely wind up spending a few hours in a frustrating round of trial and error. Like regular expressions, the proliferation of online examples has actually contributed to the frustration, providing the equivalent of a day's worth of fish rather than the proverbial fishing pool.
This article from Warren Campbell shows a process to recreate permissions in development environments after restoring a database from a production instance.
Transparent Data Encryption is only available in Enterprise Edition and above. Steve Jones thinks that's a mistake.
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Hi all Can I get some perspective from the community please on performing in-place...
Comments posted to this topic are about the item How Long is a Long...
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers