Featured Blog: BACKUP LOG WITH NO_LOG
From one of the SQL Server 2005 storage engine lead developers comes this look at the impact of using the NO_LOG and TRUNCATE_ONLY options.
2007-10-24
3,313 reads
Articles
Performance Tuning
Performance tuning is an art or science, depending on who you talk to. SQL Server guru Joe Sack has authored a book on SQL Server 2005 T-SQL and brings us the performance tuning chapter as a preview.
2007-10-23 (first published: 2006-10-25)
14,545 reads
The Reporting Services 3-Trick Pony
Rodney Landrum demonstrates an ingenious way to monitor blocked SQL Server processes across all your servers, using nothing but SSRS.
2007-10-23
13,593 reads
Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 8
This installment illustrates how to use PowerShell in conjunction with SMO to display object properties of all SQL Server Objects.
2007-10-23
2,594 reads
Distributing SQL Server Databases
Longtime SQL Server author Raj Vasant brings us a technique for delivering databases along with an application. As more and more systems take advantage of SQL Server or Express, this is a technique that can come in very handy.
2007-10-22
5,620 reads
Maximizing Attribute Relationship Aggregations in Changing Dimensions
When designing your SQL Server 2005 Analysis Services (SSAS) dimensions and related attributes—appropriately called attribute relationships—you should consider how changes in your dimension data will affect the underlying dimension aggregations and, in turn, processing and query performance.
2007-10-22
951 reads
Problem connecting to SQL Server 2000 Analysis Services?
Connecting to SQL Server 2000 Analysis Services could lie in the memory settings. Get possible problems and solutions to connect to Analysis Services server.
2007-10-22
2,033 reads
Designing Cross Database Queries
As systems get bigger, servers consolidated, and SQL Server back ends more types of applications, the need for cross database queries for reports, updates, and more will continue to grow. Steve Jones looks at a few ways that you can design your linkages and talks about why he prefers one over the other.
2007-10-19 (first published: 2005-03-09)
32,459 reads
Keep Your Data Secure with the New Advanced Encryption Standard
The Advanced Encryption Standard (AES) is a National Institute of Standards and Technology specification for the encryption of electronic data. It is expected to become the accepted means of encrypting digital information, including financial, telecommunications, and government data. This article presents an overview of AES and explains the algorithms it uses. Included is a complete C# implementation and examples of encrypting .NET data. After reading this article you will be able to encrypt data using AES, test AES-based software, and use AES encryption in your systems.
2007-10-19
2,427 reads
Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 7
This installment of the series illustrates how to use PowerShell in conjunction with SMO to display SQL Server Objects.
2007-10-19
2,740 reads
Blogs
Agentic Architect – Future IT Roles (comparison)
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers