From this real-world case study, learn how you can boost SQL Server performance and scalability by off-loading reporting from your production SQL Server to a reporting server, using transactional replication.
Running short of disk space? One way to solve that is to keep fewer backups on disk, or write a routine that will compress them to conserve space. Or you could try SQLZip, an add in that creates compressed backups. Read the review, see if it's something you should consider!
As you advance in your skills as a Transact-SQL developer or SQL Server database administrator there will come a time when you need to override SQL Server's locking scheme and force a particular range of locks on a table. This article by Randy Dyess shows you how to optimize your queries using table hints.
"Certification mania" has hit IT, big-time. Many employers look for certification in potential employees and especially in IT contractors. If you're a data administrator or DBA, you have to consider: could DBA certification enhance my career? Would it deepen my knowledge and increase my value to my company?
This article demonstrates the ability to use the XML DOM on the client-side browser.
As I work with a particular topic or problem, I often research on the Internet different opinions, white papers, etc. Here is a list of resources that are located both on SQLServerCentral.com and other sites that I have found useful.
The core components to Microsoft XML parser have been updated and released to market. The update contains many bug fixes, new features and enhancements to performance.
Steve Jones continues his series on string manipulation. This articles examines the issues of quotes when implementing dynamic SQL.
By Brian Kelley
How long has AI been around in different domains? What was it called before...
By Rayis Imayev
(2025-Aug-04) Taking my last week of vacation and then volunteering at a children's summer camp...
By Chris Yates
Microsoft’s latest wave of announcements in July 2025 offers a compelling snapshot of how...
Scenario 1 (Direct Connection - Fast): On Server B, when using SQL Server Management...
Scenario 1 (Direct Connection - Fast): On Server B, when using SQL Server Management...
Comments posted to this topic are about the item Yet another Date Dimension
SQL Server Always On Availability Groups is the go-to HADR solution for the database platform. Which of the following statements about SQL Server Always On Availability Groups are TRUE?
See possible answers