Looking Back at SQLRally Orlando
It’s been almost two weeks since we wrapped up our first SQLRally, and in some ways it hasn’t quite sunk...
2011-05-25
646 reads
It’s been almost two weeks since we wrapped up our first SQLRally, and in some ways it hasn’t quite sunk...
2011-05-25
646 reads
Over time it's easy to lose track of the things you set up to get work done. As a consultant,...
2011-05-25
1,170 reads
New Whitepaper: Performance Evaluation of Hosting TempDB on FusionIO
A colleague I work with on the PQO* Operations SQL V-Team, Jonathan...
2011-05-25
1,505 reads
SQLServerCentral.com, along with Red Gate Software, are glad to announce that nominations for the fourth annual Exceptional DBA Awards are...
2011-05-25
1,424 reads
Did you ever accidentally close SQL Server Management Studio? And, in closing SSMS, did you get the prompt that says...
2011-05-25
908 reads
One thing that is enjoyable about my position is working with people who have no idea what SQL is besides...
2011-05-25
1,157 reads
I bloog about mysql to sql server migration lastly here Today found very good migration tool Free Downloads: 1. SSMA...
2011-05-25
647 reads
SQL Treeo is free add-in to SQL Server Management Studio (SSMS) which enables user to create own folder structures within...
2011-05-25
945 reads
The indicators that are available in SQL 2008R2 adds great visualizations to your reports. I was recently building an SSRS...
2011-05-25
28,478 reads
Once again we’re running a contest to find the Exceptional DBA around the globe. I’ve been a judge the last...
2011-05-25
912 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