Sometimes Cheaper Makes Sense / Mastering the Basics Always Does
It’s good to remember that the ideas and challenges of mastering a craft – any craft – have been around a while....
2014-02-20
659 reads
Blog Posts
THE IIF statement – SQL has it at last.
TweetG’day All,
While I was writing my last blog post about the new SQL SERVER 2012 CHOOSE statement, it also came...
2014-02-20 (first published: 2014-02-18)
13,695 reads
The Strange Story About the MERGE that Killed the Cluster
I don’t like the MERGE statement. The syntax is weird, it’s tricky in terms of locks, and it has a...
2014-02-20
4,408 reads
Virtual Lab – Creating Differencing Disks
This is part of my series on building a virtual lab for use with SQL Server and Windows. You can...
2014-02-20
1,181 reads
6000 Companies Hiring #DataScientists
“Search engines (Google, Microsoft), social networks (Twitter, Facebook, LinkedIn), financial institutions, Amazon, Apple, eBay, the health care industry, engineering companies...
2014-02-19
457 reads
Be Nice
Years ago when I was just out of the Marine Corps and found myself as the only IT guy in an...
2014-02-19
450 reads
Data Scientist versus Data Architect
I recently had the following discussions with a number of data architects, in different communities, in particular (but not limited...
2014-02-19
1,593 reads
DBA Myths: An index on a bit column will never be used.
Not true. (Or I guess probably wouldn’t be posting about it would I?)
Probably the first thing I should point out...
2014-02-19 (first published: 2014-02-17)
2,632 reads
Free Mathematics Books – No really .. you want these!
Here is an alphabetical list of online mathematics books, textbooks, monographs, lecture notes, and other mathematics related documents freely available...
2014-02-19
617 reads
Getting a query plan
Query plans are an essential tool when doing performance tuning. When looking at a query plan you should be aware...
2014-02-19
1,509 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers