Encrypting Connections To SQL Server Using Certificates
Encrypting Connections To SQL Server Using Certificates
In this post we’re going to cover configuring a connection string in .NET applications...
2015-09-22
7,282 reads
Populating My DBA Database for Power Bi with PowerShell – Databases
Following my post about using Power Bi with my DBA Database I have been asked if I would share the...
2015-09-22
870 reads
SQL Server 2014: ONLINE operation on a single partition of partitioned object
Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful operation – ONLINE rebuilding some partitions of partitioned objects...
2015-09-22
52 reads
SQL Server 2014: ONLINE operation on a single partition of partitioned object
Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful operation – ONLINE rebuilding some partitions of partitioned objects...
2015-09-22
41 reads
SQL Server 2014: ONLINE operation on a single partition of partitioned object
Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful...
2015-09-22
1,038 reads
DR drill - Part 2: Log Shipping
Welcome back to DR drill series!
In the last post (here), we have highlighted a number of ways to setup disaster...
2015-09-22
1,503 reads
Columnstore Indexes – part 67 (“Clustered Columstore Isolation Levels & Transactional Locking”)
Continuation from the previous 66 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Continuing from the last couple of blog...
2015-09-22
622 reads
No thrills about spills
Statistics, in simplest terms, refer to the distribution of data in a column or index. They are represented in a...
2015-09-21
786 reads
Simple Merges KDiff3 at SQL in the City
One of the hassles of working in a development team is that you will have conflicts between your code and...
2015-09-21
1,057 reads
XML Attribute VS Element Assignment when working with SQL
XML handling with aliases
I find it interesting the difference in behavior with querying XML between column assignment, and quoted alias...
2015-09-21
318 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