Author: Ben Taylor

Editorials

Troubleshooting SQL Server 2005 jobs

Featured Article(s) Troubleshooting SQL Server 2005 jobs (Part 2) In this article, Alexander Chigrik explains some problems you can have with SQL Server 2005 jobs. He also tells how you can resolve these problems. They’d Like To Build You A Disaster Recovery Plan Get a great plan in place and set up your systems so that *anyone* can accomplish a […]

Uncategorized

SQL Server 2005 Tuning Tools and Approaches

Move Beyond "Normal" Reports Have you ever beat your head against the wall trying to get yet another report built for users – or, if you’re using a report, trying to get just a little more information out of that report? Use the right tools to build the reports in the first place and you can empower your users to […]

Editorials

SQL Server 2005 Tuning Tools and Approaches

Move Beyond "Normal" Reports Have you ever beat your head against the wall trying to get yet another report built for users – or, if you’re using a report, trying to get just a little more information out of that report? Use the right tools to build the reports in the first place and you can empower your users to […]

Uncategorized

Injection – a Bit Different – and Important Information

Featured Article(s) Performance Tuning for the Overworked DBA: Part 3: General Performance Considerations In this series I’ve introduced you to the performance triangle of I/O, CPU, and memory. Generally, if you have a performance issue, triage these components and you’ll find some success. I also dove deeper into what I think is the biggest performance inhibitor (especially for BI): the […]

Editorials

Injection – a Bit Different – and Important Information

Featured Article(s) Performance Tuning for the Overworked DBA: Part 3: General Performance Considerations In this series I’ve introduced you to the performance triangle of I/O, CPU, and memory. Generally, if you have a performance issue, triage these components and you’ll find some success. I also dove deeper into what I think is the biggest performance inhibitor (especially for BI): the […]

Uncategorized

Anatomy of a SQL Server Injection Hack on the Show Today

Featured Article(s) Writing efficient Stored Procedures – A Case Study (By G.R. Preethiviraj Kulasingham) Performance optimization of Stored Procedures for developers. This article is a case study, which re-writes a stored procedure in different ways in order to optimize the performance. New Video: SelectViews SQL Server Show Today’s show – we’re looking at the automated SQL Server Injection that’s going […]

Editorials

Anatomy of a SQL Server Injection Hack on the Show Today

Featured Article(s) Writing efficient Stored Procedures – A Case Study (By G.R. Preethiviraj Kulasingham) Performance optimization of Stored Procedures for developers. This article is a case study, which re-writes a stored procedure in different ways in order to optimize the performance. New Video: SelectViews SQL Server Show Today’s show – we’re looking at the automated SQL Server Injection that’s going […]

Uncategorized

Stolen Data Homing Devices… Sort Of.

Final Thoughts on Data Shoplifting Karen: "First–let me start by saying that most contractors I propose are like myself, honest to a fault and extremely careful to not do anything that would even appear to be dishonest or cause any problem at the workplace. We respect and admire the people with whom we work and generally work harder and longer […]

Editorials

Stolen Data Homing Devices… Sort Of.

Final Thoughts on Data Shoplifting Karen: "First–let me start by saying that most contractors I propose are like myself, honest to a fault and extremely careful to not do anything that would even appear to be dishonest or cause any problem at the workplace. We respect and admire the people with whom we work and generally work harder and longer […]

Uncategorized

Trust, but Verify That Keeper of the SQL Server Keys

30 Sessions, 11 Speakers, ALL SQL Server No Travel, No Hotel, Just technical content. Direct to your computer. The SSWUG.ORG Virtual SQL Server Conference Featured Article(s) Troubleshooting SQL Server 2005 jobs (Part 1) In this article, Alexander Chigrik explains some problems you can have with SQL Server 2005 jobs. He also tells how you can resolve these problems. Two Keys, […]