2011 PASS Board Elections Notes
As I write this the final hours for the 2011 PASS Board of Directors elections are ticking away. Before the...
2011-12-20
947 reads
Blog Posts
FOR XML PATH using node tests in column aliases
I've used SQL to generate countless blobs of xml over the years and one feature that I have come to...
2011-12-20 (first published: 2011-12-15)
8,845 reads
Full Load. Incremental Load. Whaaat?
Back when i was in school, me and a bunch of friends used to hangout at a diner. The diner was...
2011-12-20
6,692 reads
How I Got Started in Software Development-A Tribute to Ed
A tribute is an expression of gratitude or praise. As I head into this holiday season I wanted to express...
2011-12-20
511 reads
Mark a Disk Partition as Inactive
If you are like me then you like to reinstall Windows on your laptop every few months to keep things...
2011-12-20
902 reads
Modifying SQL Server Synonyms
One task that often needs to be done when migrating a database to production for the first time is to...
2011-12-20
1,383 reads
Public Role and Security
A good rule of thumb with the public role is to leave it be. Do not add permissions to this role. Add permissions on a per database and per...
2011-12-20
16 reads
SQL Server 2012 – new conversion functions
With SQL Server 2012 comes a new set of conversion functions, that will certainly help doing type casts and conversions...
2011-12-20
1,198 reads
SQLSaturday Goes International
Looking at 2011 and the planned events so far for 2012 it’s easy to see that SQLSaturday is starting to...
2011-12-20
657 reads
Contracting is business not employment: Read the small print
This post is about a contracting in UK. Some of terms mentioned here will not mean a great deal to...
2011-12-19
1,204 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Alamat Kantor BCA KCU BANGKALAN Telp:0817839777
WhatsApp: 0817839777 Jl. Trunojoyo No.15 A, Pejagan, Kec. Bangkalan, Kabupaten Bangkalan, Jawa Timur 69112
Alamat Kantor BCA KCU PROBOLINGGO Telp:0817839777
WhatsApp: 0817839777 Jl. Suroyo No.28, Tisnonegaran, Kec. Kanigaran, Kota Probolinggo, Jawa Timur 67211
Alamat Kantor BCA KCU TULUNGAGUNG Telp:0817839777
WhatsApp / CS:0817839777 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers