Security issues when using aliased users in SQL Server
This tip shows you how to find security holes when aliased users are setup in your databases and also that this feature will be deprecated in SQL Server 2008.
SQL Server CLR function to concatenate values in a column
If a column is normalized, but the user really wants to see the values as a short comma separated list, how can I write a query that produces the list? Concatenating the values in a column would be pretty easy if SQL Server had a concatenate aggregate function, which it doesn't. What's more, for efficiency sake it's important to write the reporting queries without using cursors.
Trust
Trust is a big part of any DBA's job. But it seems that many people in society trust each other less and less all the time. Steve Jones has a few comments on this important subject.
Trust
Trust is a big part of any DBA's job. But it seems that many people in society trust each other less and less all the time. Steve Jones has a few comments on this important subject.
Trust
Trust is a big part of any DBA's job. But it seems that many people in society trust each other less and less all the time. Steve Jones has a few comments on this important subject.
Guest Editorial: In Praise of Templates
Phil takes us through one of the best kept secrets of SSMS - Templates. Even for a 'plain-screen' man like Phil, Templates are an excellent tool, and a major reason to use SSMS.
How To Retrieve Excel Schema Information Using SQL Server Integration Services (SSIS) 2005
How can we determine the sheet names in our SSIS package and process this variable number of sheets?
New data profiling tools in SQL Server 2008
New data-profiling tools native to SQL Server 2008 Integration Services such as the Data Profiling task and the Data Profiler Viewer help manage a business intelligence strategy.
Who Do We Choose to Follow?
Think about your career and the managers, and potentially leaders, that you’ve had in your life. Think about life in general and who do you admire, who have you modeled yourself after or who you wanted to follow in sports, in a hobby, in life, etc.
Guest Editorial: Do DBAs Need a Code of Ethics?
Despite the fact DBAs are essentially protectors of an organization’s knowledge, and privy to much confidential information, there is no clearly defined set of rules and standards to help govern and guide their ethical behavior. Brad McGehee thinks it's time for some action on this issue.
Blogs
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...
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Claude.ai vs Claude API
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
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