Watch the Power Pivot 101 Webinar Recording
Thank you to everyone that attended my webinar titled Power Pivot 101: An Introduction! Also, thank you to Thomas Leblanc...
2015-09-14
645 reads
How Many Objects Can Own Pages in a Mixed Extent
I saw an exchange on Twitter this past weekend on the #sqlhelp hash tag about how pages are allocated for...
2015-09-14
666 reads
How to Create Scatter Chart in Power BI
There’s a saying that birds of the same feather flock together. When you throw your data on a scatter chart,...
2015-09-25 (first published: 2015-09-14)
3,118 reads
Define SQL Server database permissions for development team
The dba routine includes developer’s accounts management. Such as creating sql logins for new developers. There is usually a standard permissions list and database environment for code writing and...
2015-09-14
17 reads
Define SQL Server database permissions for development team
The dba routine includes developer’s accounts management. Such as creating sql logins for new developers. There is usually a standard permissions list and database environment for code writing and...
2015-09-14
24 reads
Define SQL Server database permissions for development team
The dba routine includes developer’s accounts management. Such as creating sql logins for new developers. There is usually a standard...
2015-09-14
3,334 reads
Split personality text editing in SSMS with Sublime Text 3
Split personality text editing in SSMS with Sublime Text 3
My preview post showed a demonstration of the multi-cursor editing power...
2015-09-14
1,106 reads
PASS Nominations Committee 2015
The Nominations Committee has done their job and the final report has been published.
Good luck to everyone running. Thank you...
2015-09-14
475 reads
Webinar: Change Tracking for Data Warehouse Loads
For data warehouse professionals, change detection is critical. Accurately detecting new, changed, and deleted records means the difference between doing...
2015-09-14
529 reads
Extended Events and Fixed Schemas
Working with databases, XML, and many software applications, it is not uncommon to deal with fixed schemas. In the database world, it is fairly fundamental to have some sort...
2015-09-14
27 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
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