Tracy Hamlin elected Exceptional DBA of 2010
Congratulations to Tracy Hamlin, voted to be the Exceptional DBA of 2010.
2010-08-23
1,543 reads
Articles
TSQL Challenge 37 - Calculate the downtime and duration of servers bas
This is a challenge to identify the downtime of servers from the log data generated by a monitoring application.
2010-08-23
1,518 reads
How to execute a DOS command when xp_cmdshell is disabled
For security reasons many sites disable the extended stored procedure xp_cmdshell, which is used to run DOS commands or executables. When you really have to run a DOS command or an executable from a stored procedure how can you get around this limitation without a breakdown in security.
2010-08-23
5,335 reads
Linking to the Previous Row
One common problem in querying is to reference the previous row in a data set as part of a calculation. David McKinney brings us an interesting solution using SQL Server 2005.
2010-08-20 (first published: 2008-03-13)
55,376 reads
Expert Analysis: A Case for Socialization of Data
It's time to integrate social data, enterprise analytics and enterprise data for better social-media strategy.
2010-08-20
1,748 reads
Convert Mirroring to Log Shipping
Describes how to convert database mirroring to log shipping in SQL 2005/2008.
2010-08-19
6,092 reads
Additional Columns in StreamInsight Event Flow Debugger
This tool is excellent when investigating what is going on in your StreamInsight Streams. I was looking through the menu items recently and went to Query => Event Fields I found that there were a couple of columns not added by default to the event viewer (Reminds me of the fact that the Variables viewer in SSIS hides columns also) Latency NewEndTime EnqueueTime Here they all are together. This gives us even more information about what is going on
2010-08-19
1,579 reads
Can you set a pagefile more than 4GB?
Can you set a pagefile on a Windows machine to more than 4GB? Stanley Chan shows us how after an issue with a crashed Windows machine.
2010-08-18
8,643 reads
Run SQL Command Against Multiple Instances Without CMS
I understand that I can use Central Management Servers to run a T/SQL query against multiple instances at once - can I do this without CMS though?
2010-08-18
3,181 reads
Beginning SQL Server
A presentation by Steve Jones that talks about the technical basics of what SQL Server is and how it works with some hints about backups, security, and more.
2010-08-17
290 reads
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