AdventureWorksCI Step 1 planning
This is part of a series on how to take the Adventureworks database and bring it inline with modern standards....
2015-06-12
46 reads
AdventureWorksCI Step 1 planning
This is part of a series on how to take the Adventureworks database and bring it inline with modern standards. How do we put a legacy SQL Server database...
2015-06-12
7 reads
Error Upon First Processing Your SSAS Database With A Service Account
This blog post is to document the easy fix to a problem that has become a rite of passage for...
2015-06-11
2,502 reads
10 Things a Database Design Company Should Do
Database design is a complex industry involving many technologies, software and specialists. The term “design” is a little bit misleading...
2015-06-11
460 reads
Using the DAC with SSMS
I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few...
2015-06-11
888 reads
SQL SERVER REPORTING SERVICE MIGRATION
Last week as part of job I had to migrate the Databases and Reporting Service of SQL server 2005 To...
2015-06-22 (first published: 2015-06-11)
3,226 reads
Modifying the “New Query” template.
TLDR; Search for and modify the sqlfile.sql file.
During a recent T-SQL Tuesday Boris Hristov (b/t) taught me about SET NOEXEC...
2015-06-23 (first published: 2015-06-11)
3,115 reads
SQLSaturday#379 South Florida - Coming up this weekend!
June 13, 2015 - SQLSat379: Just wanted to make mention of the upcoming SQLSaturday#379 down in South Florida, it will be...
2015-06-11
1,014 reads
Drop down boxes not working in SQL Server 2012 Configuration Manager
After a data centre power outage a decision was made to switch the start up mode of a bunch of...
2015-06-19 (first published: 2015-06-11)
1,881 reads
Continuing Series: System Center for the SQL Server DBA (SCOM Data Warehouse)
Originally posted on Blog Home for MSSQLDUDE:
Not really a new part to my multi-part series on System Center for...
2015-06-11
523 reads
Blogs
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers