Reading SQL Server's Transaction Log
This article shows how you can read the [RowLog Contents] in the Transaction Log, for Real!
2012-11-09 (first published: 2010-11-22)
32,305 reads
Articles
Script to create dynamic PIVOT queries in SQL Server
Pivoting is a common reporting requirement - data is stored in columns and you need to present it in rows. This was a nice feature that was added to SQL Server, but you don't always know all of the values you need to pivot on. This tip looks at how you can dynamically create the pivot command to handle these unknown values.
2012-11-09
5,308 reads
2012-11-08
3,223 reads
Partitioned Tables, Indexes and Execution Plans: a Cautionary Tale
Table partitioning is a blessing in that it makes large tables that have varying access patterns more scalable and manageable, but it is a mixed blessing. It is important to understand the down-side before using table partitioning.
2012-11-08
4,482 reads
2012-11-07
942 reads
SQL Server 2012: Installing Data Quality Services
Greg Larsen shows you how to install Data Quality Services and the companion client tool called Data Quality Client for SQL Server 2012.
2012-11-07
2,181 reads
Tracking Database File AutoGrowth with Event Notifications
As discussed in my previous Getting Started with SQL Server Event Notifications article, SQL Server Event Notifications allow us to capture and handle events that occur inside the SQL Server database engine. Event Notifications execute for DDL Events and Trace Events and we can use to capture information about the event that fired, and automate […]
2012-11-06
9,068 reads
Free eBook: SQL Server Hardware
A free eBook from SQLServerCentral and Red Gate software can help you learn about the best hardware for your SQL Server instances.
2012-11-06
5,763 reads
Using SQL Server Concatenation Efficiently
This article shares some tips on using concatenation efficiently for application development, pointing out some things that we must consider and look at when concatenating values or fields in our queries or stored procedures.
2012-11-06
3,661 reads
SSIS Basics: Using the Execute SQL Task to Generate Result Sets
The Execute SQL Task of SSIS is extraordinarily useful, but it can cause a lot of difficulty for developers learning SSIS, or only using it occasionally. What it needed, we felt, was a clear step-by-step guide that showed the basics of how to use it effectively. Annette Allen has once again cleared the fog of confusion.
2012-11-05
2,246 reads
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
BCA KCP Kramat Jaya Huby/WA 08218573837
Jl. Kramat Jaya Raya No.10 Blok F1, Semper Bar., Kec. Cilincing, Jkt Utara, Daerah...
BCA KCU TANJUNG PRIOK TLP/, WA 08216677749
Jl. Enggano No.22-23, RT.8/RW.16, Tj. Priok, Kec. Tj. Priok, Jkt Utara, Daerah Khusus Ibukota...
BCA KCP Jembatan Merah HUB/WA 08216977749
Jl. Raya Mangga Besar No.177 C, Mangga Dua Sel., Kecamatan Sawah Besar, Kota Jakarta...
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