House Price Predictions @ PASS 2015
The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in October – and I felt pretty damn honored to be one of the 160 or...
2015-09-07
1 reads
The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in October – and I felt pretty damn honored to be one of the 160 or...
2015-09-07
1 reads
Announcing two new UK-based SQL Sentry global technology evangelists. Please help me welcome John Martin and Richard Douglas.
The post SQL Sentry Grows in the UK and Beyond appeared first...
2015-08-07
4 reads
Originally appearing at ForITPros.com. Joe Webb’s father-in-law spent most of his adult life as a cardiologist. That’s a highly specialized and highly technical area in the field of medicine that...
2015-08-06
3 reads
Originally appearing in my monthly column at Database Trends & Applications magazine. When it comes to cloud-based database management, there are really only two players: Amazon, the value leader,...
2015-08-05
7 reads
Originally appearing at ForITPros.com. In 1957, the Soviet-made Sputnik streaked across the sky in low earth orbit. It was clearly visible to millions of concerned Americans. The Soviet government...
2015-07-30
5 reads
Originally appearing in my monthly column at Database Trends & Applications magazine. In the first of this three-part series, I described some of the findings contained in an intriguing...
2015-07-29
13 reads
2015-07-24
Originally appearing at ForITPros.com. Henry Ford is reported to have once said, “Whether you think you can or think you can’t – you’re right.” That’s great insight. Too often...
2015-07-23
3 reads
Originally appearing in my monthly column at Database Trends & Applications magazine. In my last column, available HERE, I described some of the findings contained in an intriguing new...
2015-07-22
5 reads
[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 5. The partitioning includes several major components of work (and can be linked...
2015-07-06
2 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