Each session should be able to have its own temp table, but there can be problems.
You should be able to create a #temp in every session. That’s the idea, right? It’s one of the things...
2018-05-10
999 reads
Blog Posts
Finding Tabs in SSMS–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-05-10
473 reads
How To Audit Data Changes In SQL Server?
Scenario:
I was at a new client, with their previous and only DBA / DEVELOPER/ MASTER OF ALL of 8 years all...
2018-05-10
10,486 reads
How to deploy data for the lookup tables, small dimensions and other meta-data with your database code
Deployment process equally responsible for deploying both database objects as well as an initial state of the database/applications. In this...
2018-05-10
642 reads
PASS Summit 2018 Pre-con: Digital Storytelling with Power BI
Mitchell Pearson, Brian Knight and myself will be presenting a full day pre-con as PASS Summit on Digital Storytelling with...
2018-05-10
746 reads
PASS Summit Session – On-Prem SQL Servers, Interstellar Performance
I’m very pleased to announce that one of my sessions submitted for this year’s PASS Summit in Seattle, held from...
2018-05-10
266 reads
Reviewing the SQL Server ERROR log
The SQL Server ERROR log is the best source to understand what’s wrong with your SQL Server instance, think this...
2018-05-10
134 reads
SQL Server Partition Swapping
When working with large amounts of data in ETL jobs it can often can sink a lot of time inserting...
2018-05-10
844 reads
Using CAST() function with User-Defined Data Types…Did you know…
I’m converting some Firebird database code to T-SQL and I’m seeing a lot of code that doesn’t work in the...
2018-05-10 (first published: 2018-05-02)
2,915 reads
A big thank you
Thank you! Thank you for reading my blog. Thank you for buying my book. Thank you for attending my sessions...
2018-05-09
258 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers