Enhancing the readability of your code: Table aliasing in sql
When writing SQL, picking good tables aliases can greatly enhance the readability of your code
Mastering SQL Server Profiler - Part 2: Profiler Architecture
This module, part 2 of the online training course "Becoming a Profiler Master", discusses the inner workings of Profiler.
Protect and Monitor
How do you protect and monitor your databases? Auditing is one way, but Steve Jones thinks this subsystem in SQL Server needs to mature.
Checking Up on Developers
This Friday Steve Jones has a poll about developers. Help compile a good list of common mistakes made in SQL Server.
Checking Up on Developers
This Friday Steve Jones has a poll about developers. Help compile a good list of common mistakes made in SQL Server.
Checking Up on Developers
This Friday Steve Jones has a poll about developers. Help compile a good list of common mistakes made in SQL Server.
Patterns For High Availability, Scalability, And Computing Power With Windows Azure
Now, Internet-hosted distributed applications with connectivity to internal applications—often referred as Software plus Services (S+S)—are gaining popularity. Organizations are leveraging datacenters hosted by third parties to alleviate concerns about hardware, software, reliability, and scalability. These are just some of the new architecture trends that help you build interoperable applications that scale, reduce capital expenditure, and improve reliability. Cloud computing offers many of these benefits.
Scaling up vs. scaling out with SQL Server 2008
To scale your SQL Server properly means to make it bigger and better. But what is the best method for 2008?
When a Community Rallies!
I have been a bit lax these past few days, but I have been having a bit of a writers block not knowing what to write about. Well, I realized this evening there is something worth writing about, and it is happening right now on SQLServerCentral.com. An...
Flash
Flash. Flash Gordon. There have been a few "Flash"es in Steve Jones career, and the newest one looks interesting.
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
Alamat kantor resmi BCA KCU PLUIT Telp:083178278662
Telp:083178278662Landmark Pluit, Jl. Pluit Selatan Raya Blok A8, RT.8/RW.10, Pluit, Penjaringan, North Jakarta City,...
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...
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