How to create first basic package with SSIS ? tip #113
Dear friends,
In last post #112 we understood WWH (What ,Why & How ) of SSIS. Now , lets move now real quick in...
2015-08-29
1,631 reads
Row-Level Security in SQL Server and Azure
Row-Level Security (RLS) is a new feature of SQL Server 2016 and Azure SQL Database that enables data access control based...
2015-08-28
3,467 reads
SQL Saturday Baton Rouge 2015 Recap
SQL Saturday Baton Rouge 2015 was our 7th annual event, but we're still learning lessons. Here's my official Planning Committee...
2015-08-28
1,206 reads
Using Power BI with HDInsight Part 2: Power BI Desktop and Hive
With the rise of HDInsight and other Hadoop based tools, it is valuable to understand how Power BI can help...
2015-08-28
1,525 reads
Master Data Services 2016 CTP 2.2 - Explorer functionality quick fix
Microsoft has recently released SQL Server 2016 CTP 2.2. I was concerned about the Master Data Services and was exploring the new features. I got surprised when I see...
2015-08-28
242 reads
Sixty Days to Summit–Are You Ready?
In just two short months – exactly sixty days from today – the SQL PASS Summit will begin. Although it’s still a...
2015-08-28
664 reads
017 – Thinking Like A Manager - Syndication – WaterOx Consulting
Thinking Like A Manager In WOxPod!, episode # 017 – “Thinking Like...
The post 017 – Thinking Like A Manager appeared first on WaterOx...
2015-08-28
912 reads
Master Data Services 2016 CTP 2.2 - Explorer functionality quick fix
Microsoft has recently released SQL Server 2016 CTP 2.2. I was concerned about the Master Data Services and was exploring...
2015-08-28
1,042 reads
The Fastest Way to Combine DATE and TIME Data Types to a DATETIME
Recently while working with a table where there were two columns, one a DATE datatype and a second TIME datatype,...
2015-09-08 (first published: 2015-08-28)
82,040 reads
I am not a “wogrammer”
So apparently the COO of Facebook is trying to make the word “wogrammer” – a woman programmer – a thing. (Thanks to...
2015-08-27
767 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