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
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...
2015-09-14
533 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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...
Split Large Queries in Athena with a Simple Modulo Trick
Comments posted to this topic are about the item Split Large Queries in Athena...
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