I Am Grateful For…
I’m almost done reading the book Connected (will be by the time this is published). It’s fascinating although, at least so...
2015-05-15
499 reads
The Scary DBA
Is Performance Better With LEFT JOIN or RIGHT JOIN?
I tend to write my queries using LEFT JOIN. Why? Because logically I see it in my head like this:
Give...
2015-05-20 (first published: 2015-05-11)
7,034 reads
Effects of Persisted Columns on Performance
I live for questions. And my favorite questions are the ones where I’m not completely sure of the answer. Those...
2015-05-13 (first published: 2015-05-05)
5,926 reads
Speaker of the Month: May 2015
I finally got out to some community events last month and got to see a bunch of great speakers. Not...
2015-05-01
507 reads
Benefits for Some, All or Only a Few
As a member of the PASS Board of Directors I attended the PASS Business Analytics Conference (BAC) recently. You can...
2015-04-27
507 reads
PASS Board Update: April 2015
It’s been a pretty interesting month on the board.
First, we did have a little problem. I’m sure one or two...
2015-04-23
519 reads
Query Hash Formula Changes Between Versions
The question came up on SQL Server Central that someone wanted to track queries on their 2008R2 instance and on...
2015-04-21
605 reads
Azure SQL Database v12 and SQL Magazine
I spend many of my evenings researching and writing. Sometimes it’s writing new books. Sometimes it’s fixing and rewriting old...
2015-04-16
676 reads
Azure SQL Database Firewall Settings
The new portal for managing Azure is pretty. I’m not sure I’m in love with it, but it’s pretty.
However, one...
2015-04-24 (first published: 2015-04-13)
5,233 reads
I Am Grateful For
I decided in January that I would write regularly about people that I’m grateful for. Now it’s April. Oops.
The concepts...
2015-04-10
530 reads
Blogs
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
Forums
When trying to use a LocalDB, I get an error
I tried to find an appropriate forum to post the question. This one seems...
Resolving Access Denied Errors During SQL Server Database Attachment
Comments posted to this topic are about the item Resolving Access Denied Errors During...
The Lesser Used Functions
Comments posted to this topic are about the item The Lesser Used Functions
Question of the Day
SQL in an Azure VM Backup
If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)
See possible answers