Columnstore Indexes – part 76 (“Compression Delay”)
Continuation from the previous 75 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
While playing with SQL Server 2016 CTP...
2016-02-04
797 reads
Recertifying SQL Server 2012 MCSE with Microsoft Virtual Academy
Do people still get certified? I don’t hear much about it in the SQL community these days so I asked...
2016-02-04
506 reads
Loading a Text File with a Line Feed
Loading text files is a skill that probably every DBA needs. I know that the import wizard is available, but...
2016-02-04
1,229 reads
SQL Server Reporting Services 2016 – Part 1
This first post of 3 takes a quick peek at SSRS 2016 using the Community Technical Preview (CTP) 3.2. I...
2016-02-03
1,346 reads
Scaling Azure SQL Database
One of the advantages Azure SQL Database has over on-prem SQL Server is the ease in which it can scale. I’ll...
2016-02-03
805 reads
Blogger questions: What if someone else wrote about the same subject?
I have a moderately popular blog. In part because I syndicate but largely (in my opinion) because I write a...
2016-02-03
568 reads
The Future of SSMS
One of the smaller announcements amidst the gazillion new features of SQL Server 2016, is that SSMS is now a...
2016-02-03
630 reads
Limitation of In-Memory OLTP in SQL Server 2016 – TRUNCATE table not supported
Hi friends, another limitation that we will discussed is TRUNCATE table command is not supported with memory optimized tables. Let’s...
2016-02-03
1,395 reads
Should I use option(recompile)?
Should I use option(recompile)?
This will probably be a multiple stage discussion. The notes I’m providing today were sparked off of...
2016-02-02
6,968 reads
How to Install Microsoft R Server for Windows
Microsoft R Server, or Revolution R Enterprise (RRE) as it is formally known, for now, is basically a platform for...
2016-02-11 (first published: 2016-02-02)
3,041 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...
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