A New Word: Vaucasy
vaucasy – n. the feat that you’re little more than a product of your circumstances, that for all the thought you put into shaping your believes and behaviors and...
2023-11-17
36 reads
Blog Posts
Help! My Docker SQL Instance Won’t Start!
One day, I shut down my computer, as I usually do nightly. This time, I shut it down on a Friday and turned it back on after a holiday...
2023-11-17 (first published: 2023-11-03)
187 reads
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)
416 reads
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
63 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
44 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)
335 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)
555 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
166 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
100 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
12 reads
Blogs
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
Keeping MS Docs Up to Date
By Steve Jones
One of the things that I like about the SQL Server docs (MS Learn...
Patch Tuesday – Where to get more information
By Brian Kelley
For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday...
Forums
is there a no code way to limit an ssis extract from excel to the 1st 21 rows?
is there a no code way to limit an ssis extract from excel to...
Pivot but preserve all rows on Aggregate column
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
any reason to avoid asking ssis to extract files from ftp
hi we have to replace talend which generally was used to move files. talend's...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers