Project Management Management
The state of project management for technology projects doesn't seem to be keeping up with technology itself. Steve Jones talks a little about what might be wrong.
Project Management Management
The state of project management for technology projects doesn't seem to be keeping up with technology itself. Steve Jones talks a little about what might be wrong.
SQL Server database design disasters: What not to do
Inspired by what he recently found in some SQL Server shops, database architect Brian Walker shares advice for improved database design – and SQL Server performance.
A Better Database Engine
How much different can a database engine make to a platform? MySpace was recently mentioned along with database technology from Sun Microsystems that might make them more profitable.
Parameterizing SSRS Reports - SQL School Video
MVP Brian Knight continues with Reporting Services in this SQL School video that shows you how you can add parameters to your Reporting Services report to customize them.
The South African SQL Server Usergroup is Back
MVP Gail Shaw has restarted the South African Usergroup. Read on if you are interested in participating.
Disabling a Trigger for a Specific SQL Statement or Session
I want to suppress the trigger from firing for a particular statement while it remains in its normal execution state for any of the other statements. Is there any way this can be done dynamically?
Take the Plunge
Today Steve Jones talks about starting your own business and should you do it with online tools.
Take the Plunge
Today Steve Jones talks about starting your own business and should you do it with online tools.
Take the Plunge
Today Steve Jones talks about starting your own business and should you do it with online tools.
Blogs
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Data Engineering Books Worth Having on Your Shelf (or your tablet)
Good documentation gets you started. Good books get you deep. After years of working...
Forums
SQL Server Showing Out of Space But Plenty of Drive Space
We have a SQL Server installed. We have a 500GB drive for the database....
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
Question of the Day
Creating a JSON Document IV
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 YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers