Mastering SQL Server Profiler - Part 4: Profiler Events
The fourth module of the training course "Becoming a Profiler Master", takes a detailed look at the many events and event categories that can be collected with Profiler.
2009-05-14
8,458 reads
Articles
Simple Steps to Creating SSIS Package Configuration File
This new article from Lanre Famuyide shows how to make your SSIS package deployment hassle free by using package configuration files.
2009-05-14
74,672 reads
Data Degradation
The other day at a conference, the subject of data degradation/corrosion arose. The speaker at the conference said that data in a database degraded or corroded over time. The statement was made as if degradation over time applied to all databases. I found this blanket statement to be misguided. Indeed, I think that data does degrade in some databases, but not all.
2009-05-14
2,180 reads
The Best Days
Feeling his age a bit, Steve Jones asks you about yours in this Friday's poll. Where do you think you are in your career as a technologist?
2009-05-14
347 reads
The Best Days
Feeling his age a bit, Steve Jones asks you about yours in this Friday's poll. Where do you think you are in your career as a technologist?
2009-05-14
181 reads
The Best Days
Feeling his age a bit, Steve Jones asks you about yours in this Friday's poll. Where do you think you are in your career as a technologist?
2009-05-14
466 reads
What's a DBA
Most of us are tired of this overused, vague term. How many of you have clicked on a 'DBA' job posting only to find that it's not what you do? Or asked for a DBA resume from a recruiter and gotten something other than what you expected? Or...
2009-05-14
1,999 reads
XML Data Modification Language Workbench
XML Data Modification Language (XML DML) allows you to modify and update XML data. When working with SQL Server Databases, this is the most efficient way to modify elements in an XML column, yet the techniques of using XML-DML have not been well, or simply, described - up until now. Robert Sheldon presents a practical workbench to show the various modify methods
2009-05-14
1,420 reads
Setting up a SQL cluster under MS VS2005 R2 Part1
This article from Perry Whittle looks at setting up a 2 node SQL Server cluster under MS Virtual server 2005 Ent R2 SP1. Something that is very handy for testing clustered servers.
2009-05-13
5,160 reads
Cambridge SQL UG - SSIS and SSRS sponsored by Redgate
Come and join us for this great evening focusing on SQL Server Integration Services and Reporting Services in Cambridge, UK on Wed, May 20, 2009.
2009-05-13
1,313 reads
Blogs
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
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...
Forums
ALAMAT KONTAK BCA KCP Pecatu Telp:08218154393
WA:08218154393 nomor 275 Blok 4, Jl. Raya Uluwatu dan 5 No.99, Ungasan, Kec. Kuta...
ALAMAT KONTAK BCA KCP Ubud Telp:08218154393
WA:08218154393 Jl. Raya Ubud No.10, Petulu, Kecamatan Ubud, Kabupaten Gianyar, Bali 80571
ALAMAT KONTAK BCA KCP Benoa Telp:08218154393
WA:08218154393 Jl. Suwung Batan Kendal No.2, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80222
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers