Common Mistakes in SQL Server – Part 1
In this series of articles I will be sharing the common mistakes in SQL Server. I am certain that this is going to be very interesting read, here is...
2023-09-18
477 reads
Blog Posts
Common Mistakes in SQL Server – Part 1
In this series of articles I will be sharing the common mistakes in SQL Server. I am certain that this is going to be very interesting read, here is...
2023-09-18
8 reads
State of the Database Landscape Survey 2023
As data professionals, of any stripe, we should, as much as we can, where we can, base our decisions on data. After all, in theory anyway, we’re the experts...
2023-09-18 (first published: 2023-08-23)
222 reads
The Last Price Bump for the Data Community Summit
This week the cost of the PASS Data Community Summit jumps up to full price, on Sep 21. This is your last chance to save big, so get someone...
2023-09-18
29 reads
DataMoshpit!
Today I’m presenting at DataMospit, the most metal conference in the data space! You can download the Sea of Madness bingo card from here: https://github.com/spaghettidba/CodeSamples/raw/master/SQLServerInfernals/InfernalBingo.xlsx The winner will get...
2023-09-16
69 reads
A New Word: Justing
justing – n. the habit of telling yourself that just one tweak could solve all your problems – if only you had the right haircut, if only you found...
2023-09-15
15 reads
Friday Flyway Tips: Searching Migrations
When a Flyway Desktop (FWD) project (or Flyway project) has been around for a long time, there can be a lot of migration scripts. That can be a pain...
2023-09-15 (first published: 2023-08-11)
105 reads
Friday Flyway Tips–Commit and Push
Flyway Desktop includes version control features with Git. One thing that was added in v6.5+ was the ability to commit and push. I’ve been working with Flyway Desktop for...
2023-09-15
26 reads
Persisting data for SQL Server on Docker Swarm with Portworx
In my last couple of blog posts (here and here) I talked about how to get SQL Server running in Docker Swarm. But there is one big (and show-stopping)...
2023-09-15 (first published: 2023-08-23)
211 reads
T-SQL Tuesday #166: Wrap-up
Once more, my apologies for being late on getting the T-SQL Tuesday announcement out. I have no excuse. However, our extended event on Extended Events (yes, I’m the third...
2023-09-15
21 reads
Blogs
Replacing Images in PBIR Format Reports
With the PBIR format of Power BI reports, it’s much easier to make report...
Capturing Ideas for Blogs
By Steve Jones
As we close out the year, I decided to drop this post here and...
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Forums
Page break in multi column paginated report
Hi, I have created a multicolumn paginated report, which includes a subreport that I...
create multiple output files based on query
I have this script that puts all of the output from query to a...
what if my last resort on extracting excel is at the cell level?
Hi, after i copy in ssis my excel file to a secured folder, its...
Question of the Day
What is Terraform?
What is Terraform (from Hashicorp) used for in technology?
See possible answers