The SQL Server 2005 Maintenance Plan Wizard offers many core tasks and options for database housekeeping. In addition, the wizard will roll all of your selected tasks into a reusable and customizable package. Read on to learn more.
Longtime SQL Server expert and author Michael Coles takes a look at one of the security products that every SQL Server DBA should consider. Read on to find out how NGSSQuirreL can help you.
In this session, Kathi continues her popular series and shows some of the more advanced joining techniques in T-SQL. She shows T-SQL self, outer and cross joins and gives many examples on how to use them.
Relational Data Warehouse or Reporting work loads are characterized by low volumes of very large transactions. These applications are often identified as having predominately read workloads (e.g. Decision Support, Analysis, and Reporting) with periodic feeds or batch loads. It is important to keep these characteristics in mind as we examine the significance of database design, resource utilization and system performance. The top performance bottlenecks or gotchas to avoid for Data Warehouse or Reporting applications are outlined below.
SQL Maestro, maker of tools for a variety of database platforms, is offering a 20% discount on their tools to the SQLServerCentral.com
community.
A whitepaper on getting the best performance from your system.
The topic of cursors is the ultimate "hot potato" in the world of SQL Server. Everyone has a view on when they should and mainly should not be used. By example and testing Robyn Page proves that, when handled with care, cursors are not necessarily a "bad thing".
Maintaining SQL Server security is fast becoming a big part of a SQL Server DBA's job. Longtime security expert Brian Kelley takes a
look at a security scanner: Typhon III
This article shows how the Fuzzy Lookup Transformation in SQL Server Integration Services (SSIS) can be used to make matches.
Danny Lesandrini reviews SQL Refactor, a SQL Server Add-In that works with the new SQL Server Management Studio.
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
Comments posted to this topic are about the item Lots of FKs
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Comments posted to this topic are about the item Can You Let Go of...
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers