Come to the Charleston PASS SQL Server User Group
The Charleston, SC PASS chapter is looking for speakers and new members. Read more and come to the Sept 20 meeting if you are near the area.
2011-09-19
1,647 reads
Articles
Storing Windows Event Viewer Output in a SQL Server table with PowerShell
Laerte Junior was asked for a quick and easy way to save the output from the Get-EventLog cmdlet in a SQL Server table. Luckily, he already knew about Chad Miller's excellent Out-DataTable and Write-DataTable functions, and has laid out everything we need to use them like pros.
2011-09-19
2,003 reads
Are you using Microsoft’s Azure platform?
We are conducting new product research and are keen to speak to people who have any experience (good or bad!) using Microsoft's SQL or Windows Azure. If you're interested and would like to get involved--tell us your frustrations, shape a new product, test-drive betas etc
2011-09-16
2,130 reads
Statistics on Ascending Columns
It comes as rather a shock to find out that one of the commonest circumstances in an OLTP database, an ascending primary key with most querying on the latest records, can throw the judgement of the Query Optimiser to the extent that perfomance nose-dives. Fabiano Amorim once again dons snorkel and goggles to explore the murky depths of execution plans to find out why.
2011-09-16
2,528 reads
2011-09-15
11,686 reads
2011-09-15 (first published: 2009-10-07)
8,038 reads
Adding Custom Code to the Reporting Services 2008 R2
There are numerous circumstances when we wish to add a custom function to a SSRS report in order to cater for needs of the customer which exceeds the capability of the built-in functions in SSRS. In these scenarios we will have to write our own functions. In this article you will see how to add custom code to SSRS.
2011-09-15
3,644 reads
Architecture Career Paths for SQL Server Professionals
On Thursday September 15th, MCM Robert Davis will discuss the architect jobs and their meanings.
2011-09-15
2,899 reads
Jeff Moden elected Exceptional DBA of 2011
We are pleased to announce that Jeff Moden has been elected by judges and the SQL Server community as the Exceptional DBA of 2011.
2011-09-14
1,300 reads
SQL Bits 9 - Query across the Mersey
Come join Steve Jones and many other SQL Server pros in Liverpool for SQLBits on Sept 29-Oct 1.
2011-09-14
1,372 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
Forums
Having Issue deploying a report to an on prem server from PowerBI desktop
Using PowerBI Version1.25.9508.3237(January 2026). Installed Microsoft Power BI Desktop (Optimized for Power BI Report...
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
Question of the Day
How Long is a Long I/O?
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