A Review of NGSSQuirreL
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.
2007-02-08
7,620 reads
Articles
Joining Tables Part 2
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.
2007-02-08
5,022 reads
Top 10 SQL Server 2005 Performance Issues for Data Warehouse and Repor
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.
2007-02-08
2,615 reads
SQL Maestro Offers SQLServerCentral.com Members a Discount
SQL Maestro, maker of tools for a variety of database platforms, is offering a 20% discount on their tools to the SQLServerCentral.com
community.
2007-02-07
1,500 reads
Analysis Services Performance Tuning Whitepape
A whitepaper on getting the best performance from your system.
2007-02-07
2,567 reads
Robyn Page's SQL Server Cursor Workbench
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".
2007-02-06
2,669 reads
A Review of Typhon III
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
2007-02-05
5,756 reads
Using Fuzzy Lookup Transformations in SQL Server Integration Services
This article shows how the Fuzzy Lookup Transformation in SQL Server Integration Services (SSIS) can be used to make matches.
2007-02-02
2,938 reads
Product Review: SQL Refactor
Danny Lesandrini reviews SQL Refactor, a SQL Server Add-In that works with the new SQL Server Management Studio.
2007-02-01
2,964 reads
SQL Server Spotlight on Bob Dorr
We continue with our look at the people behind SQL Server with a very interesting interview from one of the senior support
engineers, Bob Dorr.
2007-01-31
4,792 reads
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Going Native with Fabric Spark Pools: The Fabric Modern Data Platform
Comments posted to this topic are about the item Going Native with Fabric Spark...
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers