Isolation level determines how much time your query will spend waiting for other processes to commit their updates. In a transaction databases (where many users are querying and updating at...

I went to PASS 2017 and didn't witness anyone there drunk, dressing provocatively, or getting rowdy; although I have seen it at high school band camp and neighborhood block parties....

..Certainly some people want the freedom to behave as they see fit, where they don't believe they are doing anything wrong. I understand that, but ultimately I also believe...

Perhaps the data science teams at companies like Twitter and FaceBook should turn their analytical skills inward and start asking questions like: "Why is employee #2922 suddenly interested in querying...

First, you need encryption, more encryption, and then encryption again. The guys who rack, stack, and backup the data don't need to decrypt (much less query) the databases at all....

I believe that an analogy can be made between a data breach and an accidental spill of industrial pollution into a river. It would be pretentious to argue that the...

I don't know your database, but it could be argued that if users must routinely perform LIKE '%keyword%' queries on text columns just to locate the rows they are looking...

Today in 2018, when an IT organization is thinking about the next 5 or 10 years, the debate shouldn't be Standard Edition vs. Enterprise Edition or SQL Server vs. PostgreSQL,...

I know how Twilight Zone episodes work; as soon as I would learn PostgresSQL, I'd wake up again and everyone else on the planet would be a SQL Server DBA. 

I went through this a few months back. One snag that I initially ran into when installing a certificate on the server is that the SSL certificate must be installed...

If your first few years in the IT industry resembled an apprenticeship with a mentor and formal training, then you were fortunate. My own personal experience was more like: "Here...