2014-05-27
1,130 reads
Articles
Optimizing Transaction Log Throughput
As a DBA, it is vital to manage transaction log growth explicitly, rather than let SQL Server auto-growth events "manage" it for you. If you undersize the log, and then let SQL Server auto-grow it in small increments, you'll end up with a very fragmented log. This article demonstrates how this can have a significant impact on the performance of any SQL Server operations that need to read the log.
2014-05-27
3,916 reads
Do We Still Need Database Design in the Era of Big Data?
Many big data application implementations seem to begin with an existing data warehouse, one or more new high-volume data streams, and some specialized hardware and software. The data storage issue is often accommodated by installing a proprietary hardware appliance that can store huge amounts of data while providing extremely fast data access. In these cases, do we really need to worry about database design?
2014-05-26
5,297 reads
The 5 Worst Days in a DBAs Life: Day 2
Steve and the rest of the DBA Team are back for round two. In this episode they have to restore all of a business' data using nothing but a set of off-site backups, kanban, and witty repartee.
2014-05-26
3,080 reads
Microsoft Azure Storage Queues Part 1: 360 Degrees
Microsoft Azure Queues are more than just a class or a concept – they're a ready-to-use service that loosely connects components or applications through the cloud. Roman Schacherl provides a helicopter overview of the service.
2014-05-23
2,227 reads
SQL Saturday #294 - Philadelphia
SQL Saturday is coming to Philadelphia on June 7, 2014. This event is a free day of training and networking for SQL Server Professionals, organized by the Philadelphia SQL Server User Group. The event also features two paid-for Precons, one presented by Allan Hirt and the other presented jointly by Joseph D'Antoni and Stacia Misner. Register while space is available.
2014-05-23
1,877 reads
Table Partitioning –XE Diagnostic for Data Movements
Diagnose partitioning related data movement between file groups using Extended Events and Debug Symbols
2014-05-22
2,542 reads
Write for SQLServerCentral
We are looking for new content here for the site, based on your experiences in the real world. Submit something and get yourself published.
2014-05-22 (first published: 2014-04-10)
2,029 reads
Producing JSON Documents from SQL Server queries via TSQL
Although SQL Server supports XML well, XML's little cousin JSON gets no love. This is frustrating now that JSON is in so much demand. Maybe, Phil Factor suggests, it is possible to leverage all that XML, and XPath, goodness in SQL Server to produce JSON in a versatile way from SQL Queries? Yes, it so happens that there are plenty of alternatives.
2014-05-22
8,456 reads
Extract and convert all Excel worksheets into CSV files using PowerShell
Can PowerShell provide an easy way to export Excel as a CSV? Yes. Tim Smith demonstrates that whether you have multiple Excel files, or just multiple worksheets in Excel, PowerShell simplifies the process.
2014-05-21
2,831 reads
Blogs
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers