Good stuff for the DBA from SQL Server Magazine...
I literally changed the topic of my blog today, (as I had my blogger open), since I had read some pretty...
2011-06-24
1,145 reads
Blog Posts
Growing Leaders
Here’s a two part story(Part 1, Part 2 from Information Week by Larry Tieman you should read. There’s a great...
2011-06-24
895 reads
Re-blog – June 17-June 23
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-06-24
566 reads
SSRS 2005 Data Driven Subscription and Temporary table
Few days back I was setting up data driven subscription for a SSRS 2005 report. The command / query which populates...
2011-06-24
1,506 reads
Export SQL Server Error Messages from Event Viewer As HTML
i use the following powershell script to retrive all sql server error logs from event viewer and export as a...
2011-06-23
1,100 reads
Google as the Ultimate SQL Repository
A discussion of how Google can serve as an invaluable resource when facing a SQL-based challenge.
Today I briefly want to...
2011-06-23
742 reads
Query Table Metadata
There will inevitably come a day when you want to take a look at the metadata of the tables inside...
2011-06-23
5,688 reads
Red Gate’s SQL Source Control and better SQL objects organization
Red Gate’s SQL Source Control (RGSSC) is very decent solution source control solution for database development. I am personally using...
2011-06-23
3,034 reads
Scripting dependencies of User-defined Table Types
I was using user-defined tables types (UDTT) quite intensively despite of their current disadvantages especially their forced READONLY behavior when...
2011-06-23
3,866 reads
Setting a Unique Index on a Bit Field
Can you set a unique index on a bit field? Well, you can, but you’d end up with a very...
2011-06-23
1,840 reads
Blogs
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...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
What is the Best Medicine for Pennis?
The optimal therapy for erectile dysfunction depends on individual health conditions, preferences, and treatment...
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