First Foundation Class Review
The first Pragmatic Works Foundation class concluded today and I think it was a great success! Each student did very...
2009-04-17
825 reads
The first Pragmatic Works Foundation class concluded today and I think it was a great success! Each student did very...
2009-04-17
825 reads
This week I've been extremely busy working on the new Pragmatic Works Foundation class, which is the brainchild of Brian...
2009-04-15
689 reads
If you've noticed a significant drop in my blogging I apoligize but I've been working on an exciting project with...
2009-04-06
675 reads
There are hundreds of post on this topic but I just ran into this problem recently so I thought I...
2009-03-04
1,521 reads
If you've ever had this error "OLE DB error: OLE DB or ODBC error: Operation canceled; HY008." appear while processing...
2009-03-02
34,253 reads
Yesterday I participated in my first BI SIG live meeting. This special interest group is led by Amy Lewis who...
2009-01-15
670 reads
It seems like the benefits of being involved in PASS just never stopped. If you didn’t see the PASS newsletter...
2009-01-15
570 reads
Looks like the Windows 7 beta download has been delayed while Microsoft adds additional infrastructure support. A little disappointing but I...
2009-01-09
622 reads
Tomorrow Microsoft will make Windows 7 beta available for download. I’m a little skeptical but I think just about anyone...
2009-01-08
661 reads
CHECKSUM is a TSQL function that computes a hash value over a list of arguments. The great thing about creating...
2009-01-05
20,694 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