Bill Baker - Database Weekly (Aug 11, 2008)
This weeks Database Weekly looks at a longtime leader for the Microsoft SQL Server development team leaving the company.
Bill Baker - Database Weekly (Aug 11, 2008)
This weeks Database Weekly looks at a longtime leader for the Microsoft SQL Server development team leaving the company.
Bill Baker - Database Weekly (Aug 11, 2008)
This weeks Database Weekly looks at a longtime leader for the Microsoft SQL Server development team leaving the company.
Mastering OLAP Reports: Parameterizing Number of “Top” Items with the MDX TopCount() Function, Part I
Writing high-performance reports against Analysis Services cubes means learning MDX to some extent. Parameterization of MDX functions is one of those things that cannot be delivered solely via graphical MDX Editor. BI Architect Bill Pearson demonstrates a way to parameterize the highly useful TopCount() function.
Processing XML Showplans Using SQLCLR in SQL Server 2005
Build an application to extract a query's estimated execution cost from its XML showplan. Users can submit only those queries costing less than a predetermined threshold to a server running SQL Server 2005, thereby ensuring it is not overloaded with costly, long-running queries.
Viewing Analysis Services Data in Excel 2007 - SQL School Video
Excel is a wonderful tool for examining the data in your SSAS cubes. MVP Brian Knight shows how you can access the data in Analysis Services or a SQL Server database from Excel 2007.
Calculating Mathematical Values in SQL Server
In our application we have the need to perform mathematical calculations. Right now we are doing so in our front end application. Unfortunately we are starting to experience performance problems with large data sets and differences in calculations due to developers using different logic. We are seeking some other options to perform the calculations. Does SQL Server perform basic mathematical calculations?
SQL Server 2005 Express Edition - Part 27 - Implementing Basic Service Broker Objects
Marcin Policht explains the interaction of the primary elements of Service Broker's asynchronous messaging framework and describes a process of setting up the database objects necessary to demonstrate their sample implementation (which will be the subject of our next article).
Blogs
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...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
Forums
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
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers