Arshad Ali discusses the details of creating reports with indicators and gauges in SQL Server 2008 and walks you through designing a one tablix report with two levels of grouping.
Self service in IT is something Steve Jones likes, but it doesn't solve all problems, and might end up creating more issues.
Shawn McGehee discusses partial backups, how they're used, and how to avoid potential problems when restoring from a partial backup.
On Thursday May 17th 12PM noon Central, Mike Fal will discuss "SQL Server's table partitioning gives the DBA tools to manage this beast and support very large tables in a way where index management and data retrieval..."
Building a Stock Price Correlation Matrix Using TVPs, a CROSS JOIN and the PIVOT Function
Phil Factor welcomes SQL Server support by Amazon RDS, as an alternative to having Microsoft as service provider as well as software provider, via the PaaS formerly known as Azure.
Software engineering is seen as a dead end career choice, at least by some people. Steve Jones disagrees.
Snapshot isolation levels improve performance but there are some things to take into consideration when using this feature. Arshad Ali discusses what snapshot isolation levels are, their variants, and why and when we should use them.
A guide to the SQL Server 2008 Business Intelligence exams.
This week Steve Jones wants to know if you can find time for your professional development. Regularly improving your skills is an important part of your career in technology, and the poll this weeks asks what time you can make for improvement.
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Comments posted to this topic are about the item Let's Talk Community Events!
Hi as shown below a replication target requires a primary key. if we want...
Comments posted to this topic are about the item Local Agents
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers