Limit Results Based on Aggregated Threshold
Problem
A post was recently added to one of the forums that I monitor so that I can help users in...
2011-04-11
1,693 reads
Brian K. McDonald
SQL Saturday 70 SSRS Deep Dive Files Uploaded
SQL Saturday #70 (Twitter: #SQLSat70) was another successful event! And...I had yet another full house (some even left due to...
2011-03-19
423 reads
Hurry Up and Sign Up! SQL Saturday 70 is Here!
If you are anywhere within driving distance to Columbia, South Carolina, register NOW and then hop in your car Friday...
2011-03-18
432 reads
Waiting For Superman
This site really is about business intelligence, but it is good to mix things up a bit every now and...
2011-03-15
708 reads
SSRS – Creating and Using Shared Schedules Part 4
In a previous blogs, I discussed what shared schedules were and walked you through step by step instructions on how...
2011-03-09
1,154 reads
SSRS – Creating and Using Shared Schedules Part 4
In a previous blogs, I discussed what shared schedules were and walked you through step by step instructions on how...
2011-03-08
2,200 reads
SSRS – Creating and Using Shared Schedules Part 3
In my two previous blogs in this series, I discussed shared schedules and walked you through step by step instructions...
2011-03-03
955 reads
Make a Goal! Map it Out! And Go For It!
I can’t tell you that all of your dreams will come true. I won’t tell you that you will make...
2011-03-02
530 reads
SSRS – Creating and Using Shared Schedules – Part 2
In my previous post, I discussed what shared schedules were and how you could use them. With that knowledge under...
2011-03-02
1,910 reads
SSRS – Creating and Using Shared Schedules – Part 1
As you will see by the dates in my screenshots, I wrote them quite a while back while touring the...
2011-02-28
2,374 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers