Transactional Replication Conversations –Must read
Everyone who wants to know about how transaction replication works and how to improve the performance of transaction replication must...
2009-12-03
2,148 reads
Everyone who wants to know about how transaction replication works and how to improve the performance of transaction replication must...
2009-12-03
2,148 reads
The conversation on local administrators having rights in SQL Server has proven to be interesting and at times entertaining. My...
2009-12-03
2,532 reads
I’ve fallen behind a little on sharing SQLSaturday news, so I’ll try to catch up on the latest. First, we’re...
2009-12-02
486 reads
SQL Server Standard editor Grant Fritchey needs more content! We’ve got about three done and three more in the pipeline,...
2009-12-02
952 reads
If you missed this, here’s your chance to make it up. If you were there, and like me, you need...
2009-12-02
714 reads
I found a nice post from a friend, Roy Ernest, on an effective way to learn. He notes that one...
2009-12-02
673 reads
I met Tim about a year and a half ago at SQLSaturday Jacksonville and from the start we hit it...
2009-12-02
271 reads
12/03/2009 - UPDATE! There were a couple of bugs in the SQLIOCommandGenerator new SQLIOTools.zip has been updated.
------------------------------------
I often tell people one...
2009-12-02
1,577 reads
Those were the first words out of my wife’s mouth when I told her my laptop had died. She walked...
2009-12-02
843 reads
To use remoting you'll need to install Powershell V2, unless you're running Windows 2008 R2 or Windows 7, you'll need...
2009-12-02
1,199 reads
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
hi i was hoping for a more elegant way of setting a pkg level...
I have a plan which in sys.query_store_plan shows: Last_compile_start_time of 2026-04-23 00:13:00.7670000 +00:00 Last_execution_time...
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams n;See possible answers