What is Azure SQL
I get asked about Azure SQL very often. This is a topic that I’ve written about and taught many times. To be honest, this is a rather large topic...
2023-11-17 (first published: 2023-10-25)
420 reads
Blog Posts
PASS Data Summit 2023 KeyNote 2
Morning from the PASS Data Summit! I will be live blogging the event again today, so check back for announcements and releases throughout the keynote. Today, we will dive...
2023-11-16
66 reads
Women in Tech: Finding Allies #PASSDataSummit
The WIT panel spoke on an excellent topic today: needing, and finding, allies at work. Afterward and for the first […]
The post Women in Tech: Finding Allies #PASSDataSummit appeared...
2023-11-16
48 reads
Adding a Foreign Key in the CREATE TABLE statement–#SQLNewBlogger
I had someone ask this question recently and had to double check the syntax myself, so I thought this would make a nice SQL New Blogger post. Another post...
2023-11-15 (first published: 2023-10-30)
340 reads
Common Mistakes in SQL Server – Final
In this final and summary post on the blog series of Common Mistakes in SQL Server I have pen down about auto growth, use of null values, implicit conversion...
2023-11-15 (first published: 2023-10-30)
559 reads
Deploying Indexes with SQL Compare
I suspect many people assume this is the case, but a customer recently asked if SQL Compare handles indexes. It does, and this post shows the basics of index...
2023-11-15
169 reads
PASS Data Summit 2023 KeyNote 1
Morning from the PASS Data Summit! I will be live blogging the event today, so check back for announcements and releases throughout the keynote. Today, we have Shireesh Thota,...
2023-11-15
101 reads
SQL Server Recovery Models
When I review customers database environments, I always check to see what the recovery model is for their databases and review that with the customer. I often times have...
2023-11-15
16 reads
Webinar: How to Harden SQL Server
On November 29, 2023, at 11 AM Eastern Standard Time, I'm presenting a webinar on how to harden SQL Server.
2023-11-15
185 reads
My data architecture book is now available for pre-order!
For those looking to be first in line when my book is available for a printed copy, I’m very excited to let you know that it is now available...
2023-11-14
32 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers