DDL Auditing using the Default trace
This article explains how default trace can be used for auditing purposes when combined with PowerShell scripts
2015-05-05
4,414 reads
Nagaraj Venkatesan
How to Size the SQL Server Memory & Why is it important?
The following blog post has 2 objectives.
1) How to size the memory correctly ( or atleast being close to correctly )
2)...
2013-05-27
2,912 reads
Xp_readerrorlog in SQL Server 2012
I have always been a big fan of Xp_readerrorlog. The simple reason is that it much faster to read errorlog...
2013-05-16
1,559 reads
When was the last successful backup?
What is the fastest and perhaps easiest way to find the last successful database backup?
Just right click on the Database...
2013-03-01
381 reads
SQL Server Memory Usage - Task Manager
Another question I have answered 100s of times to Non SQL folks. "SQLServr.Exe is consuming 80% of memory. Can you...
2012-05-20
1,437 reads
Sysprocesses CPU and CPU Percentage - utilization
I am not sure how many of you have faced this situation? I have faced it many many times. Somebody...
2012-04-23
1,239 reads
Calling Function / UDF using linked server
If one needs to call a UDF or System function ( ex: Serverproperty, Getdate(), etc ) on a remote server, then one...
2012-04-08
2,988 reads
Inserting UniCode / Special characters in tables
Consider the situation where one needs to store multilingual data / Special characters into a table. For example Chinese characters or...
2012-03-27
7,823 reads
File Group Backups - Intro
What is File Group backup?
Backing up a portion of a database, say a File Group is termed as Filegroup...
2012-01-13
492 reads
Log file size after backup and restore
Quick summary of the post:
A restoration of a full database backup retains the log file size before restoration.
Now...
2011-11-01
510 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
BCA KCP Samarinda Seberang TLP/WA 08216977701
Jl. Bung Tomo, RT.001/RW.01, Baqa, Kec. Samarinda Seberang, Kota Samarinda, Kalimantan Timur 75132
ANT Bank BCA 8547-Matraman, Telpon/wa 0821-3111-159
Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta Timur, Daerah Khusus...
BCA KCP Slamet Riyadi TLP/WA 08216366654
Jl. Slamet Riyadi, Karang Asam Ulu, Kec. Sungai Kunjang, Kota Samarinda, Kalimantan Timur 75126
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