Today, in a surprise development that has stunned industry analysts, SQLskills.com announced a new technology for DBAs that will help in the never-ending battle against human-error and unforeseen disasters. The patent-pending Time-Setback technology allows DBAs of SQL Server to literally rewind time and avoid disasters before they happen.
2008-04-01
2,298 reads
In Reporting Services in SQL Server 2005 there are several ways of achieving the same result. This article introduces how we can create the same report using several different methods.
2008-03-31
2,794 reads
Installing SQL Server Reporting Services is just the first step in building the foundation for a solid Reporting Services instance. The second step in the process is configuring Reporting Services to conform to the particulars of your environment. These configurations are made to the RSServer.config file via the Reporting Services Configuration Tool.
2008-03-31
2,819 reads
The sp_lock system stored procedure is a great tool for checking the amount of locking that occurs on your database system. It returns the number and types of locks that are being held by current active SQL Server sessions.
2008-03-31
2,359 reads
This white paper presents general information, best practices, and tips for designing charts within Microsoft SQL Server Reporting Services reports. It provides an overview of some Reporting Services features, answers common chart design and feature questions, and includes advanced examples of how to design better charts.
2008-03-28
2,595 reads
In Part 1 of a 3 Part Series Joydip Kanjilal discusses the implementation of a provider independent Data Access Layer in ADO.NET.
2008-03-28
3,958 reads
LINQ to Objects and LINQ to Entities have an arsenal of Standard Query Operators that operate on sequences to perform a wide variety of operations.
2008-03-28
2,355 reads
If you have configured database mirroring in synchronous with or without automatic failover mode, you can switch to the mirror server instance and make it available to the clients while you perform hardware or software maintenance on the principal server instance. So let’s see how we can do this:
2008-03-27
2,029 reads
Integration Services, which replaces Data Transformation Services (DTS) in SQL Server 2005, is a tool for extracting, transforming, and loading data.
2008-03-27
4,921 reads
In this article Dinesh Priyankara shows how Visual Studio Team Edition for Database Professionals can be used to perform data comparison.
2008-03-26
2,707 reads
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
A sequential scan is not always a problem — PostgreSQL's planner often chooses one...
I’ve been thinking a lot lately about what it actually takes to make an...
Good Morning. I have a T-SQL Script which has been developed to execute a...
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Comments posted to this topic are about the item Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers