Office Work
I have been working at home for over 8 years, sharing an office with my wife for most of that...
2011-07-14
1,719 reads
I have been working at home for over 8 years, sharing an office with my wife for most of that...
2011-07-14
1,719 reads
I’m late posting it, but I was featured on SQLPeople for June 27th. It’s a project Andy Leonard has going...
2011-07-14
521 reads
I am easily distracted. Lucky for all of us, I tend to be distracted by cool tidbits in SQL Server...
2011-07-14
961 reads
We have set up subscription for customer which used to send mails to the customers periodically. Recently one of the...
2011-07-14
3,743 reads
Why am I attending Kevin Kline’s pre-con on “Troubleshooting & Performance Tuning Microsoft SQL Server 2008 R2” at SQL Saturday #89...
2011-07-14
605 reads
Microsoft has released the final build of SQL Server 2008 R2 SP1. It includes fixes from SQL Server 2008 R2 RTM Cumulative Updates 1 through...
2011-07-14
1,346 reads
One of the most annoying processes with SharePoint is backing up a site collection. There is a build in tool...
2011-07-13
1,789 reads
This is a series of blog posts about how administrators can gain access to SQL Server, even if you try...
2011-07-13
1,869 reads
Are you considering making a change to your view or stored procedure? Or possibly you are considering moving your database...
2011-07-13
2,671 reads
A quick plug for my friend Blain Barton from Microsoft, he’s got a series of three broadcasts that are video,...
2011-07-13
734 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