Blacklist a Set of IPs - WaterOx Consulting
Reading Time: 3 minutesWe talked about whitelisting IPs before, but what about the opposite, blacklisting...
The post Blacklist a Set of...
2015-06-03
445 reads
Notes From The May 2015 oPASS Meeting
Really late posting these, forgot to put on my task list!
About 20 attendeesLots of good questions, and I saw quite...
2015-06-03
391 reads
Clean up all (most) of the orphans on an instance
Recently we have been doing a number of instance moves as part of a large upgrade project. And as anyone...
2015-06-03
1,683 reads
The Key to Successful Analysis
The key to successful analysis is to ask enough good questions.
How do you know that you’ve asked enough questions? When...
2015-06-12 (first published: 2015-06-03)
2,112 reads
SQL Server 2016 features to look for -1
At this year’s inaugural Ignite Conference in held in Chicago Microsoft announced that the next release of SQL Server, previously...
2015-06-03
1,154 reads
HealthySQL - A Comprehensive Guide to Healthy SQL Server Performance Now Available - 10% off
Announcing my new book available in hard copy and eBook, HealthySQL -
A Comprehensive Guide to Healthy SQL Server Performance, by...
2015-06-08 (first published: 2015-06-03)
3,468 reads
The #1 Enemy of Data Loading in SQL Server
Let’s look at the following script:
CREATE TABLE LoadMeFast (Id INT NOT NULL,
InsertDate DATETIME NOT NULL,
ABunchOfLetters NVARCHAR(100)
)
GO
SET NOCOUNT ON
GO
DECLARE...
2015-06-09 (first published: 2015-06-03)
4,060 reads
Im Attending SQLSaturday #379 in South Florida on June 13, 2015
It’s almost summer and that means it’s time for a trip to South Florida for SQLSaturday #379. I’ll be doing my...
2015-06-02
349 reads
Minion Backup intro webinar June 3!
Minion Backup 1.0 is up and available for download as of now! Minion Backup by MidnightDBA is a stand-alone database backup module. ...
2015-06-02
1,028 reads
Why is SSDT so slow?
I see the same question again and again “I am using SSDT but it takes a long time to publish...
2015-06-02
38 reads
Blogs
Ten Years of PowerShell
Ten years ago, I published a post about filming a Pluralsight Play by Play...
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...
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