User is prompted to login when viewing a report
A user has been added to a SSRS role for the report folder or report but is still
prompted to login....
2010-03-16
1,917 reads
How to parameterize a TOP values query
There are certain key words in a T-SQL query than cannot be parameterized, including
the TOP statement. Consider the followong attempt...
2010-03-16
812 reads
Enabling Filestreaming in SQL Server 2008
This is a short post on enabling file streaming. I have read a few sources that cover the same topic...
2010-03-16
755 reads
SQL Saturday #33 Recap
SQL Saturday #33 was held on Saturday, 3/6, at the Microsoft campus in Charlotte. Hosted by the Charlotte SQL Server...
2010-03-16
1,063 reads
SQL Server 2008 SP1 CU7 is Released
Microsoft has released SQL Server 2008 SP1 Cumulative Update 7 (CU7). It is Build 2766. There are 31 fixes listed,...
2010-03-16
1,531 reads
PASS Update #26 (Bylaws & Upcoming Board Meeting)
Most months we do a conference call, but a couple times a year we get to meet in person and...
2010-03-16
605 reads
SQL Saturday is a’comin!
Just a quick reminder that registration is still open for SQL Saturday #35 in Dallas. This event will be held...
2010-03-16
560 reads
A Wiki Wiki
I was killing a few minutes browsing while waiting on a call, had been thinking again whether a wiki would...
2010-03-16
704 reads
Tracking data about your instances
I saw a post recently asking how to build a daily report for each instance that tracks the metrics deemed...
2010-03-16
729 reads
How to Enroll a Managed Instance into SQL Server Utility in SQL Server 2008 R2
After creating a Utility Control Point (UCP) you will want to enroll some managed instances (up to 25 with SQL...
2010-03-16
1,312 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers