Featured Script Save / append logfile (ASCII) This generic proc appends/creates an ASCII (log) file to an alternate place…. (read more) Influence As the year comes to a close my mind turns back on all the different people with whom I have worked. Having started programming in the early ’80s results in a lot of individuals. I find it interesting […]
Author: Ben Taylor
Leverage Your SQL Server Skills with Third Party Tools
Leverage Your SQL Server Skills with Third Party Tools I decided to take a look in Google to see what tools have the ability to utilize SQL Server database engine for persistence. Most likely, each of these tools benefit from the skills of a savvy DBA for performance, maintenance, and security. I restricted myself to 10 minutes to see what […]
Leverage Your SQL Server Skills with Third Party Tools
Leverage Your SQL Server Skills with Third Party Tools I decided to take a look in Google to see what tools have the ability to utilize SQL Server database engine for persistence. Most likely, each of these tools benefit from the skills of a savvy DBA for performance, maintenance, and security. I restricted myself to 10 minutes to see what […]
dbForge Data Studio for SQL Server
Featured White Paper(s) Free Poster – SQL Server Perfmon Counters of Interest When you’re looking for a reliable tool to diagnose SQL Server issues, Perfmon is often the answer. No more wasting time trac… (read more) dbForge Data Studio for SQL Server While reading my email I came across an announcement from devart located at www.devart.com. They announced the release […]
dbForge Data Studio for SQL Server
Featured White Paper(s) Free Poster – SQL Server Perfmon Counters of Interest When you’re looking for a reliable tool to diagnose SQL Server issues, Perfmon is often the answer. No more wasting time trac… (read more) dbForge Data Studio for SQL Server While reading my email I came across an announcement from devart located at www.devart.com. They announced the release […]
Denali Includes Sequences
Featured White Paper(s) VIDEO WHITEPAPER – How to Avoid Downtime – VIDEO WHITEPAPER In this Experts & Insights video, we take a close-up look at the data protection challenges and solutions surrounding downtim… (read more) Featured Script admin script – change the SID of a login without loss of security settings To avoid problems with orphaned users when you need […]
Denali Includes Sequences
Featured White Paper(s) VIDEO WHITEPAPER – How to Avoid Downtime – VIDEO WHITEPAPER In this Experts & Insights video, we take a close-up look at the data protection challenges and solutions surrounding downtim… (read more) Featured Script admin script – change the SID of a login without loss of security settings To avoid problems with orphaned users when you need […]
Server Side Paging
Server Side Paging A new feature being released (sadly, one of the very few TSQL Enhancements) in SQL Server Denali is the ability to do server side paging. You have a web page allowing you to display a limited amount of rows. It calls a database query that may produce many more times the number of rows presented. This is […]
Server Side Paging
Server Side Paging A new feature being released (sadly, one of the very few TSQL Enhancements) in SQL Server Denali is the ability to do server side paging. You have a web page allowing you to display a limited amount of rows. It calls a database query that may produce many more times the number of rows presented. This is […]
Use a Table as a Message Queue
Featured Article(s) Installing and Configuring Reporting Services (Part 1 of 3) In this session, readers will learn the basics of installing Microsoft SQL Server Reporting Services. This session will cover common installation situations and will discuss some of the more common pitfalls that surround the installation. This session will also cover the basics of Reporting Services configuration options, including basic […]