When you're doing any database development work, it won't be long before you need to seriously consider the documentation of your routines. Should we, as a community, propose a common standard for T-SQL headers, and the information that should go into them?
Is there any way that my ad hoc backups will not interrupt the sequence of my backup plan?
Learn how the Execute SQL and Bulk Insert tasks can be combined to create a database and insert data into the database.
Getting a job is hard. If you’ve been lucky enough not to struggle for a job, don’t make the mistake of thinking it will always be easy. Equally, finding a good job is harder still. Some more tips for you to consider: Leverage your recruiter. They know..
Disaster Recovery is always ranked by DBAs and managers as one of the most important things to have set up. Yet many people working with databases don't spend time on this. Steve Jones has a few comments from the news this week.
Part 4 of this series from Drew Salem shows how you build a report in Visual Studio.
Brad engages in a little Summer daydreaming, and wonders what the Ideal DBA job would look like...
Page compression is a new feature available in Enterprise and Developer editions of SQL Server 2008. In this article, MAK discusses how to enable PAGE data compression on a table and index.
Phil enjoys an old Microsoft Training manual and wonders why it is no longer possible to encompass the whole of SQL in a 400 page book any more..
In a recent blog post, see the steps Denny Cherry thinks are vital to monitoring both successful and unsuccessful outside user logins to your SQL Server.
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
Comments posted to this topic are about the item The Large Encoded Value
Comments posted to this topic are about the item The Side Job
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers