Temporary Indexes
Temporary indexes can speed up processes that run periodically in your applications. This Friday Steve Jones asks how many of you use temporary indexes and how you do so.
SQL Diag Configuration Tool
SQL Diag is a very useful diagnostic tool that will help capture performance information from SQL Server. This tool is shipped with the SQL Server product. Howerver there is not an easy way to configure the tool - it requires the hand editing of an XML file, which is tedious and error prone. That is until now!
SQL Diag Configuration Tool (SDCT) is an intuitive, easy to use tool that will read existing sqldiag.xml configuration files, allow you to select your desired options and save those options to a new file.
SSIS Event Handlers Basics
SSIS event handlers are the simplest means of turning an SSIS script into a reliable system that is auditable, reacts appropriately to error conditions, reports progress and allows instrumentation and monitoring your SSIS packages. They are easy to implement, and provide a great deal of flexibility. Rob Sheldon once again provides the easy, clear introduction.
SQL Server 2008 Installation Issues - Issues and Workarounds
MVP Robert Pearl explains how to get around some common issues that might occur when installing SQL Server 2008 on Windows 7.
When To Hire a DBA
When should you hire a DBA? Always, of course! Actually Steve Jones doesn't have an answer, but he does talk about why a DBA can help you.
Check your Digits
The most persistent struggle in data processing has been to ensure clean data. There are many ways that data can be incorrect and a database must check, as best it can, that the data is correct. The CHECK constraint is ideally suited for this sort of work, and the checking routine can become quite complex when dealing with check digits in data.
Showing Its Age
Computer Systems are aging and as companies try to save money by extending their lifetimes, are we going to see more issues?
When a SQL file will not open in SSMS
What happens when double clicking a .SQL file doesn't open the file in SSMS? This article provides the solution to fixing that annoying SSMS issue.
Adding Column to a SQL Server Table
This article examines the difference between adding a nullable column to a table or a column with a default value.
Less Pay, More Convenience
Steve Jones talks telecommuting today as a recent survey shows that a third of IT professionals would take less pay to work away from the office.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCU HARAPAN INDAH. Tlp/wa:0853-7373-7845
Jl. Sentra Niaga Jl. Harapan Indah Boulevard Kav. CP2 No. 1, Pusaka Rakyat, Kec....
BCA KCP Kas Jatiwaringin. Tlp:085373737845
Giant, Kompleks Ruko Graha Indah, Blok F/1, RT.001/RW.002, Jatiwaringin, Pondok Gede, Bekasi, West Java...
BCA KCP Buaran Raya Hub.0853•5504•2311
BCA KCP Buaran Raya Hub.0853•5504•2311 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101,...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers