SQL Server “Denali”
SQL Server “Denali” is the code name for the next version of SQL Server. The CTP1 of Denali was released...
2011-06-23
3,075 reads
James Serra's Blog
Three must-have tools you should use everyday
There are three tools I use every day without exception. They all save me valuable time in surfing the net:
Delicious...
2011-06-22
1,276 reads
Miss TechEd 2011? No problem, all videos are online
While nothing beats going to a conference, the next best thing is to watch the recorded sessions. Fortunately, Microsoft has...
2011-06-20
809 reads
SSMS Add-in for Analysis Services
A nice new little add-in available for SSMS on Codeplex. It helps with repetitive tasks involved with SSAS such as processing and deployment. ...
2011-06-17
1,058 reads
Data Mining and Analytics hot career
Researchers at the University of California, San Diego have published a list of job-market hotspots, and in the top ten is...
2011-06-16
815 reads
New Microsoft SSIS transform
Microsoft has just released a new SSIS transform, called the SSIS Balanced Data Distributor (BDD). You can download it here.
This...
2011-06-15
1,346 reads
What’s coming in SP1 for PerformancePoint
Check out What’s New in PerformancePoint Services and SP1? to see a list of the major features and updates included in...
2011-06-14
675 reads
SSIS Fuzzy Lookup Error
A Fuzzy Lookup Task in SSIS that I was working on was bombing out, and I had a heck of...
2011-06-13
1,656 reads
Easier way to view SQL Server job history
Ever get a timeout error when using the “View History” for a SQL Server Agent job? I find this happens...
2011-06-10
4,303 reads
BIDSHelper 1.5 for SSAS, SSIS, SSRS released
BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server...
2011-06-09
756 reads
Blogs
Truncating very large transaction log in full recovery mode
By SQLPals
While I always configure transaction log backups for every database in non-simple recovery model,...
Autonomous Driving Around London
By Steve Jones
There’s a video of Bill Gates taking a drive in an autonomous car around...
Best way to monitor high worker thread on SQL Server
It is common to see high worker count issue on the production server and...
Forums
Remove the Dynamic code from my SQL sproc
I have a stored procedure that was created to run dynamically. Other than me...
Significance of Historical waits report in SQL server Performance dashboard
I have the following historical wait report for my SQL server. I have noticed...
Ask SSC