Using the UPTIME Utility to Monitor Servers
Learn how to use a free utility to quickly monitor the uptime of your SQL Server instances.
2010-06-23
8,410 reads
Articles
Voting opens for Exceptional DBA of 2010
The voting for the 2010 Exceptional DBA opens today, and you can read about the finalists and prizes inside.
2010-06-23
673 reads
Making your SQL Server database changes backward compatible: Adding a new column
As multi-tier architectures grow over time, it is often challenging to coordinate those changes across the data, logic and presentation tiers. Unless planned and implemented carefully, an act as simple as adding a column to a table can grind all of the components of your application to a halt. While some of us have comfortable 12-hour maintenance windows every weekend, many of us are bound by service level agreements that are much more strict. So we must find ways to introduce fixes and new features with zero downtime, and without requiring every single component to be refactored at the same time.
2010-06-23
3,366 reads
Expert Systems – an SSRS Approach
An interesting approach to solving a complicated problem using SSRS. Users have too much documentation to read about a process, so Jonathan Spink introduces a better way to do things.
2010-06-22
7,512 reads
Creating XML in SQL Server
XML has become a common form of representing and exchanging data in today's information age. SQL Server introduced XML-centric capabilities in SQL Server 2000. That functionality has been expanded in later releases. One aspect of working with XML is creating XML from relational data, which is accomplished utilizing the FOR XML clause in SQL Server.
2010-06-22
4,464 reads
Using Certificates to Sign Stored Procedures
How to sign stored procedures with certificates, this is useful if the procedures use dynamic SQL.
2010-06-21
11,411 reads
Configure Windows Firewall for SQL Server 2008 Integration Services in Windows Server 2008 R2
I have installed SQL Server 2008 on Windows Server 2008 R2 and I am unable to connect to SQL Server 2008 Integration Services Instance from SQL Server 2008 Management Studio which is installed on another remote server. As I am new to Windows Server 2008 R2 it would be great if you can let me know the step by step approach to enable the default port of SQL Server 2008 Integration Services in Windows Firewall for user connectivity.
2010-06-21
3,201 reads
Sorting data in the SSIS Pipeline (Video)
In this post I want to show a couple of ways to order the data that comes into the pipeline. a number of people have asked me about this primarily because there are a number of ways to do it but also because some components in the pipeline take sorted inputs. One of the methods I show is visually easy to understand and the other is less visual but potentially more performant.
2010-06-18
15,661 reads
Concurrent processing in SSIS – Part 1
In the beginning of a new series, Elliott Whitlow shows us how to process your data movement in parallel, covering six different methods for doing so.
2010-06-17
13,009 reads
Writing a Data Access Layer (DAL) for SQL Server
In this tip, I am going to show you how you can create a Data Access Layer (to store, retrieve and manage data in relational database) in ADO .NET. I will show how you can make it data provider independent, so that you don't have to re-write your data access layer if the data storage source changes and also you can reuse it in other applications that you develop.
2010-06-17
5,532 reads
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Alamat kantor BCA KCP Renon Telp:08218154398
WhatsApp:0821-8154-398 Jl. Raya Puputan No.10, Panjer, Denpasar Selatan, Kota Denpasar, Bali 80226
Alamat kantor BCA KCP Bantul Telp (0817)-866887
Wa:0817-866-887 JL. JENDRAL SUDIRMAN NO. 18A RT.007 RW.000, BANTUL WARUNG, DESA. KEL. BANTUL, KEC....
ALAMAT KONTAK BCA KCP Blok M Telp:08218154393
WA:08218154393 Jl. Melawai Raya No.3, RT.3/RW.1, Melawai, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers