How do you get management to help you figure out if a cluster or an AG is right for you? In this post, Brent Ozar explains the steps involved when doing a review of your SQL Server architecture.
2017-11-09
7,002 reads
The term 'Architecture' seems to imply a plan that you can't easily subsequently deviate from. It's true that, if you abandon software architecture, you end up with a big ball of mud, but maybe the art of software is to make change much easier by planning how to implement each feature, tackling dependency issues, splitting functionality into small discrete components and considering how they should interact with each other.
2016-08-02
5,788 reads
2008-08-21
3,306 reads
This article, the third in a series on enterprise architecture, discusses the approaches to developing an enterprise architecture, describing the methods, benefits and pitfalls of each.
2007-11-26
2,140 reads
This article, the second in a series, discusses what items could be contained in the enterprise architecture and touches briefly on how to organize the objects.
2007-11-20
2,301 reads
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.
2007-08-07
2,040 reads
Reporting is one of the key parts of any data warehouse or business intelligence systems. Vincent Rainardi has brought us some great information on data warehousing and now turns his attention to some of the very useful new features in Reporting Services 2005.
2008-05-26 (first published: 2007-06-14)
10,624 reads
In response to his article on using Reporting Services to manage rights, Jonathan Spink takes a look at how Reporting Services can be positioned in your enterprise.
2006-09-12
5,194 reads
Reporting Services was one of the most popular add-ons to SQL Server 2000 and the next version has been greatly improved. Author Kamran Ali brings us a look at some of the new features and enhancements in this platform.
2006-02-22
19,770 reads
A Feature comparison of Reporting Services for SQL 2000 and Crystal Reports / Crystal Enterprise. PDF file link.
2005-05-03
8,369 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Comments posted to this topic are about the item The Backup File Extension
Comments posted to this topic are about the item Ingest and Retrieve data from...
Comments posted to this topic are about the item The DBAccountant
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers