Low Hanging Fruit
An open letter asks Google to change their default protocol to be more secure. Are there things that we might want to do inside SQL Server to make it more secure by default? Any low hanging fruit that would help the platform?
Low Hanging Fruit
An open letter asks Google to change their default protocol to be more secure. Are there things that we might want to do inside SQL Server to make it more secure by default? Any low hanging fruit that would help the platform?
The Query Optimizer: Date Correlation Optimisation
In SQL Server 2005, a feature was introduced that was hardly noticed, but which might make a great difference to anyone doing queries involving temporal data. For anyone doing Data Warehousing, timetabling, or time-based pricing, this could speed up your queries considerably. Who better to introduce this than Query Optimizer expert, Fabiano Amorim?
Troubleshooting Reporting Services
Marcin Policht continues his discussion of implementing Reporting Services on SQL Server 2005 Express Edition. In this article, we will turn our attention to troubleshooting methods that can be employed to identify and resolve problems affecting reporting functionality and performance.
The Value of Experience
What type of previous experience makes a good DBA? Is it necessary to have other experience? Steve Jones asks the question in today's Friday poll.
Understanding INNER join in detail
This objective of the article is to give readers in depth understanding of INNER JOIN with different joining conditions.
Cube Storage: Introduction to Partitions
Join BI Architect Bill Pearson in this introduction to Partitions in Analysis Services 2008. Here we explore partitioning concepts and advantages, and look forward to hands-on practice with partitions in subsequent articles.
SharePoint 2010 And SQL Server 2008 R2
Lots of interesting news and announcements coming out of the SharePoint 2009 Conference that started today in Las Vegas. Microsoft’s...
SQL Server Monitoring Scripts with the DMVs
If you do not have a third party monitoring tool in place, the only way is to constantly monitor SQL Server. To do this without being overly intrusive, we need to rely on the SQL Server DMVs.
The Value of Experience
What type of previous experience makes a good DBA? Is it necessary to have other experience? Steve Jones asks the question in today's Friday poll.
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Half of All Engineers
Comments posted to this topic are about the item Half of All Engineers
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers