What Will I See at SQL Connections?
The SQL Connections conference will be held this November in Las Vegas and Steve Jones is attending. See what he's interested in viewing at the event.
Accommodating Null Values in SQL Server
The key to working with null values properly is to accommodate them consistently. Learn a few tricks that will help you do just that.
Migrating SQL Server Databases - The DBA's Checklist (Part 1)
Migrating a database is often a task fraught with complications, this series examines the key issues in a simple checklist.
Star Join Optimization in SQL Server 2008
When working with a dimensionally modeled data warehouse it is common for a large number of your queries to follow...
What Will I See at SQL Connections?
The SQL Connections conference will be held this November in Las Vegas and Steve Jones is attending. See what he's interested in viewing at the event.
What Will I See at SQL Connections?
The SQL Connections conference will be held this November in Las Vegas and Steve Jones is attending. See what he's interested in viewing at the event.
What Will I See at SQL Connections?
The SQL Connections conference will be held this November in Las Vegas and Steve Jones is attending. See what he's interested in viewing at the event.
What's Your Education Worth?
Most of us learn on the job, but is that the best way? If you could learn faster at a cost, would you pay it? Steve Jones talks a little bit about what he has done and what he would do today in today's editorial. What is a SQL Server education worth to you?
Introduction to Dimension Security in SQL Server Analysis Services SSAS 2005
I have seen the tip Dynamically Control Data Filtering in SQL Server Reporting Services Reports which showed how to leverage a SQL Server database table to filter sales data based on the user running the report. I have a similar requirement to implement dynamic filtering except my data is in a SQL Server Analysis Services (SSAS) cube and the users query the data with a variety of different tools. How can I implement dynamic security in my case?
Issue with SQL Server 2K5 SP3 CU5
In case you are considering to apply SQL Server SP3 CU5 (http://support.microsoft.com/kb/972511) to your system, I'd like to point out one issue / bug we found with CU5.
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
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
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...
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