GigaOm x Pythian: Realities and Risks of Enterprise AI
In a recent interview on the Business Disruptions in Tech podcast, Howard Holton and ...
The Strategic Use of Undocumented Commands It's common practice for IT vendors to keep some of the commands and ...
SQL server folks may find the "non-yielding scheduler" warning familiar and it is usually (if not always) associated ...

Debugging This is a little tip for those who develop SSIS packages.
Introduction When we relate file share and databases, many people will turn up their noses - but today this is a ...
What are Statistics? There are multiple paths a database can use to answer a query, some of them being faster and more ...
After an in place upgrade of SQL server 2005 to SQL server 2008 R2 , I tried to open SQL errorlog from Management> ...
In this blog post, we will look at how you can leverage the Agent statistics to troubleshoot the replication latency ...
The beauty of working for multiple clients from different industries is that you get exposed to a myriad of environment ...
We have reached the last article of this series. To close this series out, we will talk about Distributed Transaction ...
Microsoft introduced Change Data Capture (CDC) technology in SQL Server 2008. This technology captures DML ...
Introduction If a lot of rows or pages are locked, the SQL Server escalates to a table-level lock, to save resources. ...
In Part 1 of this series, we explored Merge Replication Identity Range Management of tables with identity columns. We ...
Have you ever wondered if there's a "secret sauce" for tuning your replication configuration to squeeze out better ...
Oracle 12c introduces new catalog features including CDB_ dictionary views (which include a CON_ID column) superseding ...
The installation: In continuation of our series on how to install a SQL Server 2012 clustered instance, let´s begin the ...
Situation I’ve always wanted to get my hands on SSAS, SSIS and SSRS as I’ve often felt shorthanded in these areas. ...
In this series, I will demonstrate how to install a SQL Server 2012 clustered instance in a cluster of two nodes. In ...
Introduction Along with other administrators, life of us, the DBAs are no different but full of adventure. At times, we ...
There is a time in every SQL Server DBA career where a mail came in with a “replication is not working, please check” ...
Context Sometime back, I was involved in a project that consisted in collecting information for the servers we are ...
Introduction Howdy everyone, One of the most frequent error messages I come across when dealing with SQL Server, ...
Handling Maintenance Failures in SQL Server Availability Groups After migrating some databases to SQL Server 2012 and ...
Problem Statement Have you ever needed to start a new data analysis project or create a report for the business users ...
Context A frequent inquiry concerning databases’ security is to retrieve the database role(s) associated with each user ...
Background It is not unusual that a DBA needs to run the same query across multiple instances. The query can be ...
I have seen lots of questions floating in the msdn forums about SSPI Handshake error, the main question is around error ...
If you do any performance tuning, and everyone does, then you’ll come to a point where you want to know if your tables ...
A database is a defined space stored in the system, grouping user objects. This space can be split into several files ...
One of our clients has a public web page and they needed to ensure that it is always up and accessible. Pythian already ...
TEMPDB, is one of SQL server hot-debated topics; there’s always something to say about its sizing, file placement or ...