The evolving role of the database professional
The role of the database professional is quickly evolving to conform with the ever changing demands of the business world....
2012-04-04
1,221 reads
Blog Posts
Toshiba Satellite C655-S5503 Review
If you are “in computers” according to your family and friends, you are typically expected to provide lifetime, free tech...
2012-04-04
1,503 reads
What’s stopping you?
I mentioned earlier this week that I’m working on a new presentation for SQLSaturday #119 next month. The talk revolves...
2012-04-04
530 reads
Oracle Tips for MSBI Devs #4: Executing an Oracle Stored Proc with IN Parameters in SSIS Execute SQL Task
The first tip I published discussed how to execute an Oracle procedure with no parameters. In this tip, I will...
2012-04-03
729 reads
Powershell – Validating an IP Address
A task that I have had to do several times over the years is determine if an IP Address string...
2012-04-03
4,187 reads
SQL SERVER Replication – Troubleshooting Steps for Beginners
Few days back there was a replication issue in one of the QA servers. Since the DBA was out of...
2012-04-03 (first published: 2012-03-26)
5,413 reads
The first blog post….
Daunting! By way of introduction, I’m Mat This blog is mostly for myself, to document what I know and maybe...
2012-04-03
603 reads
Why an employer should never ask about accessing your Facebook page
There's a brilliant piece of work posted as a fictitious resignation letter that gives some scenarios as to why an employer could...
2012-04-03
1,349 reads
Backup script skipping databases – and the fix!
A real head-scratcher
I’ve been using my RYO Maintenance scripts for a little while now, and they’ve been working great. Almost....
2012-04-02 (first published: 2012-03-26)
1,941 reads
Execution Plans – Table, Clustered Index and Non-Clustered Index Scan
An important operator to understand in execution plans is a scan. A Scan can be good and bad, so understanding...
2012-04-02
4,304 reads
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers