Clearing the Bar
How do you decide who gets hired? Do you get the best candidate? Steve Jones says that most of us don't necessarily hire the best person that applies for a variety of reasons.
SQL Server Database Development Methodologies using SQL Compare
This 3-part sponsored article surveys several different methodologies for database development, examines their strengths and weaknesses, and illustrates how Red Gate's comparison tool, SQL Compare, can be incorporated into each model.
Tracking Illicit Users
Longtime SQL Server guru David Poole brings us a look at one of the thorny problems a DBA faces: tracking down illicit users.
Application Locks (or Mutexes) in SQL Server 2005
Application locks aren't a well known area of locking in SQL Server, but they can be very useful for special scenarios. They work in an analogous way to the lock() construct in .Net and are basicaly user defined mutexes in SQL Server.
Billee-yons and Billee-yons of Gigabytes - iPod
The amount of data in the world grows every day and there's no end in sight. How big a problem is storage management? Steve Jones shares a few thoughts on how you might manage your storage.
Billee-yons and Billee-yons of Gigabytes - MP3
The amount of data in the world grows every day and there's no end in sight. How big a problem is storage management? Steve Jones shares a few thoughts on how you might manage your storage.
Billee-yons and Billee-yons of Gigabytes - WMV
The amount of data in the world grows every day and there's no end in sight. How big a problem is storage management? Steve Jones shares a few thoughts on how you might manage your storage.
Expert DBA tips in 3 posters
An offer from Red Gate for free downloadable posters. You can print them out and decorate your cube, showing some great disaster recovery tips from MVP Brad McGehee.
It's All About the Data
It would be wonderful to be able to simple purchase a tool or technology and have your data challenges disappear. It is time to step back and take a much needed different look at data.
Altering a column on a Replicated Table
SQL Server 2000 replication is usually simple and easy to setup and work with. However there are many restrictions to ensure this, one of which is the alteration of a column which is engaged in replication. Author Paul Ibison brings us two options for altering columns.
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
BRI KANCA JAMBI WhatsApp 08980343752
<!--more-->BRI KANCA JAMBI WhatsApp 08980343752 Jl. Dokter Sutomo No.12, Ps. Jambi, Kec. Ps. Jambi,...
Alamat kantor resmi BCA KCP Jelutung
WhatsApp:0817875533 Jl. DI Panjaitan No.38-40, RT.22, Kebun Handil, Kec. Jelutung, Kota Jambi, Jambi 36137
BCA KCU DAAN MOGOT Telpon. 08388331767
WhatsApp 08388331767 Jl. Daan Mogot No.95, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat,...
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