Speaking In Kansas City At #SQLSatKC
On Saturday, September 13th, I’ll be presenting my 10 Ways To Abuse T-SQL session in Kansas City. If you haven’t...
2014-08-11
288 reads
SQL Server 2005 || Database backup failed because Full Text catalog files are OFFLINE
Error : Database backup is getting fail with below reason. The backup of full-text catalog ‘FullTextCatalog’ is not permitted because it is not online. Check errorlog file for the...
2014-08-11
19 reads
Building The SQLSaturday Orlando Marketing Plan-Part 33
More notes, hopefully not repeating any from previous posts!
Karla has used the chart showing registration growth as a way to...
2014-08-11
564 reads
The Murder train chugs into Raleigh
You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...
2014-08-11
692 reads
New website
As you can see the webpage has changed!
New features are:
– Syntax highlighting on code snippets (and easy copy/paste)
– Better readability
–...
2014-08-11
514 reads
Last Weeks Top “Reading” Links #96
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-08-11
404 reads
Building The SQLSaturday Orlando Marketing Plan-Part 32
I just paused our first LinkedIn campaign, the one that was based on a functional area of IT in the...
2014-08-11
489 reads
Clustered Columnstore Indexes – part 38 (“Memory Structures”)
Continuation from the previous 37 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
In the past I have been writing quite a lot on the...
2014-08-11
188 reads
Guest Editorial Live on SSC
My guest editorial is live on SQLServerCentral.com. My argument is a simple one: we don’t care about data and IT...
2014-08-11
493 reads
SQL Server 2005 || Database backup failed because Full Text catalog files are OFFLINE
Error : Database backup is getting fail with below reason.
The backup of full-text catalog ‘FullTextCatalog’ is not permitted because it is...
2014-08-11
1,145 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