Visual Studio 2017 Irritants From the SSIS Developer View
I was among the many Integration Services (SSIS)/Database (DB) developers out there that cheered when Microsoft finally announced support for...
2017-10-05
799 reads
I was among the many Integration Services (SSIS)/Database (DB) developers out there that cheered when Microsoft finally announced support for...
2017-10-05
799 reads
I am so happy to announce (and honored to be selected) that I will be speaking at SQL Saturday Spartanburg...
2017-08-30
484 reads
I am so excited to be helping out with SQL Saturday Charlotte again this year. This is the 6th year...
2017-08-22
395 reads
Wow, I can hardly contain my excitement. I was selected to speak at SQL Saturday Denver on September 16, 2017. I’ll...
2017-07-28
313 reads
I was recently given the nod to upgrade my monitoring server from SQL Server 2012 (SP 3) to SQL Server...
2017-07-11 (first published: 2017-06-30)
2,217 reads
Microsoft announced a new program last year to help you understand the skills that a Data Scientist needs in their...
2017-06-21
465 reads
Recently I had to copy data from our AS400 to a SQL Server database. Normally I would whip up my...
2017-06-07
3,600 reads
I am so excited and honored to have been selected to speak at SQL Saturday Atlanta (#652) this year. This...
2017-05-25
323 reads
Recently, I was tasked with “enhancing” a third party application. This third party application (TPA) outputs a bunch of files...
2017-03-30 (first published: 2017-03-16)
2,258 reads
On Saturday, March 18, 2017, I spoke at my very first SQL Saturday. I have been an attendee, involved in...
2017-03-22
331 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers