I arrived in Richmond, VA this morning earlier than expected. I was meeting a few people and things were pushed back, so I had the chance to go by Best Buy and find a USB->VGA adapter. Apparently they don’t have the HP VGA cable, so I got this adapter...
The Microsoft SQL Server 2008 database software provides table partitioning to make such operations more manageable.
We all try to help others with advice, but sometimes we end up doing damage. Steve Jones asks for the worst advice you see given in this Friday poll.
We all try to help others with advice, but sometimes we end up doing damage. Steve Jones asks for the worst advice you see given in this Friday poll.
We all try to help others with advice, but sometimes we end up doing damage. Steve Jones asks for the worst advice you see given in this Friday poll.
Part 2 of MVP Andy Warren's SQL School video on Instead of Triggers.
Would you disclose the password for your online sites to get a job? That was required of applicants in Bozeman, MT until recently. Steve Jones is stunned by this.
Implement a CRUD automation framework that handles insert and simple queries, an easy way to talk to a database without needing to write any database-access code.
Have you ever noticed unexpected gaps in sequences in IDENTITY columns? Even though you’ve got transactions set up for your inserts and a no-deletion policy, you find that there are missing values in what should be an unbroken sequence of numbers. The problem could be partially related to transaction rollbacks.
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