No, I do not provide childcare at my technology events...
A guest editorial from Julie Yack looks at the difference between men and women from the perspective of one very successful woman in technology.
Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 - Part 1
The first in this three part series on using Microsoft Assessment and Planning (MAP) Toolkit 5.0 introduces the toolkit and gets started with install and using it.
October Question: Tell us about your favorite experience as a participant in the SQL Server community.
There is a thriving world-wide DBA community that offers many opportunties meet other DBAs, to learn from others, and to...
The One True Script
Phil Factor less-than-fond memories of the days of the One True Source Script. However, despite recent advances, he wonders just how much smoother team-based database development really is.
TSQL Challenge 40 - Convert string representation of numeric values fr
This challenge involves converting numeric values from binary format to hexadecimal format.
Women and Men - Same or Different?
Today we have a guest editorial from Wendy Pastick, co chair of the Women in Technology Virtual Chapter. Today Wendy takls about how men and women handle their careers.
Standardize data storage for geography spatial data type in SQL Server
Geography is one of the spatial data types introduced in SQL Server 2008. One of the characteristic of the geography data type is that it can accommodate any supported geometry based on any supported spatial reference system in the same field. So if the data that is stored in a column of geography data type is not standardized, it can be a very tedious and resource intensive task to figure out the geometry and spatial reference system associated with each value. To deal with this issue, we need to standardize the data stored in a field of that has the geography data type and in this tip we will look at how to deal with this issue.
The Lone Ranger And Data Integrity
Many IT Pros can relate to the the Lone Ranger. With the aid of but one trusty side kick, the...
Partitioning in SQL Server 2008
This article discusses about 'Partitioning'. In this detailed article, a particular emphasis is placed on the implementation of Partitioning in SQL Server.
PowerShell Version 2: What is new and why is it important?
It was a year ago that Microsoft shipped PowerShell 2. Jonathan Medd lists the top ten reasons why PowerShell 2 should be an important tool for your work
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 THAMRIN Telp:083178278662
Telp:083178278662Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng, Kota Jakarta Pusat,...
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...
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