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 […]

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 […]

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 […]

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 […]

New Fireside Chat – SelecTViews SQL Server 2011 upcoming features, SQL Server tip, recent news and more. [Watch the Show Here] Featured White Paper(s) An Introduction to Workload Tuning Workload Tuning is just what it sounds like: tuning the performance of all processes that comprise a database workload in one… (read more) Free On-Demand Webcast: Do It Right: Best Practices […]

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 […]

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 […]

Featured Article(s) Troubleshooting SQL Server 2008 full-text search In this article, Alexander Chigrik explains some problems you can have with SQL Server 2008 full-text search. Scheduling Jobs For Your Databases Steve has been doing a series of Articles on TSQL, the last of which he focuses on Job Schedulers for SQL Server, TSQL 10 – Need To Know Information About […]

Featured Script Base64 Decoder This function takes a Base64 encoded string and decodes it. This function does not work for unicode data… (read more) Keep Up With MS Packaging One of the things about we can count on in Microsoft Packaging and Licensing is that it will change. I was recently shocked to find out that some of the SQL […]

Featured Article(s) TSQL 103 Part 2 of 2 Getting started with Stored Procedures, the benefits of them and much more. One Response for Stored Procedures So far I have only received one response to the previous editorial, "Are Stored Procedures the Only Way to Go?" Scott replies in much detail why he prefers to use stored procedures compared to inline […]