Happy Thanksgiving 2009
Happy Thanksgiving to everyone in the US. The editorial today has a blooper reel from the podcasts in celebration of the holiday.
Building a Yahoo Finance input adapter for SQL Server StreamInsight
Step by step guide to building and debugging a SQL Server StreamInsight input adapter.
Networking One Tweet at a Time
Maintaining a professional network can take some effort from you, but the modern social networking tools can help. Steve Jones talks about some of the benefits from keeping in touch with other professionals this way.
Change the Report Manager logo
A common question I've been asked a lot lately is how to replace the icon in the Report Manager to...
Controlling Execution Plans with Hints
The Query Optimizer gets it right most of the time, but occasionally it chooses a plan that isn't the best possible. You can give the Query Optimiser a better idea by using Table, Join and Query hints. These come with a risk: Any choices you force on the Optimizer by using hints can turn out to be entirely wrong as the database changes with the addition of data over time. Grant Fritchey, in a chapter from his highly acclaimed book, explains further.
Networking One Tweet at a Time
Maintaining a professional network can take some effort from you, but the modern social networking tools can help. Steve Jones talks about some of the benefits from keeping in touch with other professionals this way.
Networking One Tweet at a Time
Maintaining a professional network can take some effort from you, but the modern social networking tools can help. Steve Jones talks about some of the benefits from keeping in touch with other professionals this way.
Networking One Tweet at a Time
Maintaining a professional network can take some effort from you, but the modern social networking tools can help. Steve Jones talks about some of the benefits from keeping in touch with other professionals this way.
Should DBAs have local administrator rights?
This was actually spurred by a post from Ted Krueger (@onpnt), which led to a short, but hearty, discussion on...
Using the SQL Server Analysis Services (SSAS) Deployment Wizard
I have to deploy my SQL Server Analysis Services project to a test server then to a production server after testing is completed. For both of these deployments I need to provide an installation program. I am not allowed to access either of these servers. For my own testing I can deploy my project using Business Intelligence Development Studio (BIDS) and this works great. How can I create an installer that my IT team can use to perform the deployment?
Blogs
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
PowerShell Newbie – Variables
By gbargsley
This is Week 2 of PowerShell Strikes Back – a four-week May series for...
Forums
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
The Distance Metric
Comments posted to this topic are about the item The Distance Metric
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers