Overview of Published Articles – 2014Q3
Here is an overview of the articles I published in the third quarter of 2014.
INTENSE SCHOOL
MCSE Prep (SQL) – Using Parameters...
2014-10-24
785 reads
Here is an overview of the articles I published in the third quarter of 2014.
INTENSE SCHOOL
MCSE Prep (SQL) – Using Parameters...
2014-10-24
785 reads
Some time ago I was writing some windowing functions on a set of data. Basically I was looking for the...
2014-10-15 (first published: 2014-10-07)
6,644 reads
This month’s T-SQL Tuesday is hosted by Tracy McKibben (blog | twitter) and is all about heroes (not the TV show).
Ada...
2014-10-14
1,193 reads
SQL Server Days 2014 is over, but it has been one great event. A very big thanks to the organizers!...
2014-10-06
512 reads
Lately I have been using more and more the awesomeness of the Alt-button in SQL Server Management Studio (SSMS). What...
2014-09-23
850 reads
After quite a while it has finally returned: another Stupid Me™®©! A reminder:
Every time I do something “stupid”, which happens...
2014-08-27 (first published: 2014-08-21)
7,376 reads
After my review of Tableau Dashboard Cookbook, I read another book about Tableau, namely Tableau Data Visualization Cookbook by Ashutosh...
2014-08-08
1,084 reads
A few months ago I followed an introductory course about the data vault modeling technique for data warehouses at a...
2014-07-17
1,756 reads
With “Matrix Infographic” I simply mean those infographics FiveThirtyEight (site | Twitter), the website of statistic revelation Nate Silver, uses to...
2014-07-11
1,075 reads
Here is an overview of the articles I published in the second quarter of 2014.
Intense School
MCSE Prep: The Integration Services...
2014-07-09
571 reads
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Comments posted to this topic are about the item Building a SQL Server Fleet...
Comments posted to this topic are about the item Smart AI Agents and Data...
Comments posted to this topic are about the item 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