Downloading SFTP Files with SSIS
If you’ve used SSIS for any significant amount of time, you’ve almost certainly run into this roadblock: You need to...
2015-08-03
7,839 reads
Single instance vs. multiple instances of SQL Server on a server
Let`s consider a situation when you need to build a server with SQL Server used by multiple client applications. Here...
2015-08-03
16,722 reads
Question of the Month (July)
Suppose we have a table emp_plan which contains 4 columns "Empid" (employeeid), Planid (Projectid), Startdate(Allocation Start date) and Enddate (Allocation Enddate). Its structure is given below:-
Create table emp_plan (empid nvarchar(200),planid...
2015-08-03
11 reads
Question of the Month (July)
Suppose we have a table emp_plan which contains 4 columns "Empid" (employeeid), Planid (Projectid), Startdate(Allocation Start date) and Enddate (Allocation Enddate)....
2015-08-03
679 reads
Consolidating Multiple Data Marts
One of the challenges that I've worked on in the past months involved adapting our technical architecture to address issues exposed by business re-engineering. ...
2015-08-03
644 reads
#PowerBI Tip: Use the Treemap, Column or Funnel Chart as a Colorful Slicer
Power BI Desktop has been out for GA for over a week now and some of the pro’s out there...
2015-08-03
1,620 reads
Windows 10 Upgrade on Surface Pro 3 – Sending email issue FIXED
I very rarely blogabout anything other than SQL Server but felt that with a lot of the SQL Community using...
2015-08-02
935 reads
SQL Server GEEKS Annual summit 2015
Last month, I have requested my manager for an approval so that I can attend SQL Server Geeks Annual Summit...
2015-08-02
689 reads
Monday Morning SQL Break – July 27, 2015
It’s past time for the Monday blog and twitter round-up for last week, but better late than never (or not)....
2015-08-02
640 reads
Beginning T-SQL slide deck and recording – #SQLSatBR
I had a great time in my Beginning T-SQL presentation here at SQL Saturday Baton rouge! Here is the BeginningTSQL...
2015-08-01
773 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