Last week I was looking for Database Weekly links and ran across Gail Shaw's list of books from 2017. It's an interesting list of fiction, and I might pick up a few this year if I run out of ideas. This reminds me of Paul Randal's review (done annually) of his reading. I usually find a book or two in there that I'd like to read to enjoy a break from life or expand my horizons.
I was thinking about this as I've seen a few other posts from software and database users with books that they recommend. This was an interesting list from Xiaohan Zeng and I like this general list from John Sansom for SQL Server. I've run across a few others, especially from all the learning plans that people built for T-SQL Tuesday #97.
I have no shortage of fiction that I enjoy reading on a regular basis. This is a way for me to get a break from life, and I'm usually working my way through some book. This month I read the Will Robie series from David Balducci (1-4) and then started re-reading the Jesse Stone series by Robert Parker and others. Those are my downtimes and breaks from life. In the professional area, I've been working my way through R in a Nutshell as well as Thoughtful Machine Learning in Python. The latter has been ongoing for some time, and moving rather slow. It's a tough one to go through.
There are classic texts in our industry, as well as some really interesting ones that many of us might enjoy. Perhaps there is something you've read in the last year you recommend, or there are some you want to tackle. Today I'm asking for your reading recommendations.
In our careers, I know many of us like shorter, focused posts, some like videos, and others prefer learning in person from others. Those are all great ways to learn, but I still like working through a book to either focus my learning or escape from life. Let us know today what you plan to read this year or what you'd recommend for others, either to help them become better database developers or just enjoy a good story.
The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.
The industry standard for comparing and deploying SQL Server database schemas
Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial
The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not return the desired result. For the big tables, the counting of the rows could cause blocking as well as take some more time. More »
The majority of traditional database management systems are responsible for making sure that any changes to their data are consistently reflected in the results of subsequent queries. Azure Cosmos DB extends the range of consistency options by providing support for bounded-staleness, session, and consistent prefix models. More »
Many application developers already use continuous integration to automatically test their code, and release management tools to automate application deployment. Database developers can join them. More »
With the GDPR enforcement date looming, organisations are focusing on how data is used internally. This webinar will explain the principals of data protection, translate the GDPR jargon, and cover the steps you'll need to consider to ensure compliance in your software delivery process. More »
FROM dbo.TheCounts AS tc
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth
1 point in this category: count().
We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the
Design and configure SQL Server instances and databases in support of high-throughput applications that are mission-critical and provide consistent response times in the face of variations in user numbers and query volumes. Learn to configure SQL Server and design your databases to support a given instance and workload.
Pick up your copy of this great book today at Amazon today.
Yesterday's Question of the Day
(by Steve Jones):
I ran this code in my database:
CREATE RULE dbo.DBASalaryRange
@salary > 52000
AND @salary < 99000;
EXEC sys.sp_bindrule @rulename = N'dbo.DBASalaryRange' ,
@objname = N'dbo.Employees.Salary';
Now I execute this:
CREATE RULE dbo.NewDBASalaryRange
@salary > 52000
AND @salary < 150000;
EXEC sys.sp_bindrule @rulename = N'dbo.NewDBASalaryRange' ,
@objname = N'dbo.Employees.Salary';
What happens when I execute this statement?
SET Salary = 120000
WHERE EmpID = 1
Answer: The row is updated and no information returned
When you use sp_bindrule to apply a rule to a column that already has a rule bound, the new rule overrides to original one.
NOTE: Rules are deprecated. Check constraints should be used instead.
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.