Small business tool makes SQL backup fast, simple and economical
Red Gate Software is releasing a low-cost version of its best-selling SQL Backup tool that makes data protection for small businesses fast and simple.
SQL Server 2005 Large Value Data Types
Microsoft has come to the rescue for managing large text fields in SQL Server 2005, by creating a few new large value data types. This article explores these new data types.
Managing DTS packages - Editing, Scheduling, and Viewing Package Logs
In the second of a series of articles that targets the DBA new to an organization, this article looks at how to manage DTS packages.
Beginning SQL Server 2005 Reporting
In Part 1 of this article, we looked at the basics of SQL Server Reporting Services 2005 (SSRS). We built one report with the Report Wizard, and one report using the Report Designer. In Part 2, we are going to look in more depth at the features that you can use everyday as an SSRS developer.
Configuring Design DB for Team Edition for Database Professionals
This video by Richard Waymire will describe how to install and configure SQL Server 2005 to support Visual Studio Team Edition for Database Professionals database projects.
TOP in SQL Server 2005
There are so many new features in SQL Server 2005 that there's one that can make a significant impact in solving many different types of problems. Andy Warren takes a look at one of the features that has been enhanced and is extremely useful, albeit quirky: TOP.
Analysis: Where Rules Management and BPM Meet
Is your company trying to accelerate cycle times, lower costs, improve responsiveness, ensure compliance with policies and best practices, and increase customer satisfaction? Well, of course! That's why you need a comprehensive approach to managing your organization's business rules
Large Object Data
Dealing with text, image, and other large object data types can be confusing for many people, in all aspects of working with them. However one place that is important is performance. SQL Server MVP Simon Sabin brings us a few thoughts on improving performance with these columns and the Text in Row setting.
Invoke UDFs that accept tables with SQL Server 2005's APPLY operator
Tim Chapman discusses using table valued functions with the APPLY function.
Writing Simple Select Statements
In this video, you'll learn how to write basic select statements. This beginner video takes you from the ground up writing T-SQL.
Blogs
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers