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
Diagnose partitioning related data movement between file groups using Extended Events and Debug Symbols
2014-05-22
2,548 reads
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,030 reads
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
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
Ops and Development people have plenty of ideas for improving the whole software delivery process, but the task of developing, maturing and communicating these ideas isn't often in their...
2014-05-20
5,187 reads
Comparing columns of different data types can be a drain on resources, as well as our sanity. This is a look into a few strategies for dealing with implicit conversions.
2014-05-19
10,276 reads
In data mining and machine learning circles, the neural network is one of the most difficult algorithms to explain. Fortunately, SQL Server Analysis Services allows for a simple implementation of the algorithm for data analytics. Dallas Snider explains
2014-05-19
3,590 reads
This article attempts to explain RAID's impact on SQL performance.
2014-05-16 (first published: 2012-05-01)
38,019 reads
Having a well thought-out plan for diagnostic data is important for on-premises applications, but it is arguably more important for distributed, highly scalable cloud applications. Michael Collier has provided a clear introduction to Microsoft Azure Diagnostics, including the Diagnostics Agent and how to extract the data.
2014-05-16
2,747 reads
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
Whatsapp.083831617937 Jl. Pluit Selatan 200 Jakarta Utara, DKI Jakarta, Indonesia 14450
Whatsapp.083831617937 Jl. Enggano 22-23 Jakarta Utara, DKI Jakarta, Indonesia 14310
Using PowerBI Version1.25.9508.3237(January 2026). Installed Microsoft Power BI Desktop (Optimized for Power BI Report...
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers