This Can't Happen
A bug reported on Connect has Steve Jones worried. This one could be a big deal in some situations that are concerned about comprehensive auditing.
The Com.PASS Feeds
A new set of RSS feeds, hosted by PASS, bring you a large quantity of SQL Server content from various sites, including SQLServerCentral.
How to create Policies using PowerShell scripts
This article explains how to create policies with user defined conditions in MS SQL 2008 using PowerShell scripts
Leadership
Steve Jones talks about the need for leadership and what managers should be looking to achieve in their efforts.
The Cost of Data Loss
The cost of data loss is higher in the US than other countries. That's good and bad for DBAs.
TSQL Challenge 29 - Reorganize sales data by sales amount
Your job is to reorganize the items in the table by sales amount (quantity * price). Reorganize the items from left to right, bottom to top. The item with the highest sales amount should come on top left of each invoice.
Using REPLACE in an UPDATE statement
This article covers using the REPLACE function to selectively replace text inside a string in SQL Server. The REPLACE function is easy to use and very handy with an UPDATE statment.
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
In Part 1, we learned how to make both Cross-Tabs and Pivots. In Part 2, we'll learn how to automate a very common type of Cross-Tab report and maybe learn some extra tricks on the way.
Would You Like a Stay Interview?
For this Friday poll, Steve Jones talks about an interesting concept. The "stay interview."
A Perspective on Database Performance Tuning
Fundamentally, database performance tuning is done for two basic reasons, to reduce response time and to reduce resource usage, both of which can apply for any given situation. Julian Stuhler looks at database performance tuning, and why it remains one of the most important topics for any DBA, developer or systems administrator.
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
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...
How do I explain that SQL Server should not be used as a code repository?
This week my BI Developer colleague proudly showed me a new Power BI report...
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