This is how I recovered from a catastrophic failure
I was fresh off the boat* from South Africa, working in a small computer store in an equally small town...
2017-08-09
141 reads
I was fresh off the boat* from South Africa, working in a small computer store in an equally small town...
2017-08-09
141 reads
Last week we looked at ACID compliance. This week we dive a little deeper into the Isolation portion, and what...
2017-08-02
126 reads
Relational database management systems (RDBMS) such as SQL Server, Oracle, MySQL, and PostgreSQL use transactions to allow concurrent users to...
2017-07-26
140 reads
During a Q&A session I hosted at our local Calgary SQL Server User Group last month, one of the attendees...
2017-07-19
144 reads
Today’s public service announcement is a reminder to be wary of date formatting in SQL Server. On a recent mailing...
2017-07-12
148 reads
We can easily spend tens of thousands of dollars on core licences for SQL Server, and then we go and...
2017-07-05
167 reads
The Database Fundamentals series is now done. We started with understanding what a database is, and then spent a little...
2017-06-28
343 reads
In 2017, there’s no excuse not to have at least a testing environment, and preferably a development environment as well,...
2017-06-21
131 reads
My First DELETE Statement Here are the links to the previous posts in this series: My First SELECT Statement My...
2017-06-14
136 reads
My First UPDATE Statement Last week we covered how to put information into a table using an INSERT statement. This...
2017-06-07
124 reads
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
By Steve Jones
ioia – n.the wish that you could see statistics overlaid on every person you...
First off, my apologies for what could potentially be a bad title! I am...
I've inherited a couple of rather large databases from my ex-colleague when I join...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers