SQL Server Logs - SQL School Video
Did you know that SQL Server maintains a great set of text logs about events on the server? MVP Andy Warren shows you how to get information out of the error logs in this SQL School video.
Active August posts
I've started a blog to write down and track my personal goals:
The Goal Keeping DBA
Since Active August is part of reaching my goal...
Attribute Discretization: Using the “Clusters” Method
Join BI Architect Bill Pearson as he leads hands-on practice with the “Clusters” discretization method in Analysis Services. In this article we continue to explore attribute discretization, as a part of an extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution.
Building an API
Is it better to build an API into your code and allow someone to "plug in" or provide them with source code? Steve Jones thinks the former is better and gives you a few reasons why.
Building an API
Is it better to build an API into your code and allow someone to "plug in" or provide them with source code? Steve Jones thinks the former is better and gives you a few reasons why.
Building an API
Is it better to build an API into your code and allow someone to "plug in" or provide them with source code? Steve Jones thinks the former is better and gives you a few reasons why.
Looking for Good (and Bad) SQL Server Blogs
I was asked to do an hour presentation during the 24 Hours of PASS, which takes place on Sept 2,...
SQL Server 2008 Analysis Services Performance Guide
Because Microsoft SQL Server Analysis Services query and processing performance tuning is a fairly broad subject, this white paper organizes performance tuning techniques into the following three segments.
Be a Craftsman
Is software engineering dead? Some well respected software developers have stated that, and one says we should be craftsman, not engineers.
Changing Table Schema – what goes behind the scenes – Part I
What happens behind the scenes when you alter a table schema? New author Alok Dwivedi dives deep into SQL Server to show us how things are affected.
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers