How the Resource Governor Helped Our Report Server
Trying to manage the load in a reporting server can be hard. Roy Ernest shows that Resource Governor might be a great solution that has worked in his environment.
2010-06-28
5,691 reads
Roy Ernest
Ask for something and when you get it no one uses it
There was a time when almost every Chapter leader were asking PASS to find a place where the leaders can...
2010-05-21
390 reads
My experience while writing for SQL Server Standard magazine
It all started with Grant Fritchey (Twitter @GFritchey) posting on THE THREAD asking everyone if they are interested in writing...
2010-05-07
821 reads
Powershell- Is it easy as everyone claims?
Where ever you read, people claim that power shell is so easy that even a dummy can do it. Really?...
2010-03-08
623 reads
First International speaker for our User Group
I am a nervous wreck today. Tomorrow we will have the first International speaker for our user group. Jimmy may...
2010-02-17
733 reads
Jimmy May coming to our Local Chapter meeting
This is wonderful news to our new chapter. Jimmy May has agreed to come to give a presentation at our...
2010-01-26
689 reads
My first presentation for User Group
Yesterday was the first time I gave a presentation to a group of professional who knows SQL Server. I was...
2009-12-04
794 reads
A good way to learn
I have noticed that one of the best way to learn about a certain topic is to write an article...
2009-11-25
693 reads
To Grant or Not to grant
It is said that you should not give direct table access (even select permission) to a user or group. But...
2009-11-25
525 reads
Starting up a Pass Chapter
I am on my way in setting up a Pass chapter on our tiny Caribbean island. I had no clue...
2009-06-17
600 reads
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers