SQL Server 2005 Express Edition - Part 3 - Installation
Part 3 of this series describes the installation process of different versions of SQL Server 2005 Express Edition in more detail, including changes introduced in its Service Pack 2.
Katie's Raffle
We've had more prizes donated for the raffle to raise money for Katie. See what you can win and support an IT family in need.
Professional Development Plans
Ensuring that our careers grow is something that each of us must take charge of and Andy Warren brings us one of the ways in which you can do this: create a plan. Andy talks about how you can structure a plan at different stages of your career.
Custom reports in Management Studio, using the Performance Dashboard
If you are using SSMS and SQL Server 2005 SP2, You've probably tried out the database reports that are available in the Performance Dashboard, and decided how useful they are, but did you know that you can create your own dashboard reports?
Reporting@Home: Delivering Dynamic Graphical Feedback to Participants
A new generation of computationally intensive scientific research projects relies on volunteers from around the world contributing idle computer time to calculate mathematical models. Many of these projects utilize a common architecture to manage the scheduling and distribution of calculations and collection of results from participants. User engagement is critical to the success of these projects, and feedback to participants illustrating their role in the project’s progress is known to increase interest and strengthen the community.
Server Farm Reporting - Part 2
Building on his first article examining management of a large server farm, Mark Tierney brings us part 2 in which he examines the data gathering process.
Case Study: Denver International Airport Keeps Operations/IT (and Pass
AlarmPoint Enterprise automates alerting process and protects airport's massive information and communications network from business-impacting outages.
Compatibility of SQL Server 2005 and 2000 coexisting
When installing a SQL Server 2005 instance on your SQL 2000 machine, there are upgrade and compability issues such as linked servers, multi-server administration and log shipping.
Using Non-Standard Port for SQL Server
Greg Larsen examines setting up SQL Server to listen on a different port number than 1433.
What Data is in SQL Server's Memory?
SQL Server memory is primarily used to store data (buffer) and query plans (cache). In this article I'll show how much memory is allocated to the data buffer (or RAM). I'll explain how to determine what tables and indexes are in the buffer memory of your server.
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